TM1 Forum

Hello!

This is my first post on this forum, so if my description is to complicated, please give me a feedback and i would describe it more precisely.
I have 2 questions connected with tm1 spreading functionality:
1. Do you know is there any way to change default (propotional) spreading method while you type-in value to consolidation?
Unfortunately element weight could not be the answer as I want to eg. load data to some measures and keep them as weight 1.0 but users want to spread data on different measures with the 3 last month avg sales % to Product Group split per each SKU.

I have tested 2 ways:
-dummy measure with the % split and relative propotional spread - works good but you have to right click and choose it every time
-fill the measure on which i want to spread data with the % split, so when i type values on the consolidations the values are propotionally splited but of course it works only once.... After deleting values on some consolidation levels i loose the prepared % split values..

All after all the desirable effect would be that i could some way use relative proportional spread (in relation to the % split) without right clicking (and using spread options), only by type-in consolidation spread multiple times?

2. Is there any way to show alert/messagebox/dialog box/some other visual sign before user type in value on consolidate? Users use only tm1web without data commition mode.
If there is no such option, do you know whether i can disable the type-in consolidation data entry while having the possibility of spreading using right click-> data spread -> (data spread type)? I was playing with the Consolidation TypeIn Spreading=DENY and Allow Spreading=GRANT but it does not work as i wanted...

Hi

This probably only answers part of your question, but you can control spreading as follows :

In Architect/Perspectives, Right click on the Server and select Capability Assignments. You can Grant or Deny the right to Consolidation TypeIn Spreading by Group.

I am not sure what else you are trying to do. Have you looked at Holds?

Personally I never use spreading.Occasionally, I find users that understand spreading enough to use it safely but for the rest of the population it is usually better for a developer to use rules or a specific TI process to give them the specific spreading operation that they actually need.

Regards

Paul Simon

Lisciu wrote: ↑Wed Aug 05, 2020 10:35 am Hello!

This is my first post on this forum, so if my description is to complicated, please give me a feedback and i would describe it more precisely.
I have 2 questions connected with tm1 spreading functionality:
1. Do you know is there any way to change default (propotional) spreading method while you type-in value to consolidation?

A slight bend on the question: you can write C level formulas to 'fix' all but one of the components (either constants or DBs), then inputting in consolidated cell will adjust only the 'adjustable' component of calculations.
I.e. you can have a consolidation of Revenue = C: Volume * Price and if you fix either of these with a DB, inputting in Revenue will recalculate the other one.

This allows you to predefine the spreading paths by having a set of consolidated elements.
There be dragons down that road, it gets really tricky fast and it's C level rules, so performance can suffer.
I wrote about this here: https://www.ykud.com/blog/cognos/tm1-in ... reak-back/