Skip to Content

using EVDRE to return only records having a value greater than X

in the old reporting wizard you could use MDX statement like "return only those members/data where the value of some account is greater than 100".

Thus allowing you to select for instance those entities that had signinficant sales or the like.

In EVDRE i am looking for a way to do the same but apart from returning the Top n members or suppressing zero's i cannot fnd a way to do this. From an earlier post in the old outlooksoft consultancy forum (dating from march last year) i understood that this functionality was already prepared so i assumed it is in, but how ???? (if it is there of course).

I hope some of you have the answer.....

Thanks,

Edwin van Geel (SAP Netherlands)

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Apr 01, 2008 at 12:11 AM

    Edwin,

    I will review my notes on this subject. I believe I had requested this functionality as an enhancement back in version 5.0 since it did not exist, and as far as I can remember, the use of SignedData with a value is not operable at this time.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi All,

      I really need the answer. Can we resolve it?

      and my customers also want to filter the data by "haveing a value greater than X" and "the description is including abc".

      Thanks a lot.

      Maggie

  • author's profile photo Former Member
    Former Member
    Posted on May 15, 2008 at 05:02 PM

    MDX may be the best route till SAP comes out with the enhancement Peter refers to.

    Otherwise you could use a combination of the options top/bottom along with sort, possibly along with excel functionality to hide any unwanted rows of data.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 07, 2008 at 01:50 AM

    Maggie, I think what David's answer implies is this:

    You can't (now, 5.1) use EVDRE to do a suppression based on signeddata.

    You can either build your entire report with EVENEs for the expansion, and EVGETs for the data retrieval (basically use the wizard templates) or use an EVENE for the expansion and EVDRE to only retrieve the data. The second option's a bit more complicated to set up, but likely the better approach in terms of performance and future-proofing.

    Either way, in the EVENE you use the MDX filter, both to evaluate the data values, and the other filter requirement you have.

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hi, I am still testing EvENE. What's the difference between EvENE and EVEXP. it seems that EVEXP can do most of the functions in EVENE. Can we find a way in BPC to do the text filter, no matter what kinds of workground methods?

    Thanks

    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.