Friday, February 24, 2012

can any one help in writing quries to sqlserver 2005 analysis service

I just want to calculate the measures using functions ie i want to calculate the YTD MTD and QTD . Can anyone help me out

Have you tried using the time intelligence wizard to do this? Depending on the service pack that you have it may not write the mose efficient MDX, but at least it should get you started.

No comments:

Post a Comment