Hey Charles -
Another customer is seeing the same issue that you are and support currently has a bug open with dev to investigate. If I see movement on it, I'll let you know - but for now I'd consider this a "known problem".
I've been looking into your issue to try and recreate it and just noticed Charles' response to your mail. So, it does not look like good news there. However, can I please get you to check a few things please?
- What version of SSAS are you on?
- On the Data Source View, what is the datatype of the Date key column?
- On the Date dimension, have you defined the Value property as well? (apart from Key and Name)
It would be good to check if there's any of these settings that is causing the problem.
Hey Siraj -
I actually work at Tableau
I am running a named SSAS 2012 instance. My time dimenstion has a key column named "FullDate" that is a date/time datatype.
I am using Tableau release 7.0.6 on the desktop and have the server version for 7.0.7.
I can browse the cube with Excel and see that things are data typed the way I want and the cube is stable and accessible (I can browse with Tableau too - as long as I keep "fullDate" out of the visualization.
Russell - Would love to hear from your team. Its just that I had started to look at Charles' situation and thought that I got it working. So, I thought I would check. :-) Microsoft is quite well known for bugs too! So, this could be more of an issue with MS than Tableau! ;-)
I have attached an SSAS database backup and the Tableau file that I have used to try and create a Range filter on the Date column. Would it be possible for you to restore the database and attempt to connect to it using the Tableau file?
The key things that I ensured to be set were:
- The database field should be of the type 'date'.
- Review and ensure that the DSV on SSAS solution has picked up the correct data type of the field.
- Set the Value field of the time dimension to use the date column (of the date data type).
- The date attribute should be made visible on its own (outside the hierarchy).
- When connected from Tableau, right click on the Date attribute and ensure that the data type is 'Date'.
- Now drag and drop the field to the filters shelf to get the option.
Can you give it a try and let us know if this is what you were looking for please? Hope it helps.
This is most likely "our problem" - It actually might be helpful if Charles opened a support case as it would allow our support folks to add another customer's name to the already open bug we have on our side -- the more customers associated with an "issue", the more love it gets from dev
has there been any update on this? I have the exact same issue.
Chris - Please open a support case on this issue. I'd like to get your name associated with this bug, too.
After you get a case number, you can email it to me at "first initial of my name" + "full last name" + "at" + "tableausoftware.com". I'll make notes in the case indicating what's going on. There probably won't be an immediate resolution to this case, but you'll be helping to get this fixed by giving us another "me too!" to add to the list of customers pain around this scenario.
In the Test.abf and the workbook sample you have given, remove all the fields from 'Columns' and 'Rows'. Keep only 'Date' in Filters area and 'Unit Cost' to 'Abc123 Text' section.
Change the relative date filter to Last 10 years and see the 'Unit Cost' now. It appears distorted. Instead it should aggregate the unit cost across 10 years and display a single number. Can you please fix this?
From the up discussions, it seems in SSAS we still can't use relative time with Date Dimension. in my project i have Date Dimension (Year/Month/Day) , also make Date attribute be data type is 'Date'. But when i set Filter use Date Range "Last 12 Months" , then on the Columns i drag Month , actually they will show 30 days row data on the sheet.