Write a calculated value to all elements in a dimension

Post Reply
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Write a calculated value to all elements in a dimension

Post by manu0521 »

Hi ,

I wanted to write a calulated value to all values in time dimnension in a TI ,
is there a simpler way to do it or it has to be cellputn for all elements .

I cannot use a rule for performance issue and bringing in as a ti .

Thanks,
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Write a calculated value to all elements in a dimension

Post by Steve Rowe »

Fundamentally yes if using TI, you may want to look at spreading.
Not much to go on here Manu but you should look at your design / requirements IMO.
Writing the same value "to all values in the time dimension" would seem to be an odd thing to need to do, can't this be an attribute of the element in the dimension?
Technical Director
www.infocat.co.uk
manu0521
Posts: 124
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: IBM TM1, Planning Analytics
Version: PA 2.0.5
Excel Version: 2016

Re: Write a calculated value to all elements in a dimension

Post by manu0521 »

Thanks !! Will store it in an Attribute value and then use it . Thanks!!
Post Reply