Universer can't Just take bw query top n datas.

[Former Member]

HI friend,

I had one problem:

My bw query set used Top 10 datas. .

File->Parameters->Controls--->Limit size of result set to . set 5

but universer connect query, list all cube datas

What to figure out?

Thank you.

Regards,

Howard.

[Former Member · Accepted solution]

Hi,

You hit an OLAP BAPI limlitation: OLAP BAPI does not support conditions.

The workaround I recommand is to create a calculated measure using Rank function like this:

Rank([dimension_definition].CurrentMember, Order([dimension_definition].CurrentMember.Level.Members, [measures].[measure_definition], BDESC))

Then create a predefined filter based on the rank calculated measure that returns the value you want. You can create a prompt and let the user to decide the top n values. You can also create a prompt on the Rank function (BDESC or BASC) to also let the user to choose for Top or a Bottom selection.

Regards

Didier

[Former Member]

We had a static filter.

<FILTER EXPRESSION="Rank([ZINJTYP].CurrentMember, Order([ZINJTYP].CurrentMember.Level.Members, [Measures].[4LHE47F085PB05QJI89XHXM3X], BDESC))"><CONDITION OPERATORCONDITION="LessOrEqual"><CONSTANT CAPTION="8"/></CONDITION></FILTER>

We messed up the syntax earlier. Don't forget the space inbetween CONDITION and OPERATORCONDITION.

Wish the error messages you receive from the compiler told you where your syntax is messed up!

[Former Member]

HI Didier Mazoue ,

Thank you very much. That is ok.

<FILTER EXPRESSION="Rank([0VENDOR].CurrentMember, Order([0VENDOR].CurrentMember.Level.Members, [Measures].[D7G51I90GYJ8POGFSYVFPX24F], BDESC))"><CONDITION OPERATORCONDITION="LessOrEqual"><CONSTANT CAPTION="@Prompt('Enter value for Top n','N',,mono,free)"/></CONDITION></FILTER>

Universe:

Filter must to choosed: Use filter as mandatory in query and Apply on Universe or Apply on Class