This content has been marked as final. Show 4 replies
You need to have Dimension hierarchy in your BMM to deal with this..1 person found this helpful
Best doc is to read Admin tool help file for the same
if not check these
If helps pls mark
but the data which i drill is not of dimension , it is an another table data.
That is called as Navigation.1 person found this helpful
if helps pls mark
You have 3 options1 person found this helpful
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.