Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Problem to add Dimension with relation table Expand / Collapse
Author
Message
Posted Thursday, July 11, 2013 4:20 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 19, 2013 6:24 AM
Points: 7, Visits: 60
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
Post #1472495
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse