Cubes cannot be secondary data sources, they can only be the primary data source. If this isn't the problem, maybe you can take a screen shot so that we can see what fields the relationship(s) are on?
Thanks for a quick reply.
I checked an indeed the Cube is designated as the primary and the SQL is
secondary and below is the way that I did the relation
This is what the „describe“ function returns for the SQL DEP_DATE
Role: Discrete Dimension
Type: Database column
Remote column: [DATA].[DEP_DATE]
Remote type: Datetime
Contains NULL: No
Domain (20 of 1 872 members)
Whereas the description for the date in the Cube is as follows:
Remote name: [Date].[Date].[Date]
Hierarchy Date (Date)
Level style: Distance from root
Level number: 1
Domain (20 of 2 193 members)
Could this be the reason for it, meaning that I would need to TRIM the zeros from the secondary source date before importing it to Tableau from SQL.
P.S. this is the result that I get currently
Hi! did you per chance find a solution for this?
I have the same scenario and no clue on why is not working, even though both fields are "dates" and have the same format.