I am very new to SSAS and trying to make some mdx. I am stuck in some problems as follows
I am trying to make a Data Source View with following tables.
Table1 - TransTV
Table2 - MasterCountry
Table3 - MasterCompany
Table4 - Master_Unit_Period
Id_Unit_Period (Define Week by number, 1 is assign for first week of 1990. So current (July 2013 second week) week id is 1469)
Date_From (1 Jan 1090 for id 1)
Date_To (6 Jan 1090 for id 1)
Table5 - Relation_Master_Unit_Period
I have define relation of Table1 with Table2, Table3, Table4. And Table4 have a relation with Table5.
But When I try to define Cube, It show only Table2, Table3 and Table4 in Dimensions. And Table5 is not shown there. But I have to add Year and month as Column in my MDX query.
Please tell me where I am going wrong?
Thanks in advance.