July 11, 2013 at 4:20 am
Hello,
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
Id_Tv
Id_Country
Id_Company
Id_Unit_Period
Budget1
Budget2
Table2 - MasterCountry
Id_Country
Name_Country
Table3 - MasterCompany
Id_Company
Name_Company
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
Id_Relation_Unit_Period
Id_Unit_Period
Year
Month
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.
-Arvind
Viewing 0 posts
You must be logged in to reply to this topic. Login to reply