10 Replies Latest reply on Jul 3, 2013 8:42 PM by Sasi Nagireddy

    Timeseries - YTD and AGO



        I have a report which contains multiple measures which are built in OBIEE 11g RPD, viz.

      - Year Ago

      - PY YTD

      - CY YTD

      - Current Month

      - PY Current Month

      Note: PY: Prior Year and CY: Current year.

      When I am building the report, I have a column from the Time dimension Time.Month, Employee Name and the above measures are included. When I run the report the "Year Ago" measure is incorrect but all the measures are fine. When I include Time.Year, then everything is invalid, when I remove Time.Month, then just the YAGO is correct else all are incorrect. Can anyone help me how to fix this issue.