SAS INFORMATION MAP STUDIO

[Amar]

HI SAS GURUS,

MY BELOW CALCULATION IS NOT WORKING PROPERLY IN INFORMATION MAP STUDIO

THE NET CHANGE NUMBERS ARE NOT COMING OUT TO BE CORRECT

CASE <<RPT_HLD_MTH_SCORECARD.Header_LBL>>

WHEN 'BOP'  THEN <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>

WHEN 'EOP'  THEN <<RPT_HLD_MTH_SCORECARD.EOP_VAL>>

WHEN 'Migrations In' THEN <<RPT_HLD_MTH_SCORECARD.MI_VAL>>

WHEN 'Migrations Out' THEN <<RPT_HLD_MTH_SCORECARD.MO_VAL>>

WHEN 'Churn' THEN <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>>

WHEN 'Adds' THEN <<RPT_HLD_MTH_SCORECARD.ADD_VAL>>

WHEN 'Net Change' THEN <<RPT_HLD_MTH_SCORECARD.EOP_VAL>> - <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>

WHEN 'Nets' THEN <<RPT_HLD_MTH_SCORECARD.ADD_VAL>> - <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>> + (<<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>)

WHEN 'New Match/Other Mig' THEN (<<RPT_HLD_MTH_SCORECARD.EOP_VAL>> - <<RPT_HLD_MTH_SCORECARD.BOP_VAL>>) - (<<RPT_HLD_MTH_SCORECARD.ADD_VAL>> + <<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.CANCEL_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>)

WHEN 'Net Migrations' THEN <<RPT_HLD_MTH_SCORECARD.MI_VAL>> - <<RPT_HLD_MTH_SCORECARD.MO_VAL>>

END

[LinusH]

Can't tell you why this isn't working, but from what I see it seems that you are trying to do something like a transpose, where information maps isn't the ideal tool.

Perhaps you could restructure the data "under" the information map...?

[Amar]

basically i have 4 dimensions, it works fine if i use all 4 dimensions, but if i use 2, when calculating net migrations, its not able to rollup properly