none
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

Answers

  • 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.

    Regards,
    Santosh

    Wednesday, August 3, 2011 9:54 AM