locked
Grand Total not working in Cube browser RRS feed

  • Question

  • Hi All,

    I am noticing a strange issue in the cube browser related to Grand Total at the bottom of the result set.

    When I am browsing the dimensions, the grand total is giving the first attribute value of a measure. For example

    Dimension - DimWorkType - Attriibute - WorkTye

    ABC  $100

    CDE  $200

    EFG  $300

    Grand Total $100

    I am not sure what is wrong here...I am in SQL Server 2008 standard edition?

     


    Thanks, Gaurav
    http://gauravsqlserver.blogspot.com
    Thursday, July 7, 2011 6:07 PM

Answers

All replies

  • What is the Aggregation formula for the measure? This will happen if it is set to FirstChild
    -Remember to mark as helpful/the answer if you agree with the post.
    Thursday, July 7, 2011 6:20 PM
  • This is working fine after I build the aggregations for all the fact tables. Please ignore this question.
    Thanks, Gaurav
    http://gauravsqlserver.blogspot.com
    • Marked as answer by Gaurav 17 Friday, July 8, 2011 6:54 PM
    Thursday, July 7, 2011 6:25 PM