1 Reply Latest reply on Jan 8, 2015 7:30 AM by Patrick Van Der Hyde

    ESSBASE: Compare with the Last year -1

    developer BI

      Hi everyone ;


      I m loadindg data from Hyperion DataBase.


      I have a dimension that contain 5 years . What I want to do is just display the Last Year -1 of Sales .


      I can't use the filter condition " YEAR = YEAR(TODAY()-1)" because when I put the function in the condition Tab , I don't have the possibility to select from DIMENSION.


      How can we filter the dimension " YEAR" to YEAR -1 ??