SQL Olap Grand Total RRS feed

  • Question

  • Hy

    when i use calculated measures in olap, is there anyway, that grand totals show sum of this calculated column and not calculation of other totals.


    Tuesday, June 14, 2011 5:48 AM


  • Yes, there are a few ways of doing this. It really depends on what you are calculating. You can write your calculation as the sum of the leaf level attributes or some types of calculations you can push part of the calculation into the DSV.
    http://darren.gosbell.com - please mark correct answers
    • Proposed as answer by Jerry Nee Thursday, June 16, 2011 3:27 AM
    • Marked as answer by Jerry Nee Saturday, June 25, 2011 6:23 AM
    Tuesday, June 14, 2011 9:48 AM