Default Filter Measure in Performance Point

I've run into somewhat of a "chicken and the egg" issue with Performance Point and filters.

I've created a filter based on an MDX query. THe query itself is sound, but the issue is when I need to define a filter measure. There are two possible measures available for this particular filter, and member of the filter can have one or the other or both.

For example, the filter is on JOB NUMBER. Now any particular job can have an estimated value and an actual value, but it does not necessarily need to have either. A job can have an estimate and not an actual. A job can have an actual and not an estimate. But it could have both...

The issue is when I have to choose a filter measure. If a member doesn't have one or the other, it won't appear in my report..

Is there any way around this?

Thanks in adv

March 11th, 2013 9:10pm

A workaround:

Create a new Calculated Measure in your cube. Add conditional logic like

IIF( [Measures].[EstimatedValue] is null, [Measures].[ActualValue], [Measures].[EstimatedValue] )

Use this new measure in your PPS filter Measure.

OR

Create a Named Column in your Data Source View having a union of both columns. This will act as a indicator signifying that either of the measure are not null.

Free Windows Admin Tool Kit Click here and download it now
March 15th, 2013 8:03pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics