cancel
Showing results for 
Search instead for 
Did you mean: 

MDX Filter in EvDre Suppress Option?

Former Member
0 Kudos

I am trying to filter records based on the value of a flag set as Fact Data (TermStatus in AccountPay).

This flag can either be a 1 or a 2.

I need to display only the records (based on Cost Center, JobTitle, and Position dimensions) with a value of 1.

Using the EvDre suppress Option returns all records with a value (1 or 2).

I can accomplish this using u201CClassicu201D reporting and adjusting the MDX filter but I have not been able to do this within EvDre.

Has anyone been able to accomplish this or something similar in EvDre?

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Well, the bad news is that EVDRE does not support a query based or suppression based on the value of data. This is a frequently requested enhancement that has not been implemented in EVDRE yet. You may be able to find more solutions in this forum, but the method you seek is not standard yet.

You may be able to SORT the values and FORMAT the section based on the value of 1 or 2?

Hope this helps and I hope others have better suggestions.