Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 19, 2011 at 02:15 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 09, 2009 at 06:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.