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.
That was exactly what I was looking for. Thanks!
Thank you for the solution. Are you sure it’s false for “content paging” ?
I’m confused because of the Oracle Document : https://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG1717
It says : “- false (Default on installation), sets reports to show the output with Data View as ‘Fixed headers with scrolling content’.- true, sets reports to show the Data View as ‘Content Paging’.”
Does it vary with different versions?