|
|
|
|
|
|
by 7thaccount
1747 days ago
|
|
|
Thanks this helps. It seems like it shines when you have a lot of non technical staff requesting the data. At my job, the data analysis folks have to write complex ad-hoc queries all the time. We store the queries for consistency reasons (e.g. to make sure we can be consistent and run the same query each year for the same report) It seems like OLAP wouldn't be a good fit there. |
|
|
That's a good way of looking at it.
Consider the cube as the end product of a process of automating data the business needs to make decisions. It starts with "How much did we sell yesterday?" and expands to include week-over-week/year-over-year comparisons, breakdowns by category, leaders/losers and other frequently looked at answers.