Tracking changes in a hierarchy

fico at 11h21
22
Sep
2010
Tracking changes in a hierarchy

Hi,

I'm working in a DW project on a bank. They don't like to much the use of subrrogate keys and they prefer to use natural keys. One of the problems we have is a product hierarchy. I'm going to simplify it. The hierarchy is something like:

Category
|
SubCategory
|
Product

The problem is that one product can belong to more than one Subcategory and one Subcategory can belong

Read more
Reply
About
This topic belongs to the forum

  • Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.

  • Numbers of topics : 1858
  • Numbers of messages : 8714
  • Numbers of users : 3801
  • Numbers of points : 1672
Similar topics
Further reading for Recursive Hierarchy Data Modelling
Hi all I need to research Recursive Hierarchy Data Modelling in depth. I have read: www.dbmsmag.com/9809d05.html Can any readers of this forum point me in the direction of any other _detailed_ material on this subject? With anticipatory
Dimension Hierarchy - Facts by various levels
Hello, I am working on a new project (with Oracle OBIEE) where most data needs to be seen by a terminal(game or cahsier). The terminals are located in different venues in various cities and states. Some terminals may just be at a city or a state level
Hierarchy within single dimension or two dimensions
I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific
Facts at different levels of hierarchy
Let's say I have an empoyee dimension consisting of the usual attributes describing a person, but also these two: Department and Company. Let's also say I have budget numbers for the three levels (Employee, Department, and Company). I would think tha
Joining Type II Dimension Hierarchy directly to Fact versus through a Dimension table
Given I have 3 tables, Workforce Event Fact, Department Dimension (Type II SCD), and a Department Hierarchy (Type II SCD), and assuming the DEPTIDs in the Department Dimension table are reflected in a BASEDEPTID field in the Dept Dimension hierarchy table
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"Tracking changes in a hierarchy"

This topic has been viewed 746 times.

Last message :
22/09/2010 at 11h21 by "fico"