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 |
|
learntsql
524 Posts |
 Posted - 2014-04-14 : 11:38:04
|
| Hi All,I am preparing an SSAS cube in 2008 R2 version.I have a following dimension table (sample table) in my warehouse.Dim_Geography-------------Country -------India ChinaFactSales---------SateCode - LocationCode - Date - SaleValue----------------------------------------------1A - 1IL1 - 1-Apr-14 - 10K 2A - 2IL1 - 2-Apr-14 - 12K 1CN - 1CNL1 - 3-Apr-14 - 11K 2CN - 2CNL1 - 4-Apr-14 - 14K When i have to join Dim and Fact tables i dont have direct mapping column, but indirectly i can join likeStateCodes 1A and 2A belongs to India and 1CN and 2CN are belongs to China.In dimension table i have only country level data.how can we handle in SSAS with this kind of design.Can some one please guide on this?Thanks a lot in advance. |
|
|
learntsql
524 Posts |
Posted - 2014-04-15 : 02:05:14
|
| Hi All,Can someone please give some idea to proceed.I am stuck here...TIA. |
 |
|
|
learntsql
524 Posts |
Posted - 2014-04-15 : 10:30:01
|
| Hi All,I have found an alternative that,I have created a named query and hard coding the values for time being and using that as dimension.for joining using the common column satecode.i have to test it now.I will post the update if it works.please let me know if you find any better solution.TIA |
|
|
|
|
|
|
Indirect Joins in SSAS