Skip to Content
0
Former Member
Aug 24, 2009 at 05:27 PM

MDX Filter in EvDre Suppress Option?

20 Views

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?