Functions applied to BW Objects in Designer

[Former Member]

Hi All,

I have cubes in BW that I want to Query in Webi

The structures appears in Designer, and the question is can I apply Functions to the Objects representing the structures?

With Relational RDBMS, I can use SQL functions, but with BW Queries, I have a message telling me I need to do XML.

Can I apply functions to the Measures and Dimensions and if yes waht kind of language?

Many Thanksfor your answers

Vince

[Former Member · Accepted solution]

Hi,

Since BOE XI3.0 we can create calculated measures in MDX. We also support Designer functions such as @Select, @Prompt and @Variable to enrich the objects definition.

Olap universes use and generate XML and use MDX for calculated measures.

I suggest that you have a look on the follwing URLs that give you help on how to cutomize OLAP universes:

[Link 1|https://wiki.wdf.sap.corp/wiki/display/globalregions/OLAPUniverses-howtosamplesand+recommendations|]

[Link 2|https://wiki.wdf.sap.corp/wiki/display/globalregions/OLAPuniversesonSAPNetweaverBW-Metadataanddatatypes]

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

Didier

[Former Member · Accepted solution]

Hi All

Many thanks for your answers

best Regards

Vince

[former_member142702]

Hi,

which version of BOBJ do you use?

Regards,

Stratos