#25 Problem while retrieving calculated measures when using filters

[Felipe Trevisan]

After I had installed the version "XMLA_Provider_v1.0.0.88.exe", a problem start to occur when retrieving
calculated measures with some filter applied from the row/column fields. See attached figure.

If no filter is applied on row/column fields, the calculated measures are obtained correctly.

I had also noticed that when the filter is applied on a dimension with just one hierarchical level,
the problem occurs just for the total line. But when the filtered dimension is a multi-level hierarchy (like time, on the screenshot), no calculated member can be retrieved at all.

I have tested all the versions released after "1.0.0.88" and all of them shows the same problematic behaviour.
For version "1.0.0.59" the problem do not occur.

[Alexandra Davidoiu (Iancu)]

This is something we are well aware of. The problem occurs on Mondrian, there is a documented bug and we have a technical note on it. Check the document here:

http://www.arquery.com/Visual%20Totals%20with%20Mondrian.pdf

I will update the wiki with this information. Let me know if this is enough for you.

[Felipe Trevisan]

Alexandra, thank you for the information.