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

BW Statistics for aggregate usage

Posted on Feb 23, 2005 at 07:05 AM 65 Views

Hello experts,

can some one guide me on how the BW Statistics cube can be used to count

1> the "No. of times an aggregate was used by the

queries" .

2> The % of the query users who hit a particular

aggregate in a month

A query on the cube '0BWTC_C02' with

0TCTIFCUBE(InfoCube) in rows and

0TCTSTAUIK(Frequency ) in coulumns doesn't yield the correct result for my aggregate.

Is this the right way of getting the "No. of times an aggregate was used by the queries" or is there any other option.

I'm aware that i can indirectly get these details from RSDDSTAT, but not sure how to use BW Statistics cube for getting this information.

Please help

Best Regards,

Sanjay

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 23, 2005 at 01:22 PM
    2

    I don't see where the aggregate cube name is even captured in this cube. Personally, I think the whole BW Statistics thing comes up a little short of what it needs to be.

    RSDDSTAT is the only place I am aware of being able to get what you are looking for. Haven't tried it, but you should be able to setup an Infoset on it for Bex reporting, or just download the data to Excel or Access as you probably have been doing. Or create your own statistics ODS/Cube that does capture what you need.

    Keep in mind, an InfoCube with multiple aggregates could have more than one aggregate used by a user query but only one aggregate will be captured in RSDDSTAT.

    Message was edited by: Pizzaman

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Feb 24, 2005 at 05:38 AM

      Hello Pizzamn,

      thanks so much for your help !!! Even i felt that the Statistics cube don't provide all that it should. The infoset solution that you have suggested seems to be a viable soultion.

      Thank you very much !

      Good day 🤯),

      Sanjay

      Message was edited by: Sanjay Kumar Pandey

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.