Create measures in designer WITH SAP BW AS DATASOURCE...

[Former Member]

Hello dear collegues !

I'm trying to create a mesure in Designer (the universe is based on a multiprovider in SAP BW 7.0)... but the synthax of the formula is turning me crazy.

I'd like to do something very simple: in the select part of the created measure, I try to multiply an existent measure (from the cube) per 2:

[Measures].[EIEINPREI] * 2

I become a XML error message.

Did everybody already manage a new measure in a universe to introduce, which is based on a SAP environment ??

Thank you very much !

[former_member142702 · Accepted solution]

Hi Merryl,

<EXPRESSION>@Select(<Class>\<Key figure>)*2</EXPRESSION>

You should replace <Class> with the name of the class where your key figure is defined in and

<Key Figure> with the name of your key figure as shown in your universe designer.

Regards,

Stratos

[Former Member · Accepted solution]

Hi Stratos !

It's a pleasure to see that you're active on the forum ! I already saw some of your answers to others colleague... very funny !

So, thank you for the trick, as usual, it worked: I had to write it so:

<expression>(Kennzahlen\[Measures].[EIEINPREI])*2</expression>

It also works so:

<expression>[EIEINPREI]*2</expression>

Without the XML Tag I couldn't do anything...

Could you indicate me further ressources to see examples of Designer implementations on a SAP BW Basis ?

Thank you !

[former_member142702 · Accepted solution]

Hi Meryll,

I am glad that I could help:

Try the following documents:

[http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf]

Version XI 3.0

[http://help.sap.com/businessobject/product_guides/boexir31/en/xi3-1_sap_olap_universes_en.pdf]

Version XI 3.1

Regards,

Stratos