2 Replies Latest reply on Sep 20, 2016 3:19 AM by Pasi Tyni

    Help with SSAS multidimensional cube dates

    Pasi Tyni

      Hi,

       

      I'm working with SSAS multidimensional cube and tableau desktop 9.3

       

      Customer wants report that has start date and end date filters to filter data. Into the cube there is time dimension with dates. I have managed to create date parameters into the report, but when I for example query data with starting date 1.7.2016 and end date 11.9.2016 ... somehow these values are changed to 7.1.2016 and 9.11.2016 ....

       

      I have also created new calculated measure with mdx .. cdate([time].[date].CurrentMember.MemberValue), and created that measure as a related date filter, but it has same behaviour then the upper start end date filters ...

       

      Is there any solution to get this working ?

       

      Pasi