TM1 Forum

ascheevel wrote: ↑Thu Jan 23, 2020 5:12 pm As tomok said, your variable vCANAL_DESPESAS is blank. Where in the Prolog are you setting a value for that variable? I didn't see anything in the code you've posted, are they parameters?

Hello ascheevel,

Thank you for your help.

I am using the variables from my source cube.

So this is the offending line of code?: vANOINI=CellGetS('CMU.PARAMETROS_CARGA','Aplicar Filtros',vCANAL_DESPESAS,vGRUPO_ECONOMICO,'Ano Inicial'); I am assuming that the dimension 02.Canal_Despesas is the second dimension in the CMU.PARAMETROS_CARGA cube, correct? If so, the error message is tellin...

Hi, Suggest you post the whole TI and the whole error message. The error message should have the line number and tab of the error in the log, which lines is this? Cheers, Hi Steve, Thank you for your help Cod TI: vANOINI=CellGetS('CMU.PARAMETROS_CARGA','Aplicar Filtros',vCANAL_DESPESAS,vGRUPO_ECONO...

Hello everyone, I have a process that creates a subset in a dimension from some parameters defined in a source cube. This is my code: vANOINI=CellGetS('CMU.PARAMETROS_CARGA','Aplicar Filtros','Ano Inicial'); vANOFIN=CellGetS('CMU.PARAMETROS_CARGA','Aplicar Filtros','Ano Final'); SubsetDeleteAllEleme...

Hi Steve, The problem is that for MVS the dimension has 3 levels. In the image I left the totalizer hidden. But could you better explain your suggestion anyway? Create an element (numeric type, level 0) called 'No Function'. Add it as a child of 'Functional Total'. That element contains the values ...

I am evaluating each point and have been working on it for two days. Regarding the number of dimensions, it is a development pattern that I use to separate measurement dimensions (01), hierarchical dimensions (02), nonhierarchical dimensions (03), time dimensions (04), version dimensions, and scena...

Thanks but first focus on the replies that others have written for you. Also, the need to use numbers in dimension names escapes me. Why do you do that ? Hi Wim, Thanks for the answer. I am evaluating each point and have been working on it for two days. Regarding the number of dimensions, it is a d...

I think I'm with Steve on this, but if this is the structure you want, have you tried the MAX() function? Assuming not all the Functional and MVS leaves are populated, that should work. If all are populated, then simply get the values of the first component in the Total Functional consolidation. Th...

You should think about your approach too, what you appear to be doing is likely to be very very inefficient. You appear to want to see the same values at all levels on the function and MVS dimensions. Even each of the dimensions only has 10 members than you are holding these data points 100 times m...

Show us your rules at C level. Hi Wim, At level C I have only ['Functional Total', 'Park'] = C: ConsolidatedAvG (2, 'CMU.CALCULO_ESTOQUE_MVS_CALC',! 05.Version,! 05.Cenario,! 04.Month,! 04.Market,! 02 .Channel_Expenses,! 02.Group_companies,! 02.MVS,! 02.Functional_code, 'Park'); The rest of the rul...

Guys, good afternoon! I have a consolidation issue and would like your help. Someone has had to realize this situation. According to print, I have two dimensions (02.Functional_code and 02.MVS). At the lowest level of functional code, the values I need are set. When I go up to Functional Total, by h...

Thank you all for your help.

Processing is around 1 hour. It was the most we could reduce by applying the tips here in the forum. Anyway meets what we want.

Maybe generalising the problem might help? I think you should probably be doing this with rules. Though you state you have already tried this and had an issue with the feeders, maybe your feeder was wrong? My target cube needs park information to do a simple calculation. As Lotsaram implied this do...

Thank you all for the suggestion. Since I don't speak English, I may not be able to explain my problem. I have two cubes in different granularities: Cube A Dimension A Dimension B Cube B Dimension A And I have a third cube Cube C With dimensions: Dimension A Dimension B This third cube has two measu...

First. You are multilying the volume of data by a huge amount. Why are you taking the same piece of data and writing it to 6800 locations? (give or take, depends how many N vs. C elements). First you need to answer this question. Do you need to do this? Could this be a reference rule instead? It do...

First. You are multilying the volume of data by a huge amount. Why are you taking the same piece of data and writing it to 6800 locations? (give or take, depends how many N vs. C elements). First you need to answer this question. Do you need to do this? Could this be a reference rule instead? It do...

3) create a static subset with level 0 elements. That’s at least taking out some of the overhead. Is the value that each element receives, the same ? I created the subset. And the elements get the same values. The process is still slow. Anyway thank you very much for the suggestions. Do you have a ...

Did you check your code for errors/inconsistencies ? - SubsetGetSize asks a dimension and a subset, you only have one. - You are looping from 1 to the number of elements of a subset. Still, you pass this subset index as a dimension index. - Even more, you check whether the returned element (if any)...

Wim Gielis wrote: ↑Tue Nov 12, 2019 4:07 pm 3) create a static subset with level 0 elements. That’s at least taking out some of the overhead.


Is the value that each element receives, the same ?

I created the subset.

And the elements get the same values.

The process is still slow.

Anyway thank you very much for the suggestions.

Two quick things you could try without going into why and what you are doing. 1) Have you turned off logging? R: I deactivated after your suggestion. 2) You could set nContadorMax=DIMSIZ('02.Codigo_Funcional'); Then use the new variable in your while instead of sizing it each time. R: Based on your...