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 |
|
thepitzaboy
Starting Member
1 Post |
 Posted - 2009-03-24 : 16:28:57
|
| Hi experts,in my cube I have two heirarchies, product and location. Now we are trying to save the sales info in a table factsales which has columns product and location along with sales. Now the way we maintain heirarchy in both location and product dimension is:childid,parentid,type and nametype here basically tells us the level.Till this part the cube is working fine. Now the problem starts when we have a store which has multiple parents. Now this also is conditional. So lets say the lowest level is store and the lable above is a dc. Now a particular product group for the same store comes from one DC and some other group comes from other DC. How can we have this kind of information saved in our cube. Also this is the case only with few stores not all of them . It would be great if you can guide me to a solution without changing the cube structure too much. If you need more details please feel free to ask me with particular questionsRegards,Supriyo |
|
|
|
|
|
Multiple parent for a child