TM1 Forum

Hello everyone.
I have a problem in Cognos TM1 with a consolidated element, I mean that I have to write the value for the year manually and calculate with formula for months.
For example:

+2010
-Jan2010
-...
-Dec2010
+2011
-Jan2011
-...
-Dec2011
+2012
...

For 2010 - I have to enter the value manually
for months - use the formula X / 2010

I write in the rules - ['2010'] = C: STET; - does not work
I tried another - ['2010'] = C: IF ( ['2010'] = 0, STET, STET); - does not work too
I would have removed the consolidation but it is necessary in other cubes

anyone have any ideas?
I would be very grateful for the help.
(and Sorry for my English, not so good speak english)

thank you

I'd just create an n-level element called "2010 - input" etc.

As far as I know the formula is more important than consolidation, it is unclear why it does not work

Putting a STET in place is like saying "ignore any rule I write after this STET that applies to the same area"; it won't ignore the C-Level consolidation.

Тhis means that the problem can not be solved by rules? Only by adding the element?
Maybe someone else knows some solutions. I'll wait a little bit.

Тhank you.

Wirt wrote:Тhis means that the problem can not be solved by rules? Only by adding the element?
Maybe someone else knows some solutions. I'll wait a little bit.

How long are you prepared to wait? Considering you can NEVER input data into a consolidated element (except for using the data spreading functionality in TM1 which is an entirely different story), regardless of how many different variation of rules you could possibly write, then something might freeze over before you get an answer. The one you were given by declanr is the correct one.

I understood you. Thanks for the quick reply

thank you

Wirt wrote: I would have removed the consolidation but it is necessary in other cubes

Or just create a different period dimension and only use it in this one cube.