Database ranking

[Former Member]

Gentlemen,

the most recent BO documentation mentions the feature "database ranking" and lists some relational database management systems supporting this feature. I want to avoid ranking the WebI report itself but have the database do this job.

Is database ranking also possible when working with SAP BW based OLAP universes (sitting on BEx Queries) in BO XI 3.1 SP2?

Thank you.

Regards

Johannes

[Former Member · Accepted solution]

Hi,

Unfortunately its is not posssible to do a ranking on the Web Intelligence query panel usin SAP BW OLAP Universes: this should normally be addressed in Aurora.

By the way there are 2 alternatives:

<li>Use Data Federator for accessing SAP BW in relational mode and take advantage of relational ranking features

<li>Use OLAP universe and defined a calauclated measures that rank the members of a given characteristic/hierarchy for a given key figures then define a predefined filter to filter the calculated expression in order to have the Top N or the Bottom N.

Here is a sample that rank Company Code over Open order quantity

<EXPRESSION>Rank([0D_CO_CODE].CurrentMember, Order( [0D_CO_CODE].CurrentMember.Level.Members ,
@Select(Open order quantity in base unit (SAP DEMO)\Open order quantity in base unit (SAP DEMO)))</EXPRESSION>

Now here is the same example used in a predefined filter:

<FILTER EXPRESSION="Rank([0D_CO_CODE].CurrentMember, Order( [0D_CO_CODE].CurrentMember.Level.Members ,
@Select(Open order quantity in base unit (SAP DEMO)\Open order quantity in base unit (SAP DEMO)))"><CONDITION OPERATORCONDITION="GreaterOrEqual">
<CONSTANT CAPTION="Value"></CONSTANT>@Prompt('Enter value for Top n','N',,mono,free)</CONDITION></FILTER>

Regards,

Didier