Registration

Dear SCN Member,
In order to fully benefit from what SCN has to offer, please register at:
http://scn.sap.com/login.jspa
Thank you,
The SCN team
We are improving!
The SCN wiki will not be available for new content submission starting September 4th 6PM CET until September 7th 6PM CET. Please plan your SCN wiki tasks accordingly.
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