How to change the default scrolling option of a table view in OBIEE

By default the scrolling option in table view of your analysis is set to Fixed headers with scrolling content resulting in a scrollbar directly in your analysis and no paging.

To always use Content paging for your table views we need to change or add a setting in the config file of the BI presentation services which is instanceconfig.xml. Normally you can find this config file within your instance folder of the installation ie. BIINSTANCE/config/OracleBIPresentationServicesComponent/coreapplication_obips1/instanceconfig.xml

Open up this config file in your installation and navigate to your Views element if existing otherwise you need to add it within your ServerInstance element, ie.

<ServerInstance>

<Views>

...

</Views>

</ServerInstance>

Within the Views element add the below code to switch you default table view paging option to Content paging.

<GridViews>

<DefaultScrollingEnabled>false</DefaultScrollingEnabled>

</GridViews>

You need to restart the BI Presentation Services to activate this change. After a successful restart of the presentation services the default scrolling behaviour is changed.