OBIEE11g - Table Prompts and Sections

Table/Pivot Table Prompts and Sections are very nice and handy features in the OBIEE11g. This post shows different ways to create it.

Here's a simple pivot table with Company, Year, Brand and few measures.

Edit pivot table view and drag the columns to the Prompt and Section area as shown below.

Back to result view. Company is now a dropdown prompt and Brand is section header

Alternate way: Right click column in result view. Select "Move" menu. Select either "To prompts" or "To sections".



Another alternate way: Hover the column and drag the small tab that appears over it to the empty area above the table.



Pivot Table Prompt area will appear automatically. Drop the column there.



Similarly drag and drop columns to Sections area.



To bring back columns to table, hover the Prompt or Section header. Small tab will appear on left. Drag and drop it to the table back.