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: 459
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