Hi,
I am using transformer(10.1) to create cube.
I have PAYOR dimension and INSURANCE dimension.
I am creating crosstab in report studio. i want to display only related insurance of a payor.
when am dragging children(insurance) under children(payor) am getting all insurances for each payor.
please find the attachment for reference. Please guide me to get the expected output.
Thanks in Advance....
This is how OLAP sources work. You can do zero suppression or use a filter function to eliminate the members that have no fact information.