Search type Search syntax
Tags [tag]
Exact "words here"
Author user:1234
user:me (yours)
Score score:3 (3+)
score:0 (none)
Answers answers:3 (3+)
answers:0 (none)
isaccepted:yes
hasaccepted:no
inquestion:1234
Views views:250
Sections title:apples
body:"apples oranges"
URL url:"*.example.com"
Favorites infavorites:mine
infavorites:1234
Status closed:yes
duplicate:no
migrated:no
wiki:no
Types is:question
is:answer
Exclude -[tag]
-apples
For more details on advanced search visit our help page
Results tagged with Search options user 39384

A database system optimised for reporting, particularly in aggregate. Often, but not always implemented using a star schema.

7
votes
I'll weigh in from the user perspective. I have worked extensively (15 or so projects) with one of the automation tools on a SQL Server backend, and results were mixed. Did the DWA tool greatly redu …
answered Feb 11 '16 by Tom V - Team Monica
2
votes
I have no idea why the columns changed appear twice and neither does google apparently. With regards to the changes on the columns on the other hand your best option would be to compare the data type …
answered Oct 18 '15 by Tom V - Team Monica
1
vote
Not all .dat files are the same and it's hard to determine from the screenshot what the format is. If you extracted that from a telecom switch, you will need to contact the telecom vendor to ask if t …
answered May 12 '15 by Tom V - Team Monica
3
votes
You should add the address to the user/store dimension as the address is a property of the dimension member, not the fact record. Adding the address to the dimension allows you to define attribute re …
answered Mar 13 '18 by Tom V - Team Monica
7
votes
If you only have those tables there will be little difference between your datawarehouse star schema and your actual schema. You probably have a much more complex relational schema though, where you …
answered Jan 31 '18 by Tom V - Team Monica
3
votes
I don't think you will run into a lot of problems when querying your data warehouse except for the one you already stated (cross fact queries) although if you are aware of how your design is done and …
answered Mar 19 '18 by Tom V - Team Monica
2
votes
There is something to say for both approaches. I usually prefer to have this situation in a single dimension so you can define attribute relationships that allow the engine to calculate bitmap indexes …
answered Aug 23 '16 by Tom V - Team Monica
4
votes
If you are worried about index fragmentation (which really only matters if you are doing range scans off disk) but you are loading your data periodically during an ETL process I'm assuming you have yo …
answered Aug 3 '18 by Tom V - Team Monica
10
votes
These terms are not new to SQL 2016, but they are also not server roles as far as I know. For all i know these are pre-built Parallel Data Warehouse resource classes. There isn't much documentation …
answered Jun 9 '15 by Tom V - Team Monica
4
votes
I would steer clear of the 3 option. It's called a snowflake instead of a star schema. It's a rather advanced solution which can be used when necessary but has it's own drawbacks. As usual refer to Ki …
answered Nov 14 '17 by Tom V - Team Monica
2
votes
The answer you quoted is worded a bit confusing but it says that it improves the performance of processing the cube, not querying it. So the point is, create appropriate indexes on source tables t …
answered Apr 2 by Tom V - Team Monica
1
vote
What I believe you are really looking for is ragged hierarchies A ragged hierarchy is a user-defined hierarchy that has an uneven number of levels. Common examples include an organizational char …
answered Oct 15 '15 by Tom V - Team Monica
3
votes
It's hard to give you a specific guidance on your best setup, but in any case there is no such thing as a trigger writing to an OLAP cube. I can give you some starting points though. You need to loo …
answered Jun 17 '15 by Tom V - Team Monica
2
votes
This is an overly broad question but SSAS has security features that allow you to shield data for certain users. You should look into Roles and Permissions. Since you are talking about shielding cos …
answered Nov 9 '17 by Tom V - Team Monica