I am in 10.1.3.4.2, I have a two columns in my report
Country and Revenue
Country column is a drillable column with the dril path as country>>region>>area
My requirement is that when users drill down to area column, they should
be able to navigate to another dashboard page. So basically I want to provide
navigation on the area column but how to do this? Because in my report
i have only country column, how to provide a navigation on area column which is the last column in the drill down?
Can anybody please suggest on this?
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
My solution worked for you using admin login
for ref check this link.
If works pls mark as correct that helps others too