Drill Down why not possible when we add grand total RRS feed

  • Question

  • Hi All,

    When we add grand total column in the analytic grid drill down is not possible why? before add grand total it is possible to

    drill down.Is it possible for drill down when we add grand total.How to do this?Kindly give me the valuable solution.


    Friday, April 17, 2009 10:14 AM


  • How are you attempting to add the grand total?  If you are doing it by modifying the generated MDX then this will not work.  You could look at setting up an aggregate member in your SSAS database or a named set to reference and utilize this in your grid.  The other option that you could look at would be a ProClarity view, but I would stick with the Analytical Charts and Grids as much as possible since there most likely will not be any migration path for ProClarity items except for a complete re-write.
    Dan English's BI Blog
    Please mark posts as answer or helpful when they are.
    • Marked as answer by ravitamil Tuesday, April 21, 2009 10:01 AM
    • Edited by Dan English Tuesday, April 21, 2009 11:36 AM change would to could
    Friday, April 17, 2009 8:56 PM