#Error value in AX Enterprise Portal KPIs list

clip_image002

When we browse AX Enterprise Portal website, we may find the Indicator Gold and Actual value is shown #Error.

It does not mean that the AX cubes has been processed with some errors.

For example:

Accountant Operational Efficiency Web Part

Actual MDX Code

(

SUM

(

YTD([Ledger period time dimension].[Ledger Period Hierarchy].CURRENTMEMBER),

([Measures].[Master Amount – Ledger],[Ledger account descriptions].[Ledger account categories].&[4])

)

/

(

(

(-1)*([Measures].[Master Amount – Ledger],[Ledger account descriptions].[Ledger account categories].&[33])

([Measures].[Master Amount – Ledger],[Ledger account descriptions].[Ledger account categories].&[34])

)

)

)

*

IIF(

[Ledger period time dimension].[Ledger Period Hierarchy].CURRENTMEMBER.CHILDREN.COUNT = 0,

1,

[Ledger period time dimension].[Ledger Period Hierarchy].CURRENTMEMBER.CHILDREN.COUNT)

In the MDX Code:

(-1)*([Measures].[Master Amount – Ledger],[Ledger account descriptions].[Ledger account categories].&[33]) –

([Measures].[Master Amount – Ledger],[Ledger account descriptions].[Ledger account categories].&[34])

If there is no data in those two columns, the value is 0. Any value divided by 0 should reach to Infinity. That can be got through SSMS:

clip_image002[8]

The way to fix the #Error value issue is to add condition code in MDX to avoid the loop.

Hope Microsoft can fix the issue in the next AX version or AX 2009 hotfix.

Advertisements
This entry was posted in Microsoft Enterprise Portal. 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 )

Google+ photo

You are commenting using your Google+ 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 )

w

Connecting to %s