Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
 Posted - 2011-10-05 : 14:43:19
|
| Hi,I have 2 fact tables which I am having a problem linking through Analysis services when building a cube, could I explain what I have first:Fact Statement:Customer dimTime DimProduct DimStatement FactFact Contact:Customer DimTime DimChannel DimContact FactThe requirement is to track all the customer statements, like balances, spend, etc which I can model fine with a simple SSAS Cube.Then in the same cube, when drilling down on the selection of customers off the statement fact, would then like to know how theyve been contacted.Both fact tables share the same Customer Dimension which I thought would be enough, but it doesnt seem to be the case. Do i need more commonality?Thanks in advance. |
|
|
cipriani1984
Constraint Violating Yak Guru
304 Posts |
Posted - 2011-10-06 : 04:20:45
|
Is what ive described not enough to understand?Please let me know I will then provide more information!quote:
Originally posted by cipriani1984
Hi,I have 2 fact tables which I am having a problem linking through Analysis services when building a cube, could I explain what I have first:Fact Statement:Customer dimTime DimProduct DimStatement FactFact Contact:Customer DimTime DimChannel DimContact FactThe requirement is to track all the customer statements, like balances, spend, etc which I can model fine with a simple SSAS Cube.Then in the same cube, when drilling down on the selection of customers off the statement fact, would then like to know how theyve been contacted.Both fact tables share the same Customer Dimension which I thought would be enough, but it doesnt seem to be the case. Do i need more commonality?Thanks in advance.
|
 |
|
|
|
|
|
|
|
Modelling help