Home » Fusion Middleware & Colab Suite » Business Intelligence » DRILL DOWN in OBIEE
icon5.gif  DRILL DOWN in OBIEE [message #313693] Mon, 14 April 2008 03:55 Go to next message
amritaseema
Messages: 47
Registered: January 2008
Member
Hi All,
can any one please help me out.
I want to craete a drill down like this:-
Channel->Product Category->Product Sub category->Customer
and all these are from different tables.
can u plzz tell me how to create drill down for the example which i mentioned above.

Thanks

Seema

[Updated on: Mon, 14 April 2008 03:55]

Report message to a moderator

Re: DRILL DOWN in OBIEE [message #313734 is a reply to message #313693] Mon, 14 April 2008 06:36 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
it is possible...

narating the solution with explanation will take 2 hours
for me..

I hope someone else will be able to help you breifly

Take the reply "it is possible"

yours
dr.s.raghunathan
Re: DRILL DOWN in OBIEE [message #313758 is a reply to message #313734] Mon, 14 April 2008 08:05 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
see http://download.oracle.com/docs/cd/E10415_01/doc/bi.1013/b31770.pdf, chapter 5, paragraph "about hierarchies and dimensions".
Re: DRILL DOWN in OBIEE [message #354055 is a reply to message #313693] Thu, 16 October 2008 04:32 Go to previous messageGo to next message
rapathania
Messages: 1
Registered: October 2008
Junior Member
Hi Amreeta,

If u know how to create drill down from single table then it will easy for u to understand.

Steps:-
1. Create new Dimension.
2. Call(Drag) Channel, Product Category, Product Sub category, Customer columns to newly created dimension.
3. Then give them parent-child relation as u do for columns of single table. e.g. Make Channel parent & Product Category its child and so on. AT the end u will get drill down hierarchy like:-
Channel->Product Category->Product Sub category->Customer

Note:- Your drill down result depends upon the relation among the tables from where you take the columns.

please write if u need further help

take Care

Rajesh
Re: DRILL DOWN in OBIEE [message #409052 is a reply to message #354055] Fri, 19 June 2009 01:11 Go to previous messageGo to next message
rocky_tar
Messages: 1
Registered: June 2009
Junior Member
Hi Rajesh,
I have created a drill down as
ProductCategory<SubCategory<Product
but I am facing a problem that is
When I click category ,subcategory opens up and after that I can drill down both Category as well as subcategory to
open up Product.Category should have been disabled here.
Is there some property that I need to set .

Another thing is can we have drill down and drill up as well on the same columns like when it opens up and I reverse the clicks it gets closed.Is it possible in OBIEE?

Regards,
Rochak
Re: DRILL DOWN in OBIEE [message #418801 is a reply to message #409052] Tue, 18 August 2009 10:24 Go to previous messageGo to next message
skooman
Messages: 913
Registered: March 2005
Location: Netherlands
Senior Member
Drilling up and down and expanding/collapsing to detailed columns will most probably be availabe in version 11. Not in the current version.
Re: DRILL DOWN in OBIEE [message #472881 is a reply to message #418801] Tue, 24 August 2010 09:59 Go to previous message
heedtheball
Messages: 6
Registered: August 2010
Junior Member
It is - just been playing Surprised)
Previous Topic: can i your Oracle 10g-64 of linux for OBIEE
Next Topic: Urgent Help
Goto Forum:
  


Current Time: Fri Mar 29 00:02:36 CDT 2024