Skip to Content
Author's profile photo Former Member

How to stop performance statistics tables UJ0_STAT_HDR (Header) & UJ0_STAT_DTL(Details) entries for BPC tool

When the statistics parameter is ON in BPC ADMIN client.

The UJ0_STAT_HDR (Header) & UJ0_STAT_DTL(Details)  tables grows very large and may affect performance .


We have two options to control the size of these tables :

  1. Delete the table entries using program: UJ0_STATISTICS_DELETE using APP SET ID.
  2. We  can stop the performance  statics  generation Go to the BPC ADMIN and OFF the  BPC parameter BPC_STATISTIC.We can do this for APPSET or Specific Applications.
    1. Steps to switch OFF the parameter for one APPLICATION.
    • Open BPC ADMIN Client
    • Go the web client .Double click the “Interface for the web”. This will be opened in a web browser (preferably IE).

          BPC1.png

    • Choose Application
    • Go to the Administration shown below 

/wp-content/uploads/2013/11/admin2_318092.png

    • Go to the set application parameter shown below

/wp-content/uploads/2013/11/admin3_318094.png

    • Turn OFF the BPC_STATISTIC parameter

/wp-content/uploads/2013/11/admin4_318106.png

Assigned tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Roberto Vidotti
      Roberto Vidotti

      despite the tag, it has nothing to do with MS version, please remove the Tag.

      Images aren't visible.

       

      Regards

           Roberto

      Author's profile photo Ashok Babu Kumili
      Ashok Babu Kumili

      Hi,

      Useful info. Thank you.