SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
Posted by Devon Abraham Mar 28, 2012
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
Generated by Jive on 2012-05-10+02:00
1
SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
Select SAP Reference IMG
Navigate down to Set Model Parameters, select the green tick
Generated by Jive on 2012-05-10+02:00
2
SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
Capture Envireonment and Model parameters (Above)
Select New (Create) - Below and capture BPC_STATISTICS as the field name and turn them ON
Generated by Jive on 2012-05-10+02:00
3
SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
You can now step into program UJSTAT
From here we can trace queries as below:
Generated by Jive on 2012-05-10+02:00
4
SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
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.
Happy Developing.
Devon Abraham
Follow: @_Devon_Abraham
Generated by Jive on 2012-05-10+02:00
5
SAP BusinessObjects Planning and Consolidations, version for SAP NetWeaver: Enabling UJSTAT, RSDRI takes MDX around the outside..
232 Views
There are no comments on this post
Generated by Jive on 2012-05-10+02:00
6