Time average

[spudmusic]

Good morning, colleagues!

I faced with a problem of building time average elements in the dimension.
I worked with Cognos Planning for a long time, and it's very simple to make time or weight average through the dimension settings.
Is there a short way to do so in TM1?

I have a few dimensions and i need one element to be time average in aggregation.

Thanks!

Regards,
Alex

[David Usherwood]

Best way is a rule on the lines of:

['Count'] = n:abs(sign( ['Value']));

['Average'] = ['Value'] \ ['Count'];
#(Notice N on the count, to get it to add up, but not on the average, to get it to work at all levels)
(Don't forget the feeders...)
['Value'] => ['Count'],['Average'];

As you are finding, in TM1, your calculations need to be written explicitly - you don't have the built in features of EP. But the rules engine is extremely powerful and doing this type of thing is pretty quick.

You could always do a rules course - Cognos offer them and so do we

David Usherwood
InfoCat

[rodrigo]

There are no functions like BIF or wizards for time in TM1 like Cognos Planning to do that.

Other options can be with consolidations members using equal weights on leaf levels. For example on the month dimension use a new "parent" called Total Year Avg Consolidation element and put months as children. On each month create on properties a weight of 0,083333 (1/12) for each month leaf level.

Regards,

[David Usherwood]

Weighting is a possibility, but I would argue that it's rather inflexible.

[rodrigo]

Yeah I know..

[Martin Ryan]

There are a couple of suggestions here.

Martin

[spudmusic]

Thanks a lot, friends!
You're helping great!

Regards,
Alex