This content has been marked as final. Show 4 replies
You need to have Dimension hierarchy in your BMM to deal with this..
Best doc is to read Admin tool help file for the same
if not check these
If helps pls mark
You have 3 options
1> Create a dimension hierarchy. Even if the tables are different they can be part of same logical table. Like Country and State can be from different tables but you add these 2 tables in LTS and create hierarchy.
2> Create a summary report and a Detail report. Provide action link from summary to detail report.
3> Use Master detail link between summary and Detail report. You will have to keep Master and Detail reports in same dashboard.