OBIEE column interaction

Question

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.

SriniVEERAVALLI · Answer

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.

user4109719 · Answer

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.

SriniVEERAVALLI · Answer

Use Column properties->Interaction tab, then at Value select Action Link and give the target report name