This content has been marked as final. Show 8 replies
I had exact requirement..instead of drill down use Navigation by creating separate reports fro country,Region.Area..with is prompted filters at each level and at detail level in ur case area provide navigation to Dashboard..it works..I implemented it..
Award points if Correct...
In answers-->area column properties--->column heading interaction-->select the navigate option-->give the dashboard page path.
Run the request now...It will work .
mark if helpful/correct...
In criteria tab just pull area column
For Column area->Column Properties->Value Interaction->Navigate
Choose the detail report
at bottom left of 'Column Properties' wizard
Save->as the system-wide default for "area'
and then go back to your report drill down to area and you'll find navigation on values.
This should work in 10g.
If helps pls mark as correct
*------------>Any updates on this!!*
Edited by: Veeravalli on Nov 30, 2012 5:41 AM
Can you tell me this,
Let say I select the column assetmanager and apply navigation on that and then save it as system wide default.
Now I log off from obiee and then login again and then select assetmanager again in the criteria and now when I will go to column format tab and check if the interaction is applied on the column , will i see the interaction ?
What happened is that after applying the interaction and saving it as system wide default, one of my team members logged in and checked and he didn't find interaction in the column format tab but interestingly when we run the report, in the results, we do get navigation on the values of asset manager table. Hope I am clear on what I am asking
Use Administrator login that would persist for all users.1 person found this helpful
sure, i'll try that and will let you know. thanks for the help.
My solution worked for you using admin login
for ref check this link.
If works pls mark as correct that helps others too
Yes, thanks veera. This works in 10g and not in 11g.