Granularity In two different Dimensional Models
2 posters
Page 1 of 1
Granularity In two different Dimensional Models
I have built two Dimensional Models, one for Sales business process and another for a Budget business process.
The Sales has a Client dimension with an attribute called channel, the Budget model can only have channel but not Client, the company doesn't do it in the client granularity, so I create a Degenerate Dimension in the Budget Fact table for the channel in this Model. Is this approach ok ? How can I join this two different dimensions inside an Analysis Services Cube? I've tried to create a relation between this two attributes in the DSV but when I explore the cube, the Budget value its the same for every channel when I use the client dimension channel, and its the same using the DD channel from budget, Sales are always the same for every value of the DD.
The Sales has a Client dimension with an attribute called channel, the Budget model can only have channel but not Client, the company doesn't do it in the client granularity, so I create a Degenerate Dimension in the Budget Fact table for the channel in this Model. Is this approach ok ? How can I join this two different dimensions inside an Analysis Services Cube? I've tried to create a relation between this two attributes in the DSV but when I explore the cube, the Budget value its the same for every channel when I use the client dimension channel, and its the same using the DD channel from budget, Sales are always the same for every value of the DD.
caladsantiago- Posts : 3
Join date : 2011-12-22
Age : 36
Location : Medellín-Colombia
Re: Granularity In two different Dimensional Models
Hi ... calad ?
It sounds to me like you should take a step back from SSAS and redesign your dimensional model. Probably Channels should be a new dimension with relationships to your Sales and Budget Facts. Move all the Channel-related attributes to this new dimension.
Once you have your data structured that way, you can build a single Channels dimension in SSAS and relate the two Facts to it, then use that in your multi-Fact analysis.
Good luck!
Mike
It sounds to me like you should take a step back from SSAS and redesign your dimensional model. Probably Channels should be a new dimension with relationships to your Sales and Budget Facts. Move all the Channel-related attributes to this new dimension.
Once you have your data structured that way, you can build a single Channels dimension in SSAS and relate the two Facts to it, then use that in your multi-Fact analysis.
Good luck!
Mike
Similar topics
» From Enterprise Models to Dimensional Models. Can a single Dimension table be referenced multiple times in a fact table?
» Pre-Built Dimensional Models
» Dimensional models for K-12 education
» Example of a business process with more than 1 fact table
» Text Analytics and Dimensional Models
» Pre-Built Dimensional Models
» Dimensional models for K-12 education
» Example of a business process with more than 1 fact table
» Text Analytics and Dimensional Models
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum