cancel
Showing results for 
Search instead for 
Did you mean: 

New Calculated measures with reverse sign on a univ/BEx with a structure

Former Member
0 Kudos

Hi,

Trying to create a new calculated measure in my universe that is supposed to flip some values.

The new key figure setup looks like this :

Type : NUMERIC

Select: <EXPRESSION>@Select(Key Figures\Actuals YTD)*-1</EXPRESSION>

Measure object

Associate a list of values is deselected.

Function : Database delegated

When doing this on a BEx query/universe without the structure it works fine, and opposite when doing it on

one with a structure i dont get any data !.

Version : BOBJ XI 3.1 Service Pack 2

Any suggestions ?

Rgds,

Kim

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

I confirmed that it doesn't work after having tested it.

I copied the generated MDX and also tested it on MDXTEST transaction (SAP Frontend) and I obtained also no result for the calculated expression.

It seems that it is a limitation of SAP MDX. Maybe there are relative SAP notes to this limitation.

I suggest to enter a support case and mention that it is linked to SAP MDX support.

Regards

Didier

Answers (0)