This content has been marked as final. Show 2 replies
There is clearly a disconnect between your Drill Through Report and your outline. The DTRs should not even be available at intersections higher than those the report is set to.
By any chance, did you change the order of your Dimensions in EIS? That can cause the problem you are seeing. For each metadata outline the EIS catalog assigns system numbers to the dimensions from top to bottom beginning with 1. DTRs uses & stores those numbers in the DTR definitions, as well as the levels the drill is allowed at those dimensions.
If the DTR thinks the system number is one dimension, but turns out to be another, you will have problems.
Hope this helps,
Let me clarify - EIS crashes (not all the time) before the user is presented with the box for choosing the drill through report link. Normally this is just empty when they try and drill at a higher level than any report, but sometimes it crashes EIS when they do and doesn't present the empty box.
Just wondered if anyone else also had the same issue or if it's just due to the version with MS SQL 2005. we are upgrading to SQL 2008, which doens't appear to do the same thing...yet.