Write a calculated value to all elements in a dimension

Post Reply
manu0521
Posts: 24
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

Write a calculated value to all elements in a dimension

Post by manu0521 » Wed Feb 06, 2019 2:19 pm

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: 1865
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe » Wed Feb 06, 2019 3:38 pm

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?

manu0521
Posts: 24
Joined: Wed Nov 26, 2014 8:32 pm
OLAP Product: TM1
Version: 9.5
Excel Version: 2010

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

Post by manu0521 » Wed Feb 06, 2019 4:46 pm

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

Post Reply