Skip to Content

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

Step1.JPG

Select SAP Reference IMG

Step2.JPG

Navigate down to Set Model Parameters, select the green tick

Step3.JPGStep4.JPG

Capture Envireonment and Model parameters (Above)

Select New (Create) – Below and capture BPC_STATISTICS as the field name and turn them ON

Step5.JPG

You can now step into program UJSTAT

From here we can trace queries as below:

Step10.JPG

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

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

  1. Daniel N

    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

    (0) 

Leave a Reply