Home » Developer & Programmer » Warehouse Builder » OWB help (oracle 10g)
OWB help [message #299553] Tue, 12 February 2008 07:30 Go to next message
aarti81
Messages: 235
Registered: December 2007
Location: USA
Senior Member
Hi

I have to gnerate reports ,using the data from the people soft whicjh is in the form of flat files, for this i need to create dimensions and facts.The problem is when i create a dimension it has multiple leveles and each level has multiple attributes.pls see the following example.


BALANCE_SHEET - Balance Sheet Accounts
ASSETS - Assets
[110000 - 150317]
[151610 - 151620]
[A12110 - A13999]
[A14214] - Short Term Prepaid Assets
[A14999] - Capital Leases
[A15214] - Short Term Prepaid Amort
[A15999] - ACD Capital Leases
FIXED_ASSETS - Fixed Assets
PURCHASED_ASSET - Purchased Assets
PFURN_MACH_EQ - Purch Furniture Machinery Equi
[A14001 - A14003]
[A14099] - Pre-Paid, Maintenance
[A14100 - A14213]
[A14500 - A14900]
PACD_FURN_MACH_EQ - Purch ACD Furn Mach Equip
[A15001 - A15003]
[A15099] - ACD: Pre-Paid Maintenance
[A15100 - A15213]
[A15300] - ACD: Building Improvements
[A15500 - A15900]
LEASE_ASSETS - Lease Assets
LLAND - Capital Lease Land
[A14004] - Capital Lease Land
So pls can any one give me an idea, as to how to put all this data into a seperate table ,away from the star schema and point it when i run the mapping.


Thanks
Re: OWB help [message #299864 is a reply to message #299553] Wed, 13 February 2008 07:33 Go to previous message
sunilgond
Messages: 35
Registered: January 2008
Location: INDIA
Member

Hi u create different dimensions for different levels and create one relationship table containing the relationship beetween all the dimensions. and now u can populate your fact.




Sunil Kumar Gond
Satyam computer Services Ltd.
Previous Topic: convert varchar2 to number datatype in warehouse builder
Next Topic: OWL - Help!
Goto Forum:
  


Current Time: Sun Dec 04 14:27:59 CST 2016

Total time taken to generate the page: 0.12864 seconds