If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How to get related insurance of a payor in transformer

Started by callmenagendra, 24 Dec 2014 05:46:33 AM

Previous topic - Next topic

callmenagendra

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....




Lynn

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.