Hi - just wondering if you can bring back 'zero' counts using OLAP.
E.g. if I have a dimension based on a reference table with values

id name
----------
1=Apple
2=Orange
3=Banana

But my linked data table only contains rows with values 1 and 2, I want all three to be displayed in the OLAP dimension with Banana having a count of 0.

Thinking about the way that OLAP works with aggregates I don't think this is possible but I just wanted to check

thanks
w