Здравствуйте! Есть такой вопрос.

Когда в BEx запускается отчёт с профилированием по времени, то можно найти на что тратится больше всего. Табличка выходит такой:



Можно где-то узнать, что они означают? В частности, интересует



Потому что на него приходится просто неприлично много времени, и непонятно почему.

Выходит, что это передача данных.
Далеко от сервера?
Покажите результат работы команды ping до сервера, есть у BEx 3.X и ранних версий BEx 7 один могильничек.

Вот некоторая расшифровка работы OLAP
OLAP Initialization
Check Authorizations
Is it ok to execute query?
Is it ok to read data from InfoProvider?
Process Variables
Exit for global variables (before variable input) is processed
Prompt for variable input
Exit for global variables (that failed before input) is processed
Variable values are distributed to fixed filter, hierarchy settings, dynamic
filter, conditions & exceptions, formulas, …
Initialize OLAP Processor
Notify Presentation hierarchies (if used)
Check time stamps for OLAP cache (and release respective Ids)

1. OLAP request arrives from client
Request for free characteristics
Request for Dynamic filters
2. Include additional characteristics necessary for aggregation /
calculation. For example:
Exception aggregation
Elimination of internal business volume
Formula variables with replacement from attribute value, if used in
restricted key figure (RKF)
3. Check authorization for navigation state (where necessary)
4. Search for Cached data in OLAP Cache
Skip steps 5-14 and go to step 15 if cached data is found

IF OLAP Cache is Not Utilized

5. Request data from database
6. Receive data from database
Data arrives in blocks up to 1000 rows
Data is still separated by InfoProvider (in case of MultiProvider)
Data is still separated by Aggregate of InfoCube
Data is still separated into cumulative and non-cumulative key figures
7. Call BusinessAdd-In “Virtual Characteristics and Key Figures”
8. Check global filters (if not already done by database)
9. Add attributes values for variables with replacement from attribute
used in RKF
10.Separate data according to RKFs and selections in structure
elements
11.Perform currency translation
12.Process sums and calculated key figures (CKFs)
“before aggregation”
13.Aggregate data to detail level (see 2.)
14.Perform Hierarchy aggregation

15.Filter and aggregate data (result lines)
16.Perform Elimination of Internal Business Volume (where applicable)
17.Perform Exception aggregation
18.Execute Currency/Unit aggregation
19.Add attributes values for variables with replacement from attribute
used in formulas
20.Calculate formulas and CKFs “after aggregation”
Check Currencies/Units
21.Perform List Operations, e.g.
Sort
Conditions
Local calculations/aggregations
Cumulated values


The QTIMEDB =in the database read operation. DBSEL (number of selected records from database). DBTRANS (number of transferred records to OLAP)