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 |
|
busysatish
Starting Member
2 Posts |
 Posted - 2009-11-03 : 12:52:46
|
| I created a policy cube and wanted to get the Direct Written Premium for different statuses. The Direct written premium field is present in Fact_Policypremiumtransaction table. The Statuses are present in the Dim_Status table. But there is no direct relationship between Fact_PolicyPremiumtransaction table and Dim_Status table. But Dim_Status table has a relationship with Fact_Policytransaction table by Status KeyFact_Policytransaction has a relationship with Fact_Policypremiumtransaction by Policy Key.When I processed the cube with out providing the relationship in Dimension Usuage between Fact_Policypremiumtransaction and Dim_Status. I m getting repeating values for the Direct Written Premium.Please suggest on how to establish this relationship in the Dimension Usage. |
|
|
|
|
|
Question on Relationship in Dimension Usage