MDX and 1.#INF (Infinity)

There’s a knock at the door, its one of your users asking what the 1.#INF value is showing in today’s report.

The official reply is “There’s a problem with the server” … this will buy you enough time to race back to your SSAS solution and make the following adjustment to your calculation and redeploy before the user gets back to their desk… 🙂 We need to check if Measure B is 0 (to make the calculation null) otherwise carry out the division as normal.

IIF(
Measures.[Measure B]=0,null,
Measures.[Measure A] / Measures.[Measure B]

)

Scenario explained here …

http://msdn.microsoft.com/en-us/library/ms144717.aspx

A twist on this scenario here, the solution involving checking if the parent member is null …

Thomas I Blog

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

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