5 Replies Latest reply on Dec 21, 2015 4:33 PM by Christian Berg

    OBIEE 11g: YTD Values are coming wrong at week level

    user6536648

      HI,

       

      I am showing report like below and am passing prompt values current month and current week.

      MTD AND YTD Values are calculated at repository level by using todate time series function.

      I have time dimension with below levels.

      Financial year,Quarter,Month,week and Day.

      At year,quarter,month and day level all values are coming currect.

      only week level YTD Values are coming wrong.

      Pleaase let me know the reason.

         

      FRANCHISECURRENCYFOR THE  PERIODFOR THE  MONTHYEAR TO  DATE
      Dec-152015  /  2016
      NO. OFVALUENO. OFVALUENO. OFVALUE
      UNITSUNITSUNITS
      MMC VEHICLESKD
      FUSO VEHICLESKD
      HEAVY VEHICLESKD
      ZINGER VEHICLESKD
      SEM VEHICLESKD
      JAC / FOTON VEHICLESKD
      USED CARSKD

       

      Regards,

      MIT.