3 Replies Latest reply on Jun 21, 2016 6:00 AM by Tom W

    How to create an Year field using calculated field in Tableau with Essbase

    Swetha Moka

      Hello,

       

      I have some knowledge on Tableau but I have never worked before on connecting Tableau to Essbase. I am currently working on creating a continuous line graph for year/quarterly basis. But in the Essbase cube we do not have an Date dimension as such and all we have is Year Dimension with the format FY15, FY16. I want to create an alias for this using a calculated field like if Year is FY16 then 2016. But this doesn't work with Essbase. (I am very new to MDX syntax). All I need is to have a separate Column with the respective years in them and the field to be considered as a date.

      Can someone suggest me the formula to achieve this or any suggestions on the workarounds.

       

      Thanks!!