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

BW Statistics and setup

Hi,

I have activated the statistics from the business content, and also initialised the cubes and started the delta for cubes only. Is this enough or should I do something more, because I have not uploaded any text or master data for the statistics characteristics and also not maintained the tab performance of the Cubes. Is it necessary to maintain the performance tab of the cubes and load masterdata and texts.

Thnx

Add a comment
10|10000 characters needed characters exceeded

Related questions

7 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 09:57 AM

    Hi Sai,

    Go to RSA1

    Menu-

    Tools-Bw Statistics for InfoProviders

    Select Your InfoCube for OLAP/WHM

    Hope this helps.

    Regards,

    Ashish Goel

    (Reward with points if the solution helps you)

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2005 at 09:58 AM

    Hi Shiva,

    After activating the BW stastics cubes , fill those cubes by using corresponding datasources.Then execute predifined queries over those cubes so that u can get performance information .

    Kind Regards

    N.Prasad Babu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 09:57 AM

    There is a "How to set up BW statistics " paper available in the SDN. Try this link: https://www.sdn.sap.com/sdn/developerareas/bi.sdn?contenttype=url&content=/irj/servlet/prt/portal/prtroot/com.sapportals.km.docs/documents/a1-8-4/how to set up bw statistics

    Hope this helps,

    Manuel

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 11:03 AM

    Hi,

    Although I have awarded points to all, am not happy with the answers, Please answer after reading my post.

    Thnx

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 11:12 AM

    Hi Shiva,

    if you have activated from the business content what do you need to have in order to make statistical info available about your dataload, query performance and so on, now the next step is to load all related master data (if you have already enabled the capture of the statistical info for your cubes, OLAP and WHM)!

    Now I'm assuming that you have read the suggested HOW-To, because here you can find all the answer that you need!

    Performance tab is another thing: it allows to gain better performance, not to have info about performance (from a statistical point of view)! Push the help button inside the performance tab to have related explanations...

    Bye,

    Roberto

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 06, 2005 at 12:21 PM

    Am not sure what you want to maintain on performance tab, but for sure you have to full load 0TCT* infoobjects with master data and texts.

    We have infopackage group acivated Technical Content->BW Statistics->Master Data to do full loads every weekend.

    Regards,

    Vitalik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2005 at 12:52 PM

    As Roberto and others have mentioned -

    You need to load master data and consider all the other InfoCube administration options just as you would any other cube. There's no magic to the BW Statistics InfoCubes. Data is extracted from the RSDDSTAT* tables and loaded to InfoCubes just like any other application.

    So you ought to consider compression, data retention, etc, just as you would any other application's data.

    One other thing you should consider - if you are loading the statistics cubes, you probably don't need to retain as much data in the RSDDSTAT* tables. From the "BW Statistics for Infoproviders" option, you can click on the trash can and then specify the a date and all the statistics in the RSDDSTAT* tables before that date will be deleted. I would run this off hours and delete data in smaller chunks, e.g. a month, until you see how long

    each delete job runs.

    Personally, I don't think there is any need to retain more than 3 months data in RSDDSTAT* tables once you have your data in the cubes. I like 3 months because if you use ST03 to access the the data, it only goes that far.

    Add a comment
    10|10000 characters needed characters exceeded

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.