Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Issue with Navigation Reports in Obiee 11g

Received Response
1
Views
1
Comments
959186
959186 Rank 1 - Community Starter
edited Aug 13, 2024 6:11PM in Oracle Analytics Forum

Hi

I had One Master and Detail report

Master Report having Columns from : Table A, Table B

Detail Reports having columns : Table C

where Tables A,B,C  are joined in rpd . Now I am passing Table B. column to Detail report to filter it. My question is I also want to show Table A columns in Detail Report, But I dont want to query the database again for Table A and B . is there a way I can pass Table A column values to Detail report without Querying Database again??

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Not really ....

    Your details analysis contains columns from A, B, C, so the query will go on table A, B, C.

    The only way to display something in an analysis without querying the DB for it is to display the value of a variable. But your use case don't use variables, so no.