Issue with Navigation Reports in Obiee 11g

Question

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??

Gianni Ceresa · Answer

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.