| OWB help [message #299553] |
Tue, 12 February 2008 07:30  |
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  |
|
|
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
