on 08-24-2010 5:01 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
89 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.