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

SSAS DIMENSION USAGE ISSUE Expand / Collapse
Author
Message
Posted Tuesday, October 8, 2013 3:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 4:10 AM
Points: 16, Visits: 156
Hi,

Can some one help me to set up DIMENSION USAGE for below tables

Fact: SQLExecutions_Fact
No of Executions ( measure )
Physical_TableNameID

Dimension 1: PhysicalTableName_Dim
Physical_TableNameID (PK)

Dimension 2: LogicalTableName_Dim
Logical_TableNameID (PK)
Physical_TableNameID

Dimension1 -> Dimension 2 is one to many relationship

Please let me know how to set up this.

V

Post #1502840
Posted Thursday, October 10, 2013 9:28 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 1:01 PM
Points: 1,166, Visits: 1,191
vinay4444 (10/8/2013)
Can some one help me to set up DIMENSION USAGE for below tables

Fact: SQLExecutions_Fact
No of Executions ( measure )
Physical_TableNameID

Dimension 1: PhysicalTableName_Dim
Physical_TableNameID (PK)

Dimension 2: LogicalTableName_Dim
Logical_TableNameID (PK)
Physical_TableNameID

Dimension1 -> Dimension 2 is one to many relationship

Please let me know how to set up this.

Take a look at this and see if that helps:

http://technet.microsoft.com/en-us/library/ms170463.aspx

Rob
Post #1503656
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse