BW Query Properties in Universe

[Former Member]

Hi all,

We are creating universes from SAP BW queries. Some of the key figures in queries are reverse signed in key figure properties. As I understood, these properties are not passed to Universe and Webi. Is there anyway to solve this problem. Otherwise I will need to manually set query properties for every query in WEBI.

thanks,

Mustafa

[Former Member · Accepted solution]

Hi

Please refer to this [PDF|http://help.sap.com/businessobject/product_guides/boexir3/en/xi3_sap_olap_universes_en.pdf]

This might be helpful.

Regards

Sourashree

[Former Member · Accepted solution]

Hi,

PDF file doesnt contain anything about properties of key figures.

thanks,

Mustafa

[Former Member]

Hi,

These properties are effecitively not supported as well as scale factor or display key/caption for characteristics.

In fact BEx query properties related to the report formatting are not supported.

For most of the properties, you can apply the same properties in the Universe or in Web Intelligence,

For instance, if you want to revert the sign for a given measure you can create a calculated measure such as:

<EXPRESSION>@Select(My Class\My Key Figure) * -1<EXPRESSION>

Didier

[Former Member]

Hi,

thank you Didier. At least, now I know it is not supported.

Mustafa