How To Fix BRAIN015 - El query realiza de una sola vez una lectura posterior de todos los datos

SAP Error Message - Details

• Message type: E = Error

• Message class: BRAIN -

• Message number: 015

• Message text: El query realiza de una sola vez una lectura posterior de todos los datos

¿Qué causa este problema?

When executing the query in the Business Explorer<(>,<)> all of the fact
table data that is needed for all possible navigational steps in the
query is read in the main memory area of the OLAP processor at once.
This can sometimes lead to very long run times in the query.
For a query, the OLAP processor can read the data in the fact table in
one of three ways:
Reading all of the data
When executing the query in the Business Explorer all of the fact table
data, that is needed for all possible navigational steps in the query,
is read in the main memory area of the OLAP processor. Therefore, all
new navigational states are aggregated and calculated from the data of
the main memory.
Reading the data on demand:
The OLAP processor only requests the corresponding fact table data that
is needed for each navigational state of the query in the Business
Explorer. Therefore, new data is read for each navigational step. The
most suitable aggregate table is used and, if possible, already
aggregated on the database. The data for identical navigational states
yavigating is buffered in the OLAP processor.
Reading on demand when expanding the hierarchy:
When reading data on demand (2), the data for the entire - meaning
completely expanded - hierarchy is requested for a hierarchy drilldown.
For the read on demand when expanding the hierarchy (3), the data is
aggregated by the database along the hierarchy and is sent to the start
level of the hierarchy (highest node) in the OLAP processor. When
expanding a hierarchy node, the children of the node are then
respectively read on demand.

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

In general, the reading of data on demand (2) provides much better
performance than reading all the data (1). This read mode should
especially be considered for queries with many, free characteristics. A
query that contains two or more free characteristics from different
dimensions (e.g. 'Customer' and 'Product'), will probably only be
efficiently executable in this mode, as the aggregates can only be
optimally used when reading the data on demand.
For large hierarchies, aggregates should be created a middle level of
the hierarchy and the start level of the query should be smaller or the
same as this aggregate level. For queries about such large hierarchies,
the read on demand when expanding the hierarchy method (3) should be
set.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.