How to handle the string measures in the cube RRS feed

  • Question

  • Hi,

    I have 6 dimensions and one fact table in my cube.  I have few columns with flag values (YES,NO) in the fact table.

    Requirement: I need to calculate the opening headcount and the closing headcount of employees for each month. 

    if he is in the headcount the value in the opening_HC column will be yes and if he is not the value will be 'no'. and the same for the other columns also,( based on some formulas.)

    Fact Table Date:

    Empid , -- ,--, --,--, Opening_HC, Closing_HC

    001, --,--,---,--, yes, no

    The granularity is in month.

    can any one explain how to handle the string measures in fact table. 

    Note: I dont have these values in the dimension tables.

    Thanks in Advance.......!

    Balaji - BI Developer
    Wednesday, August 3, 2011 9:19 AM


  • Hi Balaji,

    You can achieve this by altering your fact table source in DB (in DSV as well) and making/altering your View for changing the column values for Opening_HC and Closing_HC as CASE When Opening_HC = 'Yes' Than 1 ELSE 0 AS Opening_HC and similarly for Closing_HC. In this way you will have 1's and 0's in your fact table for these columns which could be aggregated to give you the total head count.


    Wednesday, August 3, 2011 9:54 AM