how to control Maximum Number of Rows in pivot and table in OBIEE 12C

Tony_OAS_Apex_User

We were able to modify instanceconfig.xml files to set the maximum rows on pivot, table, so on in 11G.

 

I heard everything should be in em console to change in 12C. There aren't many entries in em console.

 

It has section for

 

Maximum Number of Rows Processed when Redering a Table View

 

Maximum Number of Rows to Download

 

Maximum Number of Rows Per page to include.

 

 

 

We tried to copy those config lines to instanceconfig.xml and restart the services. This change didn't get the service to get restarted.

 

Any suggestion?

 

 

Here's the example we used in 11G..

 

<Views>

 

<Pivot>

 

<MaxCells>6500000</MaxCells>

 

<MaxVisibleColumns>100</MaxVisibleColumns>

 

<MaxVisiblePages>100</MaxVisiblePages>

 

<MaxVisibleRows>65000</MaxVisibleRows>

 

<MaxVisibleSections>25</MaxVisibleSections>

 

<DefaultRowsDisplayed>500</DefaultRowsDisplayed>

 

<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

 

<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>

 

<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DisableAutoPreview>false</DisableAutoPreview>

 

</Pivot>

 

<Table>

 

<MaxCells>6500000</MaxCells>

 

<MaxVisiblePages>100</MaxVisiblePages>

 

<MaxVisibleRows>65000</MaxVisibleRows>

 

<MaxVisibleSections>25</MaxVisibleSections>

 

<DefaultRowsDisplayed>500</DefaultRowsDisplayed>

 

<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

 

<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>

 

</Table>

 

</Views>

 

[Deleted User]

Read this: http://docs.oracle.com/middleware/1221/biee/BIESG/answersconfigset.htm#BIESG3278

Tony_OAS_Apex_User

Thank you ..I played around the instanceconfig.xml file and found that Cube size will decide the maximum rows.

I changed it and restarted the services. and it worked just fine.!!!!

thank you~

[Deleted User]

Will *also* influence max rows, it's not the only setting