Analytics Software

Hello All,

I am using OBIEE 12.2.1.2.0 in Windows 2012R2 platform. This issue seems like a very easy one but somehow I am not able to fix the same. I am generating a table view with 6-7 columns which generates around 50000 rows. I am able to export everything into a CSV sucessfully but when I try to export it into excel 2007+ I get ~ 9000 rows exported. Rest are missing. Also when I am trying to see all the records in the table by clicking the arrow signs at the bottom of the table view I get the following error:

(View Display Error: Maximum total number of cells exceeded (Configured Limit: 50000).

Error Details

Error Codes: EY692ZW9

Location: saw.httpserver.processrequest, saw.rpc.server.responder, saw.rpc.server, saw.rpc.server.handleConnection, saw.rpc.server.dispatch, saw.threadpool.socketrpcserver, saw.threads)

Now, one might think I haven't configured the parameters properly. So here is my instanceconfig.xml file views section.

"

       <Views>

            <Pivot>

                <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>5000000</DefaultRowsDisplayedInDownload>

                <DisableAutoPreview>false</DisableAutoPreview>

  <MaxVisibleSections>25000</MaxVisibleSections>

  <MaxCells>10000000</MaxCells>

  <MaxVisibleColumns>5000</MaxVisibleColumns>

  <MaxVisibleRows>5000000</MaxVisibleRows>

  <MaxVisiblePages>25000</MaxVisiblePages>

            </Pivot>

            <Table>

                <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

                <DefaultRowsDisplayedInDownload>5000000</DefaultRowsDisplayedInDownload>

  <MaxVisibleSections>25000</MaxVisibleSections>

  <MaxVisibleRows>5000000</MaxVisibleRows>

                <MaxVisiblePages>25000</MaxVisiblePages>

                <DefaultRowsDisplayedInDownloadCSV>1000000</DefaultRowsDisplayedInDownloadCSV>

            </Table>

     <Cube>

  <CubeMaxRecords>10000000</CubeMaxRecords>

  <CubeMaxPopulatedCells>100000000</CubeMaxPopulatedCells>

     </Cube>

        </Views>

"

But for some reason the report shows the cell limit being 50000. That's why around 9000 rows are being exported successfully (wherever the cell limit is crossing 50000 it stops). But PDF, CSV and other exports work fine.

Kindly suggest. I have also modified the following section in the config.xml file placed under Middleware\user_projects\domains\bi\config\fmwconfig\biconfig\OBIJH

<XMLP> <InputStreamLimitInKB>1638400</InputStreamLimitInKB> </XMLP>

But to no effect. Please help.

Avik Dutta.