Is this overkill? Using MDX queries and cubes instead of SQL stored procedures

Posted by Jason Holland on Programmers See other posts from Programmers or by Jason Holland
Published on 2012-06-14T16:58:03Z Indexed on 2012/06/15 21:24 UTC
Read the original article Hit count: 418

Filed under:
|
|

I am new to Microsoft's SQL Server Analysis Services Cubes and MDX queries. Where I work we have a daily sales table in SQL Server 2005 that already contains an aggregate of sale information per store per day. At this time it contains only 164,000+ rows. We have a sales cube dedicated to this table that about 15 reports are based off of. Now, I should also note that we generate reports based on our own fiscal year criteria: a 13 period year (1 month equals 28 days etc.).

Is this overkill? At what point is it justified to begin using SSAS Cubes/MDX over plain old SQL Server stored procedures? Since I have always been just using plain old SQL am I tragically late to the MDX party?

© Programmers or respective owner

Related posts about sql

Related posts about sql-server