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 |
|
teg
Starting Member
14 Posts |
 Posted - 2010-10-19 : 11:56:16
|
| Now We used to have a one to one relationship between our Sales team managers and each customer (See Customer and Responsibility below), but now as we have split our business up into different business areas, effectively treating them as different business'. We might sell different products to the same customer, and therefore each Business Area will have a different account manager for the same customer. Here was the original structureNow We used to have a one to one relationship between our Sales team managers and each customer (See Customer and Responsibility above), but now as we have split our business up into different business areas, effectively treating them as different business'. We might sell different products to the same customer, and therefore each Business Area will have a different account manager for the same customer. Here was the original structureFact tableproductidcustomeridsales_Valueetc.,ProductProductidProduct_descBusiness_Area_idetc.,CustomerCustomeridCustomerNameAccountMgr_IDetc.,BusinessAreaBusiness_Area_idResponsibilityAccountMgr_IDAccount_Mgr_NameThe below table demonstrates an intermediate dimension table I have created to replace the one to one dimension link from fact to customer to Responsibility. ResponsibilityBACustomeridBusiness_Area_IDAccountmgr_IDDirector_IDAccountMgrAccountmgr_IDAccountMgr_NameDirectorDirector_IDDirector_NameDoes anybody have any experience creating this into a cube. I have added it, but its not allowing me to scroll through and just puts the same total in all the different members. It will always be necessary to include a business Area in the selection to see a true reposnsibility hierarchy, but this isnt making much difference at the moment. Anyone have any idea where I am going wrong. Any articles tackle this?Should I create a new dataview? Should I create a new dimnsion or include it as part of the customer one???Thanks Teg |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-10-19 : 14:38:02
|
| seehttp://technet.microsoft.com/en-us/library/ms345139(SQL.90).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
Adding new one to may dimension into cube... ahhhh