3 Replies Latest reply on Jan 21, 2018 3:03 PM by Chris Marfisi

    Tableau warnings on Micrsoft SSAS tabular cubes

    Peter Larsen

      Hi,

       

      We are currently implementing a SSAS tabular cube as the data source for at Tableau report. We are however experiencing that tableau is displaying warnings and showing dimensions in grey which is not expected.

       

      Example:

      A simple data model could be:

      Fact_Sales

      Dim_Date

      Dim_Category

       

      In Fact_Sales i have created the following measure showing the total sum for all "toy cars" sold.

       

      Sum of Amount:= CALCULATE(SUM(Amount);FILTER(Dim_Category;Dim_Category[Name] = "toy cars"))

       

      - Why does Tableau give the following warning on measures when dimensions are used as filters : "WARNING: This measure is incompatible with one or more of the dimensions in the view"?

       

       

      - Why does Tableau grey out all dimensions when a measure is added to the view?