3 Replies Latest reply on Aug 14, 2012 5:41 AM by Peter Thomsen

    Creating Calculated Field - only Measures are available in the 'Fields...' menu

      I have two data sources on my report.  I'm trying to create a Calculated Field based on Dimensions in both datasources.  I can toggle between the two datasources in the 'Fields:' menu, but only data source A contains a list of Dimensions.  Datasource B contains only a list of measures.

       

      Datasource A = MS SQL Server relational DB

      Datasource B = MS SQL Analysis Services Cube

       

      This is my first attempt to pull data from two different datasources.  The calculation I'm trying to create requires dimensions from both data sources.  What am I missing?...

       

      Thanks

      Kyle