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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Jul 04 12:12:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.