many to many relationship between dimension level

GBS74 at 15h51
26
Oct
2009
many to many relationship between dimension level

I need help to design dimension model. Detail of Dimension are as following:
Dimension : Student, School
Fact : Grade

1. Class_Year
2. School
3. Area
4. City
Analysis Requirement are to drill up /down by above given hierarchy

there is :
M:1 relationship between Area and City
M:1 relationship between School and Area.

Issue : there is M

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
Relationship between scd hierarchies and then between fact tables
I have some SCD Type 2 dimension to be related hierarchically, as follows: DIM_CATEGORY Categ_ID Categ_Code C_DescriptionC_start_Date C_end_date C_active C_Other_data 1 C1CAT1.0 01/01/2011 05/03/2011 0 ZZZ2 C1 CAT1.105/03/2011 08/20/2011 0 ZXY 3
SSAS 'Fact Dimension' v 'Regular Dimension' your views
Hi, I have been a user of this forum for a while but haven't registered until now. First of all, hello fellow BI developers :-) I have put a similar post on the MSDN BI Section but thought I would post here as I could get different views/answers
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
Fact/Dimension Reload Design
Hello fellow DW/BI practitioners! I am in process of designing ETL for an enterprise-wide DW. One of the ideal functionality is to have a parameter driven capability to re-load historical fact transactions along with dimensions. What ETL metadata needs
Grain present at every level of a dimension
I am currently modeling factory processes. Following is one of the interesting scenarios: Suppose there is a dimension called Organization (let's call it Org) that contains the hierarchy (top down): Factory - Department - Business Unit - Machine. There
Forums from same category
See also
more_less
Informations

3 Replies For the topic :
"many to many relationship between dimension level"

This topic has been viewed 2091 times.

Last message :
26/10/2009 at 15h51 by "GBS74"