Post reply

Calculated Member

  • May 22, 2014 at 11:11 am

    #308375

    I am trying create a Calculated Member in SSAS using the one Fact table and two dimensions but having issues. Below is the sql query I want to use as a

    Calculated member in SSA

    SELECT COUNT(FacteTMS.TaskKey) AS TaskCount, DimeTMSOrg.Description

    FROM FacteTMS INNER JOIN

    DimeTMSOrg ON FacteTMS.OrganizationKey = DimeTMSOrg.OrganizationKey INNER JOIN

    DimDate ON FacteTMS.CreatedDateKey = DimDate.DateKey

    GROUP BY DimeTMSOrg.Description

    Fact table--->FacteTMS

    Dimensions are 1 ) DimeTMSOrg

    2) DimDate

  • May 22, 2014 at 12:12 pm

    #1715820

    Not sure that you need a calc member for this.

    One approach you could try is in the cube designer, dragging/add the task key to the measures area and change the aggregation (in properties pane) to count. This will give you a full count (ie count dupes twice etc) so you may want to consider using a distinct count but this will depend on your data.

    Steve.

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

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