Organizational hierarchy with employees and SCD

memphis at 06h43
29
Oct
2010
Organizational hierarchy with employees and SCD

Hi,

I have a question on modelling SCDs with my tblDimPosition dimension as depicted in my star schema here:
/dimensional-modeling-and-data-architecture-f6/modelling-free-text-comments-t784.htm

My tblDimPosition basically contains employee data along with each employee's org

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
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
What's the best organizational structure to support BI
What have people found as the most effective organizational structure for BI? I'm not a big fan of IT departments. Their focus seems to be on transactional systems and tend not to understand BI systems. I'm in a line of business and we've had the
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
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Organizational hierarchy with employees and SCD"

This topic has been viewed 2269 times.

Last message :
29/10/2010 at 06h43 by "memphis"