cancel
Showing results for 
Search instead for 
Did you mean: 

Anyone Have Success w/MDX Expression to get a Top N from BEx Qry Universe?

Former Member
0 Kudos

I have a need to generate several Top N results for Xcelsius dashboards using data from a universe built on a SAP BW BEx Query Based Universe. I had limited success using the MDX Rank function in an Expression in the universe - it works only with very limited amounts of data. But with larger data volumes I never get a response back in my QaaWS going thru the universe.

I have been able to use the Rank function in the BW transaction MDXTEST and gotten results in just a couple of seconds against the large cube, but don't get a response back when going thru a universe after 30 minutes.

I can see on the BW side that the underlying SQL stmt that retrieves data from the database to load into the OLAP cube takes less than a second to run. So it seems like there might be some sort of problem withthe genreated MDS syntax.

Has anyone had success with Top N against a BEx universe? Is so can you share? I am at BW 7.0 SPS17 (aka SP19).

Thanks,

Pizzaman

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Thanks Didier for helping us out with our static filter

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

It worked.

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

I am able to use successfully the Rank function in OLAP universes.

I mentioned in other topics in this forum that we only support calculated measures in XI 3.x universes.

We aim to use the TOPCOUNT function but this function can only be used through a Select statement or inside a named set.

By the way, did you activate the MDX traces and did you test the generetaed MDX in MDXTEST transaction?

If the MDX generated return results with MDXTEST in an acceptables reponse time, I suggest you submit a support ticket in order to investigate what's going on on the performance when retrieveing data with a Rank function.

On the other hand, do you have installed BOE XI3.1 FixPack 1.2? This fix pack improves the performance on SAP NW and requires SAP NW 7.0 EhP1 installed to have these improvements effective.

Didier