Kimball Forum

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


ETL tool and use of dimensional hirearchy

Kimball Forum :: Topics :: Business Requirements and Program / Project Management

Go down

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

Post  Jaswanth on 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 on 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

Kimball Forum :: Topics :: Business Requirements and Program / Project Management

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