Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 283 Oracle Analytics and AI News
- 60 Oracle Analytics and AI Videos
- 16.3K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 108 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- 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