OLAP universe - dimension always contain a value

[Former Member]

HI

Dimension must contain a constant value instance. If I have one dimension, so it must always contain "ZTEST_RGB_23810". The value is not on the data, so I can't use af filter. Can it be done? We have a OLAP universe.

Regards,

Rikke

[arijit_das · Accepted solution]

Hi,

If you have BO XI3.1 SP2, then you can try the following steps:

1. create one dimension object in the universe

2. In the select clause mention: <EXPRESSION>"ZTEST_RGB_23810"</EXPRESSION>

Regards

[Former Member · Accepted solution]

Hi,

Your solution is good but only works with MSAS.

Based on the constant "ZTEST_RGB_23810" it seems that the data source is SAP BW.

If it is SAP BW unfortunaletly SAP MDX does not support string as a result of a calculation.

Didier

[Former Member · Accepted solution]

Hi

Thanks for your help. When will BusinessObjects support hardcoding a value?

Regards,

Rikke

[Former Member · Accepted solution]

Hi,

In that case this is related to SAP BW so I suggest that you create a User Exit function in SAP BW that contains the constant and then use it in a BEx query.

Didier