Archive for 'Basic DW Concepts' Category
Hierarchy ( Dimensional Hierarchy) in OBIEE
Hierarchy Hierarchy: The specification of levels that represents relationship between different attributes within a dimension. For example, one possible hierarchy in the Time dimension is Year → Quarter → Month → Day. Dimensional Hierarchy in OBIEE First of all our first task is to thoroughly understand your business model. You have to understand what business [...]
Slowly Changing Dimension – SCD in Data Warehousing
Slowly Changing Dimension Dimension that changed overtime called slowly Changing Dimensions. For Example, People may change their address, sometimes they may change their names, one product price changes over the time these are few examples of slowly changing Dimensions. This is a common issue facing data warehousing practitioners. This section explains the problem, and describes [...]
Fact & Dimension Tables in OBIEE
What is Fact? Fact: A fact table is a table with measures. They must be defined in a logical fact table. Here In data warehousing fact table consists of measurement of fact of certain business scenario. For any business model by asking “what” question you can identify the fact. For example: What are we measuring? [...]