Maximum Cells in Query

[#1]

Hello experts,

Does anyone know what the maximum number of cells in a structured report is?

I am not talking about the 65,536 rows in Excel, but actually how many rows and columns you can have in your query.

I am getting a Brain 457 error:

<i>Query ZFI_M02_8Y0_Q977 is too large.

Message no. BRAIN457

Diagnosis

Query ZFI_M02_8Y0_Q977 contains 8192 differing selection cells. However, only 8191 selection cells can be processed in a query.

Procedure

Please simplify query definition ZFI_M02_8Y0_Q977.</i>

I have 95 defined columns and 145 defined rows, which would calculate out to 13585 cells.

Cheers

[Former Member · Accepted solution]

Hello James,

The problem is in the complexity of objects you use in this. The message comes from OLAP acceptance test and actually has nothing to do with the cells of data. Here it is the internal number of selection groups OLAP can handle.

Actually this number appears are a result of simplification of complex Restricted and Calculated KF inheriting each other in definitions. One complex KF represented as a structure members in your query may come to OLAP as 20-30 (or more) selection groups. That means the visible amount of members may be significantly less that the amount OLAP operates with. There is no way to get this number in design time except use 'query check' function which should return the error when the limit is over.

In this case is necessary to remove one complex KF or replace it by local SEL/FML. In most cases this will help to get the same query definition with cheaper costs for OLAP.

Best regards