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 08, 2013 3:12 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 2:54 PM
Points: 14, Visits: 152
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: Thursday, April 03, 2014 6:23 AM
Points: 1,135, Visits: 1,149
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