April 27, 2007 at 9:23 am
I
When I make a drill on AS2000 over some measures, it returns several records for each record in the fact table. For example I have one transaction record on the fact table, but when I do the drill from the AS2000 it returns six records for each record in the fact table.
In SS2005 I know that exists a solution for this, but in AS2000 I do not know how to solve this. Anyone have any solution?
Thanks
April 28, 2007 at 10:12 pm
I think we hit this once or twice using AS2000. In the end I think it was a join problem in our model. You may want to trace the SQL server to see what exact query is being executed then use this TSQL to determine why the query was created that way. I think we may have also had issues when a field from a snow-flaked dimension was included as a drill through column.
Steve.
April 30, 2007 at 2:43 am
Hi Steve
In fact we are making the drill through in from a snow-flaked dimension. But I can't see how to solve this issue.
Do you remember how did you solved that problem?
Thanks in advance.
Nelson
April 30, 2007 at 8:09 am
Sorry, don't recall. I would try removing the field(s) from the drill through columns that come from the snow flaked table(s) and re-test the drill through. Assuming this then *does* return the correct row counts I would then re-introduce on of the fields and trace the query that hits the SQL server to see how it's being formed.
Steve.
April 30, 2007 at 8:30 am
Hi Steve
I done what you suggested and I find the dimension that was causing the problem. I remove one field and...lucky guess...was that one that was causing the problem.
Thank you very much.
Nelson
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply