Unable to Slice from Outrigger Dimensions in Azure Analysis Services
Ravi Kosuri
6
Reputation points
In Azurd Analaysis services, I see an issue while querying data (Pivot Table) from an Outrigger Dimension, for example DimAddress have DimState and DimZip as Foreign keys from different dimensions and when I using the above dimensions as filters, the result I see is a Cartesian product. Also goes for the fact tables if defined as dimension but not as a measure group would result in Cartesian product. Please let me know how to resolve this problem.
Sign in to answer