Categories
- All Categories
- 145 Oracle Analytics News
- 27 Oracle Analytics Videos
- 14.7K Oracle Analytics Forums
- 5.7K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 54 Oracle Analytics Trainings
- 12 Oracle Analytics Data Visualizations Challenge
- 4 Oracle Analytics Career
- 2 Oracle Analytics Industry
- Find Partners
- For Partners
OBIEE column interaction
I am creating an OBIEE report that uses a table containing organization data which is in a hierarchical relationship. The table has columns called ORGANIZATION and PARENT_ORGANIZATION. When clicking on the ORGANIZATION column in the report, I want to navigate to another analysis based on the same table but where PARENT_ORGANIZATION is equal to the selected ORGANIZATION in the first report. There doesn't seem to be a way to tell it to do that.
Answers
-
Use Column properties->Interaction tab, then at Value select Action Link and give the target report name
0 -
I have done that to navigate to another report. However, it doesn't know anything about equating on the two columns, where PARENT_ORGANIZATION in the linked report is equal to the selected ORGANIZATION in the first report. Populating a presentation variable in the first report doesn't work because it doesn't carry that variable over to the linked report.
0 -
if I understand your question correctly; I would say you might be doing it wrong way, we can pass value to another report using action links as long as column is prompted in target report or else you may use presentation variables for the same.
0