Eliminate Unnecessary SQL Pass

[tootscamus]

I have a report with 2 metrics, A and B. Metric B has a metric qualification filter based on metric A. When the SQL is generated metric A is determined twice (two passes), once for display and once as a qualification for Metric B.

Is there anyway that I can get Microstrategy to eliminate one of these passes?

 

[nlim]

I think there's a reason why the second pass is there....hear me out.

1) if your metric B is defined with filter A>10, then it is possible that you can get results that look like this

A B
xyz 5 Null
abc 11 20
def 6 Null
ghi 12 40

the second pass is required to make sure that there's an outer join between A and B where A does not meet the filter criteria.

2) Now if all you want is

A B
abc 11 20
ghi 12 40

then I recommend you put the A>10 filter into the report filter, not metric B. That will get rid of the unnecessary pass.