I searched some old topics on linking dataproviders but did not find something that helped my senario.
I have two dataproviders from 2 universes. All the fields i am dealing with are dimensions. THe first DP fetches 450 rows (based on a criteria) and it is something like
X Y SSN Z
I am using the second DP to get participating program information based on SSN. It fetches 1350 rows and looks like
SSN Program
The only common dimension is SSN and I want the ‘Program’ information to be displayed with columns from first DP for all 450 rows(fulfillig the query criteria). I linked the two DPS on the common SSN field.
Now when I insert a new table in the report and try to pull required columns in the report, it greys out “Program” if I have selected SSN from DP1.
Please help and let me know if i am missing something.
THanks alot.
The problem you are experiencing is that you can only use unlinked Dimension objects from ONE of the data providers. You’ll have to change the dimension object(s) in the other to Details instead.
Create a new measure or detail variable on Program(Dimension Object) and try to insert it into your new table. it should allow you to insert. But change it again to Dimension (O’wise it may give you junk information).
This is one small fix I used to make for these issues.