SubStr function in Universe on BEx Query

[Former Member]

Hi SAP BO experts,

We have a universe based on SAP BEx Query with an object "WBS Element", a 24 Character field from which we need to resolve certain sections as different objects for reporting purpose. One of the objects required is first 8 chars (WBS Project No.) Following code is used in object definition.

<EXPRESSION>Substr(@Select(WBS Element\WBS Element), 1, 8)</EXPRESSION>

Parsing is OK at universe level.

Webi query without "WBS Project No" is running OK but when "WBS Project No" is used, I get an error - invalid MDX command (WIS 10901).

What is the correct syntax? Any input will be appreciated.

Thanks in advance.

Venkat

[Former Member]

You can-not return characteristics via <EXPRESSION> tag.

In fact right now it is not possible to do substring and similar operations. You can only create objects which returns numeric

value.

Regards,

Rohit

[Former Member]

Thank you Rohit. I have realized it after going through various forums.

Are you aware of any work around.

Venkat