Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

ETL tool and use of dimensional hirearchy

2 posters

Go down

ETL tool and use of dimensional hirearchy Empty ETL tool and use of dimensional hirearchy

Post  Jaswanth Mon Nov 16, 2009 1:01 am

What is the role of ETL in reporting and how we use the dimensional hierarchy in Business layer of obiee

Jaswanth

Posts : 4
Join date : 2009-11-16

Back to top Go down

ETL tool and use of dimensional hirearchy Empty ETL tool and use of dimensional hirearchy

Post  snchunduru Wed Oct 05, 2011 8:38 pm

Jaswanth wrote:What is the role of ETL in reporting and how we use the dimensional hierarchy in Business layer of obiee

The role of ETL is to Extract data from source systems, Transform and Load into staging layer of a data warehouse. The dimensional hierarchy facilitates rollups and drilldown in a reporting / presentation layer.

snchunduru

Posts : 7
Join date : 2011-10-05

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum