Question Re: Error on member formula in Financial Management Q&A

Error on member formula

Former Member — Thu, 28 Jan 2016 14:25:06 GMT

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

Re: Error on member formula

Former Member — Thu, 28 Jan 2016 14:25:33 GMT

Forgot to mention, we are on BPC 10.1

Re: Error on member formula

former_member186338 — Thu, 28 Jan 2016 14:31:28 GMT

Hi Arnold,

The formula with issue, please!

Vadim

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

Re: Error on member formula

Former Member — Thu, 28 Jan 2016 14:37:08 GMT

Hi Vadim,

the formula (for account N380499) is

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

none of those elements is a summation element.

SP will follow ...

Re: Error on member formula

former_member186338 — Thu, 28 Jan 2016 14:46:07 GMT

Based on your e-mail:

the formula (for account N380499) is

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

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

Vadim

Re: Error on member formula

former_member203770 — Mon, 01 Feb 2016 11:22:47 GMT

Hi Arnold,

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

Hope this will rectify the error.

Thanks,

Harshit

Re: Error on member formula

former_member186338 — Mon, 01 Feb 2016 12:11:44 GMT

Hi Harshit,

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

Vadim

Re: Error on member formula

former_member203770 — Mon, 01 Feb 2016 13:05:17 GMT

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

Re: Error on member formula

former_member186338 — Mon, 01 Feb 2016 13:07:21 GMT

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

Re: Error on member formula

former_member186338 — Mon, 01 Feb 2016 13:31:17 GMT

Just tested on the ENVIRONMENTSHELL:

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

No issues, working absolutely correctly!

Vadim

Re: Error on member formula

Former Member — Tue, 02 Feb 2016 09:13:55 GMT

Hi,

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