Has anyone experienced this?
I have created a simple query with only three fields. These three fields are all part of the same hiercharchy, and are sequential in that hierarchy.
The WEBI report block only has the field at the top level.
When I use the Drill Method of the web service, it will only drill down one level. When I try to drill down from the second level to the third level, it instead goes back UP to the top level.
Any thoughts?
-tkt
theknowtank (BOB member since 2011-04-20)
I stepped away from this and recently revisited and ran into the same issue.
I forgot that I had made the post above but came here to find assistance, and rediscovered my original post.
Life…
Does anyone have any thoughts here? If it helps, I’ve used Drill Mode in the associated WEBI report, and it drills as expected.
-tkt
theknowtank (BOB member since 2011-04-20)
is this not a webi question?..Pls post it in the webi forum
kraf (BOB member since 2013-06-25)
Since the original post from theknowtank references ‘Drill Method’ and ‘Web Service’, this leads me to believe he is referring to drilling in Dashboard Design/SAP Dashboards/Xcelsius/whatever-it’s-been-renamed. I am having the same issue.
I’ve experimented with the level of scope in the query running the report that holds the bock published as the Web Service called by the dashboard, and it behaves the same regardless what I change it to.
What I DID notice is that if I save the block in the second level of the hierarchy, I can then go to the third and up to the first, like it is only allowing me to drill in any direction just one place in the hierarchy. I checked the universe and the hierarchy seems to be defined correctly.
I’ve seen a few other posts having this same error, hopefully someone out there has a solution or at least a reason for this behavior.
tstarr (BOB member since 2013-10-07)