Post reply

SSAS DIMENSION USAGE ISSUE

  • October 8, 2013 at 3:12 pm

    #151287

    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

  • October 10, 2013 at 9:28 am

    #1657616

    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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply