Skip to end of metadata
Go to start of metadata

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

PDF to Word

  • No labels