Substring @ SAP BO XI3.1 Sp2 OLAP Universe

[Former Member]

Hi any body address solution for below problem

[GCOSTCTR].[LEVEL01].[[4GCOSTCTR]].[Value] is the object select class and the out put is:0100/10101223 but I need 10101223 while selecting as a promt @ report level.

Provide me the Mxd statement for this using substr or is there any alternate solution.

[Former Member · Accepted solution]

Hi,

Unfortunately this is not possible with SAP.

You hit one of the major limitation: calculated expression MUST return NUMERIC values.

In your case although the result seems to be numeric, SAP interprets it as a string and returns an error.

According to my knowledge only SAP Exit are valid to achieve such requirements.

Regards

Didier