TM1 Forum

Hi, I have a requirement to show the Ending Balance in Quarters and Full Year instead of rollup. For eg; I upload ending balance for Apr-19 so the Q2-19 and FY-19 should show Apr-19 balances, next month when I load May-19 balances Q2-19 and FY-19 should show May-19 data instead of rollup. Please ref...

I have tried this as well before but got an error saying "Dimension element not found in dimension". I had to move the subsetElementInsert to the data tab coz of the error and it works only in the data tab. This is expected. You need to lean what happens on each tab of a TI process. In pa...

Hi wim, thanks for the code, I have tried this as well before but got an error saying "Dimension element not found in dimension". I had to move the subsetElementInsert to the data tab coz of the error and it works only in the data tab. I also created a empty subset in the prolog tab but wh...

Please find the code below; Prolog Tab; vDimName='RevGL'; vSubsetName='Temp'; If (DimensionExists(vDimName)=0); DimensionCreate(vDimName); Endif; If(SubsetExists(vDimName,vSubsetName)=1); SubsetDestroy(vDimName,vSubsetName); Endif; Metadata tab; vGL_Prod=GL; vDimName='RevGL'; IF(DIMIX(vDimName,vGL_P...

Hi David,

I tried that as well but still the same issue. I see that the ti process is only inserting the last record on the text file into the subset.

Hi All, I am trying to update a dimension from txt file and create a subset which will have only the newly added elements of the dimension. I have used the following code; Metadata tab; sDimName='Rev_Cos_GL'; vGL_Prod=GL; IF(DIMIX(sDimName,vGL_Prod)=0); DimensionElementInsert(SDimName,'',vGL_Prod,'n...

Hi, We are facing performance issues while accessing TM1 web applications. We are in PAL 2.0.1 and in distributed setup with Admin server and application server are installed in two different servers. It takes about 30 secs to open an application using both IE and Chrome in a distributed setup but b...

Is it possible to insert multiple values for one parameter? Eg: 'Abc' , 'Def' for the same parameter.