I need to show hourly granularity in my IMT instead of daily. Is there any way to do this?
aabdalla (BOB member since 2005-03-09)
I don’t think you can. The metric granularity depends on the metric calendar. These can only be Daily or higher. However, in R2 IMT, if you hover over the “I” it will show you the day and “hour” of the metric refresh (even the minutes!). You can schedule a daily metric to refresh hourly if you need to through the scheduler.
Ang.
angelsd1 
(BOB member since 2005-10-21)
A workaround might be to use a sliced metric, by hour, showing the results as a Stacked Bar
cduey (BOB member since 2002-09-05)
I need to show calculations hourly as well and was disappointed to find that daily was the lowest granularity for calendars. Anybody else wanting hourly calendars should submit an enhancement request to CSNACustomerFeedback@businessobjects.com. If enough of us ask for it they may actually address our needs. Please, thank you…
GerryD (BOB member since 2006-03-27)
The only way I was able to do this was to build the IMT on a Universe query.
In the universe, set the format of your “date” dimension to show date & time, or just time, and then include the “date” dimension in the universe query.
That way, you get your hourly granularity, and real-time data.
Only downfall is that it’s not a metric, so no rules, or goals can be associated with it.
davison 
(BOB member since 2007-02-09)