0 Replies Latest reply on Dec 18, 2011 12:35 PM by Pavan Nagaraj

    Creating calculated fields with SSAS data source

    Pavan Nagaraj

      I am trying to create a calculated field controlled by a parameter, so that I can selectively display data on a particular chart.

      The parameter is simple: it is a string parameter with two listed values - Sales and Margin.

      The calculated field based on this parameter is written with a CASE statement as follows:

       

      CASE parameter

      WHEN 'Sales' THEN [FinalizedSales]

      ELSE [CoreMargin]

      END

       

      I then display the parameter field selection on the sheet and then add the calculated field to a shelf. The moment the calculated field makes it to the shelf, the application crashes.

      Is this an issue because the SSAS cube does the aggregation and the calculated field is attempting to do an aggregation within Tableau?