TM1 Forum

Hello So your data source of the process is a cube view ? In that case you will execute the code in the Data tab of the process for every cell in the source view. Please elaborate more on your data source, do you skip consolidations / rules values / zeroes / ... ? Can I ask you why you name your cu...

My best bet is that you run into trouble with the ELPAR as indicated above. I guess that you have monthly values for a certain account and instead of getting the parent in the account dimension, you take a YTD parent. Hence the kind of 'cumulative' calculation in there. If that is not it and you ve...

Here is the result

Hello It's important to understand that vAccount is the lowest level of detail. The values of 10 for each lowest level account will come by in the view of the data source. The values of the parent account will not come by in the view. You will use CellGetN to get those values of 150 for example. Th...

Here is some dummy code for an allocation: vAccount = NValue; vAccount_Parent = CellGetN('CubeName', elem01, elem02, elem03, elem04, elem05, ..., ELPAR( vDim, elem6, 1 )); vRatio = vAccount \ vAccount_Parent; vToBeAllocated = CellGetN( ..., ..., ... ); vAllocated = vToBeAllocated * vRatio; CellPutN...

am i using the formula incorrectly? sorry i am not a developer, but an accountant, this is cube view Element1 10 Element2 10 Element3 10 Element4 10 Element5 10 and i use cellgetN(.........ELPAR(dimension, element)) all element 1-5 are under same parents, i thought this will return 50 for each eleme...

this is a part of my calcuation coz i want to calculate the weighting of each element

can TI process give me the result 1/5 for each element?

Element1 10
Element2 10
Element3 10
Element4 10
Element5 10

long story short, i have a situation like this, i wrote a ti process gave me a result like this ...which isnt what i was after Parent Raw Parent_Total Element1 10 10 Element2 10 20 Element3 10 30 Element4 10 40 Element5 10 50 i want to see Parent Raw Parent_Total Element1 10 50 Element2 10 50 Elemen...

sorry i had some typo in my first post. no, my goal wasn't to create a output file but i created to test my script. i had these two lines. vDimGL=CellGetN('Rpt_Dimension',dim01,dim11,dim04,dim02,dim06,dim03,dim07,dim08,dim09,dim10); vDimGLPar=CellGetN('Rpt_Dimension',dim01,dim11,dim04,dim02,dim06,di...

hope someone can help my question, i am trying to calculate the proportion of each element of its parent; to put out the data at lowest level; vDimGL=CellGetN('Rpt_Dimension',dim01,'RawData',dim04,dim02,dim06,dim03,dim07,dim08,dim09,dim10); copy over to a different column vDimGL=CellGetN('Rpt_Dimens...