2 Replies Latest reply on Aug 27, 2012 2:56 PM by Russell Christopher

    Loose Underlying Data when applying a filter

    Matthew Davis

      I am connecting to an SSAS cube.  When I attempt to add a filter to the chart I loose the View Data option.

       

      If i filter the chart by Posting Date the view data works correctly but if I attempt to add dimensions such as cost center or account number the view data option is greyyed out.

       

      I also have a number of calculated fields and calculated members, is there a way to code them so there is still the underlying data as apposed to just a sum total.