Problem to add Dimension with relation table

  • 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