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 China
FactSales --------- 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 like StateCodes 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 |
 |
|
|
|
|