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.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Indirect Joins in SSAS

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.
Go to Top of Page

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
Go to Top of Page
   

- Advertisement -