0 Replies Latest reply on Sep 8, 2015 8:20 AM by User784791-Oracle

    obiee - aggregate navigation not working using with average


      I have created aggregated navigation like hourly => daily => monthly => quarterly => yearly


      I have created time dimension also accordingly.


      I have 2 measures => total usage (SUM) and average usage (AVG)


      when I create report using using month and total usage it picks data from monthly table but when I try report using month and average usage it pick data from hourly table.


      I am not sure whether this is OBIEE issue or I am doing some thing wrong.



      Ajay Kumar