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.