dimension member Formula : calculate sum based in properties

[Former Member]

hi all !

I have a dimension account where I want to sum all the element which have the following property :

FF_FV=FF

I tried the following formula for the account FF :

SUM([ACCOUNT].[AST999_TOT_RESULTAT],properties("FF_FV")="FF")

// [AST999_TOT_RÉSULTAT] is the top of my account hierarchie (H1)

The formula is correctly processed by when i put FF account in my report the following error occured :

Server message:

code: UJO_READ_EXCEPTION_018

severity: error

description: Erreur d'instruction MDX : Une exception du type CX_SY_CONVERSION_NO_NUMBER est survenue mais n'a été ni traitée localement, ni déclarée par une clause RAISING.

log id: 051MfHnL7kM3kq4LcOKrv0

DATAVALUE:Une exception du type CX_SY_CONVERSION_NO_NUMBER est survenue mais n'a été ni traitée localement, ni déclarée par une clause RAISING.

MDX:

Where is the problem in my formula ?

Thanks in advance !

[former_member186338 · Accepted solution]

Hi Fabrice,

It's a wrong idea, use additional hierarchy to get sum of some base members... Property will not work.

Vadim

[Former Member · Accepted solution]

I can't use another property because there already 3 complex hierarchies !

The dimension member formulas can't do the job ?

[former_member186338 · Accepted solution]

"The dimension member formulas can't do the job ?" - No!

"already 3 complex hierarchies" - add 4th!

Vadim

[former_member186338 · Accepted solution]

If you have limited number of members - you can add them directly in the formula:

=[XXX1]+[XXX2]+...

Vadim