TM1 Forum

Hi Guys!
This is a simple problem, but I can't find the solution.

I have a Hierarchical dimension, with consolidate and simple itens.
Some consolidate itens have a calculations (like sum, multiply or divide), and some have not.

The consolidation itens, who haven't calculations, I need to input data (like a simple itens).

How can I input data in consolidate items in a hierarchical dimension, without loss the data inputted in the leaf?


Thanks for any advice.

You can only input data to it's children. You could also try to update it using spreading that will spread to it's children.

Hello Jim,
Thanks for your advice, but my request are exactly that ( input data into consolidate items without calculations).
I tried to put 0 in dimension weight, but isn't work well.

Maybe exist some configuration in tm1s.cfg, or something like that, but I not found yet.

tianoklein wrote:Hello Jim,
Thanks for your advice, but my request are exactly that ( input data into consolidate items without calculations).
I tried to put 0 in dimension weight, but isn't work well.

Maybe exist some configuration in tm1s.cfg, or something like that, but I not found yet.

You can request anything you want but at the end of the day you can't change the way TM1 is designed to work. You cannot enter data into a consolidated node in TM1. That is the bottom line. Doesn't matter what weight you give the children of that node or any setting you may set in the server. You can use the data spreading functionality that exists in TM1 to input data into a consolidated node and have the tool spread it to the underlying nodes. If you want to know the different spreading options I suggest you read the User Manual. There are too many to mention here.

You can't change the fact that data in TM1 is always stored on leaf elements, never on consolidated elements. However, you can build your model and especially with 10.2. TM1Web so that it looks like the data is stored on consolidated elements. Still you have to bear in mind that data input on consolidated level is spread in the background and stored on underlying leaf elements.

So what you could do?
1. Change the weight factor of "real" leaf elements to 0
2. Create additional dummy leaf elements in each consolidation to represent the consolidation. Set weight factor to 1 for these elements.
3. In TM1Web you can input data without any extra data spread commands on consolidated level and data will be spread automatically to underlying leaf elements. Now the element weighting comes in the picture. Due to 0 factor of "real" elements data will be spread to newly created dummy element only.
4. Hide dummy consolidated elements (element security/just don't show the elements) to make the illusion of consolidation input perfect.

This might help you with your request but still it would be nice to hear what are the real business reasons behind the request? The proposed solution here works nice in theory but may not be viable in real life.

If you are going to input values at consolidated level, watch out to not spread data over millions of cells at once!
There is a great potential risk, not in the dimension that you are talking about, but in the other dimensions.
While it can be easy to just change the values at aggregated levels, it can greatly increase the cube size, number of feeders, and so on.

Another thing to consider is creating a text element in your measures dimension. Then you can enter a number at the consolidated level. So have a starting value, override (text) and final value derived by a rule. The problems however with this are obvious. If they enter say "A" your rule will breakdown. As other have mentioned (and I mentioned) you just can't write data to consolidated elements. I and others have also offered you alternatives. You're just going to have to choose the one that fits best for you.