Skip to Content
author's profile photo
Former Member

BW Stats cube - query deletions

Hi,

A question about using the BW Statistics infocube.

If a query is deleted from BW, does the Statistics infocube pick this up in any way?

We are running a query deletion process and it seems like the Stats cube still shows queries that have been deleted.

Do I need to delete the contents of the infocube and reload it every time we run this exercise? (otherwise we don't get a true picture of what is on the system).

Thanks,

Allan

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Jun 03, 2004 at 09:58 AM

    The stats cube will show the deleted Query as it was used in the past.Run a stats query ,drill down by day and this should be confirmed.

    filter by todays date and you will get a true picture of the Queries being used in your system today.

    Tony

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for the reply Tony!

      We were looking into deleting queries that have not been run for the last 6 months and not so much what is currently happening.

      We have filtered by the dates of the last 6 months and so we have a list of queries outside that time period. (which is including already deleted queries). Is there any way of determining the ones that have been deleted from the Stats?