We are using an SAP BW BEx query as dataprovider.
Below you can see two screens of my first workbook with Tableau.
Can anyone explain why and how to get the correct dimension type?
I am using SAP BW content date infoobjects 0CALDAY for the order date (here "Bestelldatum").
If you add order date into the columns normally Tableau Aggregates to the year YYYY.
But not in my case.
2. Measure SALES: In that screen you see the original workbook of the demo. In my case I don't have These context fields "Dimension, Attribute, Measure (SUM)".
Any ideas why?
You're connecting to an OLAP cube datasource.
Tableau behaves differently when working with
OLAP (MDX-based) and Relational (SQL-based) datasources: