TM1 Forum

Hi All, I'm Korea language user. so, my English is not good. understand me. Let's get start! My situation. first. when I did n't use "SKIPCHECK" and "FEEDERS" then ['TOT_Origin_Agent', 'Ratio(rest)'] cell was well showen consolidation calculation below First Red box of picture. h...

Hello paulsimon I'm not sure if I understand your word or not. because I'm not in English Culture anyway My Cube has 6 Dimensions COM_Year has 10 elements('2011' ~ '2020') COM_Month has 13 elements('Jan' ~ 'Dec' and 'Full_Year') COM_Day has 32 elements ('01' ~ '31' and 'Full_Month') COM_NoWithTotal ...

Hi Kidyee, If your example is the same as Pauls then feeders are not required since the cube is 100% dense, i.e. every cell is populated with numbers. In this situation skipcheck / feeders don't help as there is no blank space to skip. If it is not like Pauls example then you'll need to share some ...

I just need to FEEDERS. So. I try many time. that result is like this SKIPCHECK; ['IRR','Figures']=['IRR','50'] - 1; ['Figures']=N:STET ; ['Tolerance']=N:['Tolerance','Figures']; ['Year Num']=N: dimix( 'zTD_IRR_Year', !zTD_IRR_Year ) - dimix( 'zTD_IRR_Year', 'Y_All IRR Years' ); # Initial guess at I...

Hi paulsimon Your IRR calc is excellent.! I have used IRR on Rule reference by your posting IRR cube basically too big. so It is necessity to the use of SKIPCHECK & FEEDERS in rule. but.I'm thoroughly confused to the use of SKIPCHECK & FEEDERS Especially like this Statement difficult for me....

Thanks for answer and read my post. But My customer give me a raw data include 3 culumns That raw data came form SAP System . TM1 requires that all elements ( c-level or n-level) are uniquely named. Your source file does not comply with that requirement. Your options are to redefine the source file...

If you're not using the wizard, then it's easy to resolve this issue. Looking at your sample data, your source file contains 3 columns, which in most cases represent a child-parent-grandparent relationship. So in your metadata tab, with the assumption that you have 3 variables named (vElement, vPar...

For a ragged hierarchy, the preference is to use a Parent, Child structure in the input source. E.g.: Parent Child CFO Finance CFO Office Finance Accounting Finance Controlling Finance Treasury Finance Fixed Opex Total Finance Total Thanks for answer and read my post. But My customer give me a raw ...

Try deleting one of the 'Total's from the last row. If that does not work, you should probably modify your TI process code. You can post the TI code here so we may help further. Thanks for answer and read my post. It had been occoured error massage as ever when I was tring (but It worked well) The ...

Hi gays Firstly,It should be guys,right? Please go through below link,It might help: http://www.tm1forum.com/viewtopic.php?p=22755 http://www.tm1forum.com/viewtopic.php?p=8275 Thanks :) Thanks The "guys" was changed to "gays" by your advice. But I don't slove my problem. Your Li...

Hi guys. I want to avoid message that " A circular reference was detected compiling dimension" I want to show that immediately below == This is element in Dimension == (C)Total ├(c)Finance │ ├(n)CFO │ ├(n)CFO Office │ ├(n)Accounting │ ├(n)Controlling │ └(n)Treasury └(n)Fixed Opex and then ...