MDX statement error

[Former Member]

Hi Experts

I intend to write a member formula simply being (A+B)/C

So in the planning and admin console, I have written a member formula as follows;

[A]+[B]/[C]

Where [A] and [B] are parent members

[C] is a base member

I can process the dimension successfully, however when I add the specific member into an input form in the excel interface, I was prompted with an "MDX statement error: "value xxxxxxx/CPMB/XWDZYD3 for characteristic /"

I then edit my formula into

[ACCOUNT].[A]+[ACCOUNT].[B]/[ACCOUNT].[C]

dimension processed successfully, but still prompted with the same error.

Please give some advice! as member formula function plays a role in the current model we are trying to build!

your advice is much appreciated

Best Regards

[Former Member]

Hi Robert,

Please refer note 1810506.

Resolution

For BPC NW 10 SP09, apply Note 1809823 to fix the issue.

The issue will be fixed in BPC NW 10 SP10 that is scheduled to be released on April 30 2013.

See Also

• See Note 1809823 (MDX error 'Value XX for XX unknown' or 'Node not authorized')
• See Note 1779357 (Business Planning & Consolidation 10.0 NW SP10 Central Note)

Regards,

Kalyan.

[former_member186338]

Hi Robert,

What are the real names of the members A, B and C (there is an issue with some names for some SP level). Please update to the latest SP!

The formula like IIF([C]=0,NULL,([A]+[B])/[C]) is correct in general.

B.R. Vadim

[arun_varghese]

1)

If u want (A+B)/C to be the format, I guess, you have to change your Dimension Member Formula to  ( [ACCOUNT].[A]+[ACCOUNT].[B] ) /[ACCOUNT].[C]

Because when brackets are not used, I guess the B/C works 1st and then gets added to A.

2)

Can you give specific details of at what particular point you are receiving the error in the Input Form? Is it after inputting data and submitting it.?

[Former Member]

Hi Robert,

Are you on BPC 10?, if you want to use that formula just for one model, why dont you use local members instead of Dimension member formula?, is actually simpler and easier; dimension member formulas will decrease your performance.

Regards,

Aldrin Liendo