Skip to Content
Author's profile photo Former Member

Enabling UJSTAT, RSDRI takes MDX around the outside..

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.

Happy Developing.

Devon Abraham

Follow: @_Devon_Abraham

Assigned Tags

      1 Comment
      You must be Logged on to comment or reply to a post.
      Author's profile photo Daniel Nurindra
      Daniel Nurindra

      Hello Devon, Thanks for your sharing. As a beginner on BPC, would you mind advising what the purpose is to activate this.

      Kindly please ask your thought. Appreciate it much