TM1 Forum

Hello All

Here, I want to see one id ABC and it should be with the total of both ABC id (5550+615). If same id exists than it should consolidate their values.

Is there any functionality which could perform cell increament functionality through rules or something similar?

Thanks

Dharav

Have another cube with the same dimensions plus one that contains elements such as your "abc" then a rule states if the "ID" in source cube is equal to the dimension element name then take the value, otherwise 0.

declanr wrote:Have another cube with the same dimensions plus one that contains elements such as your "abc" then a rule states if the "ID" in source cube is equal to the dimension element name then take the value, otherwise 0.

Declanr, ABC would be user input and so we can not put as dimension (as we dont know its element).

Anyother way to achieve it or we can not?

Thanks

Dharav

Depends how many possible inputs they will make, if there aren't many entry cells then you could just do it with a few if statements, if there are lots then thats a bad idea due to performance.

Can you have a scheduled TI to create the elements in a dimension.

What is the cell they are typing ABC into though? You intend to do calculations off something where they ca type whatever they want? Bound to be a lot of typos at the end of the day... are you sure there isn't a possible list of selectable items anywhere.

And of course you could just schedule a chore yo run regularly and do the accumulations, now we have PI available its not normally too detrimental to consider that route.