MDX YTD Calculation Issus

If you are using the templates for MDX calculation built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008.

clip_image002

My first thought was data issue. After querying the table and finding no issues I returned to the MDX calculations in the cube and started trouble shooting. Here is what I found. The format string is set to standard when you drag over the Period to Date template.

clip_image004

But the word standard does not have double quotes around it. If you click on the drop down menu and select standard it has the double quotes around it.

clip_image006

This fixed my problem.

clip_image008

Advertisements
This entry was posted in mdx, SSAS, Syndication and tagged , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s