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

    obiee 11.1.1.7 - aggregate navigation not working using with average

    User784791-Oracle

      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.

       

      Thanks,

      Ajay Kumar