Evdre Set to Filter Values not Member

[Former 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

[Former Member]

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

[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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

Actually if the MDX doesn't work in the EVDRE memberset, the work-around is back to the old day EVGET/EVSEND Control Panel. MDX is ok on there

Halomoan