TM1 Forum

thanks for the info but I do not quite understand what is meant MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE and OTHER_DIMENSION_VARIABLES (I'm sorry, I'm not completely versed in the processes) IF(CELLISUPDATEABLE(vCubeName, MY_DIMENSION_VARIABLES_CHANGE_OVER_HERE, pTargetElement,OTHER_DIMENSION_VARIABL...

Hello everybody! I have a question about copying data from one element to another element in one cube using TI. I have a source, and a dim period, I need to copy data from one period to any other. It is necessary that when process start, I could choose the period in which to copy the data. how is th...

"Do your values hold when Zero Suppressed, can you Check Feeders and Trace Feeders?" Yes, All these paras executed. When I check FEEDERS, the first thing I look thet the data displayed in consolidation, If the cube does not have consolidation, I check with Zero Suppressed. The problem is n...

Thanks for the link, I have read, and I have a question - In this article write that You can see how much memory is used for calculations feeders ( in cube }StatsByCube ), but it does not say how much it should be used. ( for example - "Look for cubes with particularly large values ... " )...

Hello,
Explain to me, please, why the rule with feeders have a long time to save.
for example - Rule has 5 settlements and 10 feeders, Internal 5 and 5 to other cubes, save about 30 minutes, without feeder calculations quickly save. And that in all cubes.
What could be the reason?
Thanks!

Thanks for the answer, remove feeders for text cells.

Thanks, gtonkin, for the answer. The question is - whether it is necessary feed text values? Perhaps the reason that the rule saves long, that I feed text values? the following example: Dimension has elements - 1. manual correction ( through a Pick List, select Manual or payment ) 2. Calculated elem...

Hello everyone! I have a problem with text data in a cube; in the rules has been active function FEEDSTRINGS, but not correctly inserted into cell text data, I insert the data array, for example, 15 cells, but is inserted only 5 or 10, and in different cells. I disabled the function FEEDSTRINGS in t...

thanks for the help, I'll take into account your advice

I have a measurement - Period ( 2013,2014,2015,2016 ... 2035,2036 ) (only years) I have four affiliated elements 'Profit 1' 'Profit 2' 'Profit 3' 'Profit 4' and a consolidating element - 'Comprehensive Profit' +'Comprehensive Profit' - 'Profit 1' - 'Profit 2' - 'Profit 3' - 'Profit 4' and a simple e...

yes, in other cube where I draw out total values, and then I summarize them

hello everyone, I have a problem at the time of counting income for 10 years. I have a cube, in it there is a calculation of four elements, I need to count the sum of these elements by 10 years. I consider through attributes as a summation ( total for 2011 + total for 2012 + total for 2013 + total f...

Thanks, I'll try to use it

Sorry for the confusion I meant that when I insert an element in the dimension using the TI, I can not insert two identical elements in one dimension. So I can not keep track of the same elements. You wrote earlier: << Use a TI process that evaluates the cells, and for example create a temporary dim...

I had in mind when I make a measurement with a TI

Maybe I have something wrong did, but in a dimension are not created the same elements

excuse me, but I can not understand what you mean, DIMIX function applied to elements measuring, and it is necessary to check the data that we write by hand, that there is no repetition. I wrote the formula: [ ] = S: IF ( DB(....,'Number')@=' ', 'Ok', IF ( DB ( ..... 'Number')@= DB(....., DB(.....,'...

Hello! I have a question about the verification data on repetition I have a cube, it has a column "Number", into it writes the number of products (string element, since the numbers happen different, for example: 10-25.15a). And have a lot of lines. I need to check in the column "Numbe...

hi all,

Tell me please, TM1 Web has the ability to check the data filling?
If the user did not enter data, to prevent him send them for approval.

thank you

hi everyone, I can not find anywhere how to wrap the text in cube, for example: I have a string element - "comments", in formula writing the condition and the result should be one or the other comment, but the comment is written in a single line, which is very inconvenient, because it incr...