1 Reply Latest reply on Jan 8, 2015 7:30 AM by Patrick A 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 ??