<<root.Header>> is the business column not the physical column. when i use the physical column, it works fine. when i say put(<<root.Header>>, 30.) = "overall" it gives an error...
... View more
hi sas gurus i created a data item called "A" which has the logic below in my information map studio CASE WHEN <<root.Header>> = "Overall" THEN <<root.Amt>> end with this simple logic.....when i create a cross tab report in web studio it gives me an error ERROR: Expression using equals (=) has components that are of different data types. please advice.
... View more
u answered my question. yes, this is what i meant. thanks. another question, can i do conditional formatting on on measure value based on category value...so if region = 'a' then measure color = red, else measure color is green
... View more
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
... View more
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
... View more
hi thanks for your reply what i mean is that we use the same cube and set different filters and export different views of that cube into excel. then we finally create one excel sheet, that is final result. now i dont know much, but i was thinking about creating vbscripts to automatically connect to sas cube and get results and format it. is this approach even possible.
... View more
hi sas gurus i am completely new to sas and excel plugin we currently have a 5 reports using the same olap cube but with different filters. finally when all these 5 reports are run, we create a final excel sheet using data from all these 5 excel sheets. basically the user wants to automate the process. any ideas would be appreciated to point me in the right direction.
... View more