Recently, on a ramp up BPC 10 NW project, performance debugging came to the fore. This is how I took a look under the hood of report creation:
Firstly, we have to enable UJSTAT for the BPC Model concerned. Logon to BW and run program SPRO
Select SAP Reference IMG
Navigate down to Set Model Parameters, select the green tick
Capture Envireonment and Model parameters (Above)
Select New (Create) – Below and capture BPC_STATISTICS as the field name and turn them ON
You can now step into program UJSTAT
From here we can trace queries as below:
The query at the bottom of the screen is a simple report using Member and Children fuctionality. This hierarchical relationship within a dimension is known as multidimensional expression or MDX. The query at the top is simply returning BASE Level members from the dimension which is known as a RSDRI query.
This significant difference in performance eventually became a project show stopper on resource intensive, complex EPM reports.