Recursive Dimensions in Dimensional Model

kiran.mv at 14h30
21
Mar
2011
Recursive Dimensions in Dimensional Model

An Account is assigned one Industry Classification code as per a Industry Classification Set. Under a different Classification Set, it can be assigned a different Code. E.g. under Classification set SIC, it categorized as Electrical and under another classification set it can be labeled as ‘Lifestyle’.
An industry classification set has multiple Industry classification codes under it. The codes can further have Classification codes und

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 : 1842
  • Numbers of messages : 8656
  • Numbers of users : 3787
  • Numbers of points : 1497
Similar topics
Heterogeneous Security Dimensional Model
Hello, I inherited a DataWarehouse with a hybrid Model. We have a Security dimension table (PK is SecurityId) that has several different types of securities (i.e stocks, bonds, cash). Each of these types of Securities has its own table with specific
Recursive Hierarchy Data Modelling
Hiiii I am pretty new to data warehousing, now after reading a little literature on Data Modelling from our Guru's book Data Warehousing Toolkit I am guessing what could be done to create a data model for my problem. I have a recursively hierarchical
Dimensional model
Hey All In a Star schema, can a Fact table in one data mart be a Dimensional table in another data mart or can we connect two fact tables or what can we do if we need to connect a column (primary key) from one fact table to another fact table? Thank
User Access Control + Dimensional Model
Hi All, How can I implement an user access control along with a dimensional model? Let me take the classic sales star schema: fact_sales, dim_date, dim_store and dim_product. Also I have 100 end-users of my web application. Each user is allowed to
Dimensional model for support ticketing process
I am struggling with a general support process that I have to model in my data warehouse. I have been brainstorming about how I could do this, but until so far without luck. The process is fairly easy: 1. A customer enters a support ticket in the
Forums from same category
See also
more_less
Informations

6 Replies For the topic :
"Recursive Dimensions in Dimensional Model"

This topic has been viewed 1184 times.

Last message :
21/03/2011 at 14h30 by "kiran.mv"