Tuesday, June 5, 2012

OBIEE 11g Displays Table Pivot Ticker

One of the interesting thing is that if you actually read a document, you actually get to know neat things. For e.g., this document in OBIEE 11g tells the different options you have for displaying data in OBIEE dashboards and answers. For example, you can control how your pivot table, table and tickers look in OBIEE. This is set up in instanceconfig.xml. This table in Oracle documentation is a good reference.
For example, a pivot setting could look as follows in the instanceconfig.xml file.

<Pivot>
        <MaxCells>6000</MaxCells>
        <MaxVisibleColumns>300</MaxVisibleColumns>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>500</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
</Pivot>

You could use the table to control the various display settings for Graph, Table, Pivot Table, Ticker and a narrative.

No comments:

Post a Comment