Passing value from one report to another report as a parameter using value as a hyperlink

User_830KD

Hi All,

can you someone help me on this issue obiee report.

Details : report 1

Subject area A : column X (values in X is 1,2)

union

subject area B : column Y(values in X is 3,4)

in Report both columns X & Y consider as a Z column. Z will combine both the values display data in a single row. on top of Z column, I have created value as hyperlink.

Report 2 :

created a report using the same subject areas as union and the same columns. created a filter on both subject area's using the same presentation variable to display the data based on report 1

scenario: if I open report 1 I can see data 1..4. if I click on the value for example if I click on the value 1, then it will navigate to report -2 and display the value as 1.

issue: In report 2 I can see data only for 1 & 2, not 3 &4. if I change the sequence of the subject area in report 1, first subject area B Union Subject area A in this case I can see data in the report 2 only 3 & 4.

can some one help on this issue?

Joel

Is Report 2 a UNION as well similar to Report 1 but the only difference being that Report 2 has the more granular columns providing the detail?

User_830KD

both are the same reports and same columns using union.

For example : work order report - report 1 will show the summarized order details based on the order number. if I click on any order number then it will navigate to page -2 there it will show only the transactions based on a transaction that we select on page -1. both reports are the same but the difference is report 1 is summarized and report -2 detailed report.

User_830KD

Someone can help me on this issue, please............

User_AWXWU

Hi,

Can you detail on how you have defined the presentation variable?

User_830KD

Hyperlink created as on data in report -1 and just added a filter in page -2 using presentation variable in both subject area

User_6ITQ2

Hi,

I have an issue.

I have created a report1 and report2. Both are different subject areas. Both reports are having dashboard prompts. The value from report1 dashboard prompt needs to be passed to report2 dashboard prompt. Any solution for this?

Regards,

Nivetha.M

Gianni Ceresa

Hi @User_6ITQ2 ,

As this thread was quite specific on the OP problem, you can maybe create a new question where you provide all the info describing your context and what you tried that didn't work so far etc. (also including a product name and version helps).