Hi,
I have a requirement for which i need to write an MDX. The scenario is, i have a fact table with dimensions. The FactStudent consists of keys from dimensions like location, ranks dimension and period dimension. i want to know the students who have got same rank for an year and previous year (to check consistency in performance). how should be the MDX for getting this info.please help.
Thanks & regards,
Vivek S
Some reading for you
http://www.databasejournal.com/features/mssql/article.php/10894_2238011_1
Bit outdated, but you should be able to use the basics with AS2005 as well.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment