Error on member formula

[Former Member]

Hi,

we have a number of accounts with member formulas in our system. So far this worked fine according to the users. However when we set up a few new ones and tested them, we got an error message.

We have some member formulas that simply add / subtract accounts. These all work fine.

Then we have some where we reference the accdetail (flow) dimension and these now cause errors. The error occurs not when processing the formula, but when trying to show the account on a report. The error is:

code: UJO_READ_EXCEPTION_018
severity: error
description: MDX statement error: An exception with the type CX_SY_CONVERSION_NO_NUMBER occurred, but was neither handled locally, nor declared in a RAISING
log id: 051MbLEB7jMnkGcJzobr7m
DATAVALUE:An exception with the type CX_SY_CONVERSION_NO_NUMBER occurred, but was neither handled locally, nor declared in a RAISING
MDX:
V1:An exception with the type CX_SY_CONVERSION_NO_NUM
V2:BER occurred, but was neither handled locally, nor
V3: declared in a RAISING
V4:

Has anyone got an idea how to solve this?

Thanks,

Arnold

[former_member186338 · Accepted solution]

Hi Arnold,

The formula with issue, please!

Vadim

P.S. And SP for BPC and BW...

[Former Member · Accepted solution]

Hi Vadim,

the formula (for account N380499) is

[K380400],[ACCDETAIL].[F_350]*[K380401]

none of those elements is a summation element.

SP will follow ...

[former_member186338 · Accepted solution]

Based on your e-mail:

the formula (for account N380499) is

Not: [K380400],[ACCDETAIL].[F_350]*[K380401]

But: ([K380400],[ACCDETAIL].[F_350])*[K380401]

Vadim

[former_member203770]

Hi Arnold,

Please insert the Account dimension name before its member, similar to the ACCDETAIL dimension.

Hope this will rectify the error.

Thanks,

Harshit

[former_member186338]

Hi Harshit,

Please don't propose incorrect things. For dimension member formula the account type dimension name can be omitted.

Vadim

[former_member203770]

Hi Vadim,

I know, as per the standard sap documentation, Account dimension name, in this case can be omitted, but i also got the similar kind of issue once which was then corrected after following the above mentioned approach.

Thanks,

Harshit

[former_member186338]

Ups, never have the issue with missing account dimension name...

[former_member186338]

Just tested on the ENVIRONMENTSHELL:

([PL110],[FLOW].[Other])/[PL120]

No issues, working absolutely correctly!

Vadim

[Former Member]

Hi,

we inserted the round brackets but not the dimension name and it now works. Thanks.

[Former Member]

Forgot to mention, we are on BPC 10.1