In case of Blending Datasources, You would get * wherever there are Duplicate values. Try these different things:
- Use Joins Instead of Blending
- Make Datasource with Question_id as primary and bring Question _Id in Front and blend on something unique.
- Use INDEX to give each row a distinct number
- Go to Analysis and remove tick from aggregation.
Thanks, Deepak. I've tried everything on here with no luck. If I switch the primary datasource to be this one that builds the table and use the other datasource with the actual data to be displayed in it as the secondary everything works. The trouble with that is that now the filters that are used in the datasource with all of the data will not carry over. This workbook is used to build a report so when I select a school the entire report changes to show just that school...except this table and anything where the datasource with all of the data is secondary. So, it would involve duplicating the filters which is less than ideal but to just get everything moving I may have to do it while I look for a better solution.
What's killing it by using the datasource with data as primary is that I had to build a dimension that uses sets to identify the indicator_id you see above, but that falls victim to the same problem where when a member is in multiple sets it won't display the data. So it looks like this:
IF [IE06] THEN "P1-IE06"
ELSEIF [ID12] THEN "P5-ID12"
ELSEIF [IF12] THEN "P2-IE07"
It's just turned into a much bigger problem than I had expected. Ha!
Thanks for the suggestions.
Go for Joining the Datasources
Join the Datasources over a common field, use Left join, you would get what you need.