Handling Cube Data in Tableau is always troublesome.
Hopefully, you can connect to other data source than Cube to get same data.
Anyways, what I know related to this is,
Cube data cannot be the secondary data source.
Looks like your case uses Cube data as primary data, then could you check the "link" field in Excel data source is selected (The chain color changed to orange).
thanks for your response. Unfortunately that didn't work. I got the same error message as described above when clicking on the link field.
Any other suggestions?
From my (almost non-existent) experience with cube data
I've learned that Dimensions in cubes are "just strings".
Since Tableau is reading your Excel [Date] field type as Date,
and your Cube [Date] Dim as String, neither Automatic
nor Custom Blending between Date type and String one would work.
To test this assumption, please make a calculation in your Excel datasource:
// Weekday as String type
STR( DATEPART('weekday', [Date]) )
and use it to Custom Blend with the
Date Period.Day of Week
Dimension Member(s) in your Cube.
Let's try and see what happens.
thanks a lot for your response!! Good point. I tried an additional Excel upload just for the purpose of trying to blend the dates. It did working matching Years and Months!
However, unfortunately we haven't yet been successfull in trying to match it on the date level.
Our cube creates dates like this: 2017.Q3.Jul.06-07-2017
Even when using the exact same wording we failed to blend the dates. We got in touch with Tableau and they will hopefully get back to us with a solution soon.
Thanks for your responses! Will keep you updated.
Next issue: I tried to do some calculations on the "month" basis after i matched excel upload and cube.
When trying to create new measures by multiplying existing ones, an "internal error" shows up.
BUT only for measures whose calculation is defined on the server (=cube?)
then an "internal error" message is displayed.
Does any of you know if there's a way to get around this problem? can these kind of measures somehow be transformed or duplicated into "normal" ones?
Thanks in advance!
You're better ask the developer who made your cube.
Tableau people couldn't help much.