Drill Through reports

Drill Through reports

Leinad Astle
Leinad Astle

October 11th, 2010, 9:38 am #1

Hi All,

Is it possible establish a Drill-through capability in all level and in all the 14 Dimension in Essbase ASO cube. To bring all the other 18 column from Oracle Fact Table

Literally it means that all the intersection should have the Drill-through Capabilities .

I had established Drill-Through in EIS for all the level -0 it works with having great toll on the retrieval performance. But when I drag all the dimension to Drill –through intersection box it doesn’t Work

Any suggestion can this be implemented in any other Hyperion Tools. Is there any other way/approach to implement this

Astle
Quote
Share

Cameron Lackpour
Cameron Lackpour

October 11th, 2010, 10:43 am #2

No, I don't work for AppliedOLAP. Yes, I think the tool is awesome.

So with that out of the way, and as this is the second time in a week or so that this question has been asked, have you taken a look at Dodeca?

Here's Tim's latest posts on Dodeca's relational functionality:
http://timtows-hyperion-blog.blogspot.c ... ca-50.html
http://timtows-hyperion-blog.blogspot.c ... ca-50.html
http://timtows-hyperion-blog.blogspot.c ... 50_17.html

You have inspired me (you can either be frightened or flattered or utterly bored by this) to write a blog post to show how a SQL Slob (I think that is accurate description of my SQL skills) like me can write a drill through at any level in a Essbase cube. Of course, what with my actual job getting in the way, this could take a few weeks, but hey, I may get fired and in that case I will have lots of free time.

Thanks for the idea.

Regards,

Cameron Lackpour
Quote
Share

GlennS
GlennS

October 13th, 2010, 1:13 pm #3

Hi All,

Is it possible establish a Drill-through capability in all level and in all the 14 Dimension in Essbase ASO cube. To bring all the other 18 column from Oracle Fact Table

Literally it means that all the intersection should have the Drill-through Capabilities .

I had established Drill-Through in EIS for all the level -0 it works with having great toll on the retrieval performance. But when I drag all the dimension to Drill –through intersection box it doesn’t Work

Any suggestion can this be implemented in any other Hyperion Tools. Is there any other way/approach to implement this

Astle
While this should be possibly, is it really what you want. If you were to allow users to pick any level, they could pick the top of all of the dimensions and get back your entire SQL table. I don't doubt retrieval performance is bad. Rather, I would create multiple reports that allow drill-through bases on certain dimension be at level zero while other can be higher up.
I would also suggest, looking closely at the generated SQL and modifying it to optimize it. In most cases I have found I could create more efficient queries
Quote
Share

Joined: January 25th, 2011, 12:18 am

February 2nd, 2011, 6:09 pm #4

What is the syntax for $$ parameters and how does Smartview see / pass / create them?
Quote
Like
Share

Joined: January 25th, 2011, 12:18 am

February 3rd, 2011, 12:07 am #5

Nevermind.
Quote
Like
Share

Mark
Mark

March 19th, 2012, 3:22 pm #6

No, I don't work for AppliedOLAP. Yes, I think the tool is awesome.

So with that out of the way, and as this is the second time in a week or so that this question has been asked, have you taken a look at Dodeca?

Here's Tim's latest posts on Dodeca's relational functionality:
http://timtows-hyperion-blog.blogspot.c ... ca-50.html
http://timtows-hyperion-blog.blogspot.c ... ca-50.html
http://timtows-hyperion-blog.blogspot.c ... 50_17.html

You have inspired me (you can either be frightened or flattered or utterly bored by this) to write a blog post to show how a SQL Slob (I think that is accurate description of my SQL skills) like me can write a drill through at any level in a Essbase cube. Of course, what with my actual job getting in the way, this could take a few weeks, but hey, I may get fired and in that case I will have lots of free time.

Thanks for the idea.

Regards,

Cameron Lackpour
Hey, I am working on something very much like your problem. Did you find an answer?

Thanks
Mark
Quote
Share


Confirmation of reply: