map M-M relationship between two fact tables
2 posters
Page 1 of 1
map M-M relationship between two fact tables
i have schema with the following tables :
FactOrder with :OrderKey
Attribute1
Measure1
FactCircut:CircuitKey
Attribute1
Measure1
CircuitOrder:Order-CircuitKey
OrderKey
CircuitKey
StatusKey
DimStatus:StatusKey
StatusName
the relation between circuit and order is M-M .the question is how can i handle this schema in sass,is it right and can be implemented or not???
Thanks in advance for help.
FactOrder with :OrderKey
Attribute1
Measure1
FactCircut:CircuitKey
Attribute1
Measure1
CircuitOrder:Order-CircuitKey
OrderKey
CircuitKey
StatusKey
DimStatus:StatusKey
StatusName
the relation between circuit and order is M-M .the question is how can i handle this schema in sass,is it right and can be implemented or not???
Thanks in advance for help.
sara admin- Posts : 4
Join date : 2013-02-10
Re: map M-M relationship between two fact tables
Here is your problem... the Order and Circuit tables are not fact tables. Fact tables do not have attributes.
Can you explain the business process you are trying to model? A fact table represents business events or states. A dimension table provides context to a business event or state.
Can you explain the business process you are trying to model? A fact table represents business events or states. A dimension table provides context to a business event or state.
Re: map M-M relationship between two fact tables
Thanks a lot for your reply.Attribute in order fact table is a key to order type and in circuit fact table the attribute is a key for date .date and oreder type are dimensions .
sara admin- Posts : 4
Join date : 2013-02-10
Re: map M-M relationship between two fact tables
Can you explain the business process you are trying to model? What is a circuit? Are you a electric utility or in the telecom business?
Does an order mean anything if a circuit isn't involved? What measures do you have in the order fact? In the circuit fact?
For example, circuit capacity (bandwidth or load, depending what industry this is) is not a measure. It is an attribute of the circuit. In either business a circuit fact table doesn't make any sense. There are plenty of utilization fact tables that involve a circuit, but circuit is always a dimension.
Does an order mean anything if a circuit isn't involved? What measures do you have in the order fact? In the circuit fact?
For example, circuit capacity (bandwidth or load, depending what industry this is) is not a measure. It is an attribute of the circuit. In either business a circuit fact table doesn't make any sense. There are plenty of utilization fact tables that involve a circuit, but circuit is always a dimension.
Re: map M-M relationship between two fact tables
Thanks for your help, appreciated your support.Order is a fact table,the order capture an event .Order might have multiple circuits and the same circuit might belongs to multiple orders .According to business need we decide to make order cube first and then link it to circuit cube.circuit is a fact table it's not include any measures ,but there are multiple dimensions belongs to it..like circuit type and circuit status.Now we need to link the two facts circuit and order and add another attribute on this relationship,the question is can i use factless table or bridge table????and if i decided to implement the fcatless scenario [Order Fact -Circuit Fact -CircuitOrderFactless with the dimension with belongs to circuit and order together ] is it will be a good schema to be implemented in SSAS?? and is it right to add attribute to the factless table i know factless table contains only keys to facts???
sara admin- Posts : 4
Join date : 2013-02-10
Similar topics
» Modelling parent-child relationship source tables to Fact with correct grain
» Link two fact tables with many to many relationship
» Relationship between scd hierarchies and then between fact tables
» Can a Bridge Table also be used for mapping?
» Relationship between fact table and dimension tables
» Link two fact tables with many to many relationship
» Relationship between scd hierarchies and then between fact tables
» Can a Bridge Table also be used for mapping?
» Relationship between fact table and dimension tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum