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

[edwin_geel]

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)

[Former Member · Accepted solution]

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.

[former_member197251 · Accepted solution]

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

[Former Member]

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

[Former Member]

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.

[Former Member]

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.