Hi guys, I stumbled across your OLAP Pivot tool while looking for an answer to what should be a simple question... at least I thought so. Apologies in advance for any noobishness, I'm a developer but new to MDX in general and certainly stuff like this.
We have an OLAP SSAS cube that our DBA made on SQL2k8 and created a linked Pivot table to. For simplicity/relevance sake, lets just say that the pivot table has two rows "Company X", "Company Y" and two columns,
"Past Due" and "Total Sales".
So cell A1 is showing us Company X, Past Due and B1 is showing Company X, Total Sales. The way the dimensions are working on the cube, a drillthrough on "A1" is showing us all the values which make up the "Past Due" total
for Company X. Peachy. But it is also showing us "0"s for companies which DONT have a past due balance... because these companies are included in the dimension which has total sales.
What I would like to do, and am trying to use your tool to accomplish, is to either change the drillthrough on the existing column using MDX to only pull distinct results for column A, or else, create a new calculated value which only has distinct values from
the past due column and then define a drillthrough for it. I got halfway down the second path and then hit a wall - apparently you cant define a "show detail" / drillthrough action for a calculated field?
Is that last bit correct, or am I just not following how to do it? Is there an easier way? Am I trying to use this tool for a purpose it was never intended for?
Thanks in advance for any help.