Monthly Archives: March 2007

Explanation Behind the Incorrect Query Results

After about a week and a half of ongoing discussions we’ve come up with an explanation as to why the queries were returning bad numbers. Thank goodness!   To make a long story short, I had manually designed aggregations that … Continue reading

Posted in Uncategorized | 1 Comment

Proclarity Option – Speed Up Queries

By default, Proclarity has an option which checks to see the size of a query. If it exceeds a certain threshold it throws up a message box like this:     I never thought much about it until users started to … Continue reading

Posted in Uncategorized | Leave a comment

Aggregations causing bad numbers?

Last week I wrote about incorrect totals being returned when performing a drilldown. I believe I know what the cause of it is – aggregations.   Figure One: Grand Totals are correct – they represent the total from the fact … Continue reading

Posted in Uncategorized | 2 Comments

SOLUTION: Drilling down brings back incorrect totals

After a day of messing around I found the issue with the incorrect drilldowns. Ends up it was some kind of conflicting aggrgations. The aggregations would correct themselves next morning when a parent child dimension would process, thus rebuilding indexes … Continue reading

Posted in Uncategorized | Leave a comment

Drilling down brings back incorrect totals

I’m going insane here trying to figure out this issue and was wondering if anyone had ideas as to what the cause.   If you look at the below picture, the totals are incorrect for 3/5. Tier 1 shows a … Continue reading

Posted in Uncategorized | 5 Comments