Home » Developer & Programmer » Reports & Discoverer » Problem with report with hierarchy on multiple levels
Problem with report with hierarchy on multiple levels [message #226815] Mon, 26 March 2007 11:56
nap123
Messages: 1
Registered: March 2007
Junior Member
Hi,

I am trying to create a report that is based on a hierarchy with multiple levels (recursive table).

I have successfully created the hierarchy as specified in the manual:
http://download-uk.oracle.com/docs/html/B13916_04/hierarchies.htm#CIHIEDEH

The problem is how to join my hierarchy with my fact table. The fact table contains a sum of totals per id belonging to the recursive table.

Has anyone done something like this before? Is it possible to do with discoverer?

Thanks
Previous Topic: REP-3300 fatal error in tool object store
Next Topic: Newer
Goto Forum:
  


Current Time: Wed Dec 07 20:39:25 CST 2016

Total time taken to generate the page: 0.11123 seconds