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

Evdre Set to Filter Values not Member

Hello.

I'm trying to create a nested EVDRE report to bring back percentages less than 5%. How could I code this, can I incorporate MDX within the memberset? Below is an example of what I tried out but it didn't seem to filter to only percentages equal or less than 5%.

Example:

Row Expansion 1

Drivers

Memberset = BAS(All Drivers)

Row Expansion 2

Product

Memberset = BAS,ALL AND (([Drivers].CurrentMember,[Product].CurrentMember) <> .05)

Thanks,

Nancy

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 01:59 AM

    Currently, EVDRE is still waiting for the ability to dictate an extraction based on a value using a mdx or a new method. (or at least that has been a common request for a while) To my knowledge, membersets will not accept any parameters using MDX.

    I will look around for past ideas, as I am sure someone has figured out some fun work-arounds using multiple evdre's or VB ontop of an EVDRE. I was hoping the suppression process would allow this type of arrangement, but I can't seem to get it to work on a value either.

    Maybe others will help, but I will check into it.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 07:05 AM

    EVDRE doesn't support this. You have two options:

    Use EVDRE, and then write some Excel VB to hide the rows whose values are less than your threshold.

    Use the MDX-based row expansion options, which will filter on the server -- which may be a great performance boost, if this avoids retrieving to the client 5,000 records that you want to filter. A great example of this is in the ApShell dynamic report template called Sort and Rank. This is set up to let you choose top/bottom X%, Y records, or values under/over $Z threshold.

    I'd recommend using the second one. It's quite flexible, and already built for you. This is pretty much the only situation where I do NOT use an EVDRE for a report.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 17, 2008 at 03:00 PM

    Thanks for the quick response btw!

    Anyways, I was checking the sort and rank template and it is only available when it's a single expansion. Is there a way of using the EVENE within the EVNXP to create a nested sorted expansion?

    The current report I've built is only using the EVEXP with the EVNXP formula and the MDX I'm using to find anything less than the threshold is taking 5 minutes just to bring back 10 rows.

    Regards,

    Nancy

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      You can accomplish what you want, using only the EVNXP. Use the filter parameter to add the MDX statement to EVNXP, using the same syntax as you see in the EVENE Sort & Rank template. Beware that the performance is only likely to get worse, not better.

      And to answer your question directly, no, I don't believe there's any way to use EVENE within EVNXP. You might be able to use both of them on the same report, acting independently, but that's not what you're after.

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.