TM1 Forum

Hi all

Im trying to see if anyone used a cube in the last hour but i cant decipher the time interval dimension i understand latest is the latest Minute but does this mean the stats are gathered every minute?

using this premise could i build a subset to collect the total of the values inside 00m01-00m59? Using the Rollup function inside a TI?

is it possible to get a total from the subset without there being a consolidation in there? I know its possible in excel can i ask what the TI would be?

thanks

Answered this myself,

I created the Subset called "Hour" and in the cellgetn used "Hour" and this made the total from the subset appear.

thanks anyway guys

Darkhorse wrote:Answered this myself,

I created the Subset called "Hour" and in the cellgetn used "Hour" and this made the total from the subset appear.

thanks anyway guys

Hello

That's undocumented (AFAIK) behaviour in TM1. You'd better create your own dimension, including consolidations.

such an interesting feature... does it lags in some situations or work fine?

Works fine and been running it for a chore and every hour.