@select doesn't bring results in Olap Universe

[siegmund_himmel2]

I've created a new measure by entering this line in the select.

<EXPRESSION>@Select(Sales of Goods\Sales of Goods)</EXPRESSION>

Parsing went well but no data has been displayed in webi, while the measure Sales of Goods\Sales of Goods contains data.

I'd like to create simple calculated maeasures in universe like this:

<EXPRESSION>@Select(Universe Calculated Key Figures\NET SALES) + @Select(Universe Calculated Key Figures\Cost of Sales)</EXPRESSION>

[Former Member · Accepted solution]

Hi,

Do you have a structure defined in your BEx query?

Which BOE version are you using?

Regards,

Didier

[siegmund_himmel2 · Accepted solution]

We use BO XI 3.1 SP 2 and SAP BW 701

In the Bex Query I defined some restricted key figures as rows in the key figures structure and some time characteristics in a column structure

[Former Member · Accepted solution]

HI,

You hit an SAP MDX limitation.

Calculated measures return no results when a structure involving characteristics is defined in the BEx query.

If you have activated the traces, you can copy the generated MDX and paste it in MDXTEST transaction: normally, no result will be return.

Regards,

Didier