Skip to Content
author's profile photo Former Member
Former Member

BI_STAT job

Hi experts,

when I use infopackage loading data, I notice that there is BI_STAT* job running after data loading is finished (traffic light is green).

this job is re-build index and statistic but it last so much time. meanwhile, other infopackage which try to upload the same cube will show error.

1. I check the SAP LOCK conception, it's not saying we can upload data when index & statistic is builting.

2. anything can reduce the running time of BI_STAT job

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2005 at 08:19 AM

    Hi Jie,

    I guess it refreshes the statistics for all the data in the cube.

    For changing the value contact somebody who has access to change the values OR contact your BASIS.

    I guess in process chain you can specify the percentage so try there.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 22, 2005 at 08:02 AM

    Hi Jie,

    BI_STAT* job is for rebuilding statistics for the cube. Make sure the cube is loaded and only then the index and stats are rebuilt. Another way to reduce the time is to use lesser percentage of cube data for stats. SAP suggests 10%.

    Bye

    Dinesh

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,Dinesh,

      how to change statistic percentage setting? I can not directly change in "performance" tab of cube management.

      and for rebuilding statistics and index, I thing BW just rebuilding them for single request ( 10 thousands recodes), why it take so long time for large cube( almost half hour, but small cube is fast ), is means that BW will delete and rebuild all of index and statics of all of record when one request is coming?

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.