Edit an object's select statement of OLAP universe SAP BW

[Former Member]

Hi everybody

I am new at working with Olap Universes BW, and I have to edit one universe SAP BW, I don't know if I can to use substring function on a select statement, for example substring([0D_DIV].[LEVEL01],5,5), I try to use this function but I have a error,

Could you help me? I need to returns part of a string, is correct to do it on a universe or is better to do at BW.

[Former Member · Accepted solution]

Hi,

First of all I recommend you read the documentation that gives you information about OLAP universes and especially SAP BW universes.

I also recommend to download documents related to SAP universes deployment, administration and customization:

[OLAP Universes - how to samples and recommendations |https://wiki.wdf.sap.corp/wiki/display/globalregions/OLAPUniverses-howtosamplesand+recommendations]

[SAP Integration |https://wiki.wdf.sap.corp/wiki/display/globalregions/SAP+Integration]

Now you can customize expression using MDX in OLAP universes. MDX expressions must be enclosed with <EXPRESSION></EXPRESSION> XML tags.

Unfortunately SAP BW MDX does not support calculations that return string or date values.

The onlyway to return string is to use NAME or UNOIQUENAME attribute.

See answers I already in the forum: [Forum answer |]

Regards

Didier

[Former Member · Accepted solution]

Thanks Didier,

I have much to learn, but I try to open the link of documentation, but appears the next message: internet explorer can not display the page,

the urls are:

(https://wiki.wdf.sap.corp/wiki/display/globalregions/OLAPUniverses-howtosamplesand+recommendations)*

(https://wiki.wdf.sap.corp/wiki/display/globalregions/SAP+Integration)*

You know others ways how I can do to download this documentation?

Thanks in advance

Monica

[Former Member · Accepted solution]

Hi,

Do you have an SDN account?

Here is another link for [OLAP Universes Best Practices: How to, recommendations, samples|;

I do not have public links for other documents (I knwo that some of there are public).

Redgards

Didier

[Former Member · Accepted solution]

Thanks, for all your help.

Monica