hello,
can anyone advice me on how to hide a table depending on the user prompt.
For example, I have two tables (A & B) from two different universe.
When the user prompts for A then table A will be displayed only then if the user prompts for B then table B will be displayed only.
I’m using Oracle database and Desktop Intelligence.
Thank you in advance.
aziren (BOB member since 2010-10-19)
Thanks Jansi 
I can now hide the table through hide block.
aziren (BOB member since 2010-10-19)
hi can u please tell me the exact steps how did u achived it
at universe level how is the prompt defined
in select clause or where clause?
mohan.gdwh (BOB member since 2010-01-25)
hi mohan,
the prompt actually is defined through the stored procedure.
you can hide the table by selecting format table then under appearance tab, check the ‘hide block’ then add the prompt condition in the formula editor.
aziren (BOB member since 2010-10-19)
(BOB member since 2008-05-12)