TM1 Forum

In the normal LAN/WAN environment, TM1 clients communicate with the remote server using TCP/IP Network protocol.

Hi Paul ,

We will check on the debugging options for this error .

Thanks for the reply ..

Regards,
Anoop

Hi All ,

I am missing any information here ? Please feel free to respond .

It seems TM1 forum also doesnt return any response sometimes


Regards,
Anoop

Hi All , We are facing an issue in macro enabled tm1 excel templates. The problem is tm1 formulas sometimes are not returning any value . For ex: the following macro has DIMIX & DTYPE formula . If Application.Run("DIMIX", dimensionName, Sheets("Cover").Range("Z" &am...

If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure. You are right but it was a joke from Wim Gielis :)) Okkk ... :D I was thinking WTF... Wim Gielis, who is...

If you use the ASCIIOutput function to write to the same file in multiple procedures (tabs) of a TurboIntegrator process, the file will be overwritten each time it is opened for a new procedure.

Hi Pmathur,

Just give a try by enabling the "automatic recalulate " as ON in tm1 web config settings. Not sure , this might help !!

Regards
Anoop

Thanks kpk.

Hi All ,

Is there any way in tm1 by which the dimension structure can be indented and exported ? The whole dimension structure should be indentend according to the dimension structure.


Regards
Anoop

Hi All , The elements are getting added only once as per the TI . Hence I got a feeling that some elements are ignored by TI . Changed the TI so that it will check for parent and delete the element from the parent consolidation . Sorry that I could not provide all the needed information for you guys...

Hi All ,

I was able to load the data with out the parent check . Checking on the file to see what is happening .

Keep you posted soon .

Thanks & Regards
Anoop

Hi Alex, No element with number & string together is getting loaded. Please find the metadata code if(l7@<>''); if(dimix('Test_Func',l7)>0); parent=elpar('Test_Func',l7,1); if(parent@<>l8); DimensionElementComponentDelete('Test_Func', parent,l7); DimensionElementComponentAdd('Test_Func', l8,l7, ...

Hi Matt , This is a dimension hierarchy which i tried to load through a TI and the elements in the hirearchy looks as below table.JPG The last column is not getting loaded into the dimension structure because of the numbers I believe. Regards Anoop (Edited to include the dimension hierarchy structur...

Hi All , I have a TI process which loads elements to a dimension hierarchy from a csv file . Every thing is working fine except some alpha-numeric elements given below . 80.1.6 All Other Service Fees 80.1.5 AESS 80.1.4 Facilities & Security 80.1.3 HR 80.1.2 FRC/Finance Svce Fee 80.1.1 Procuremen...

Clients and Groups have to be created in the 8 BI server (Cognos Connection). Then we need to pull them into TM1 and map them accordingly . The groups which are created in TM1 will not appear if the mode is integratedsecuritymode 5.

you might not need to create 1400 groups. Try to create it based on organization hierarchy or department structure or geography if any of these are available as a dimension in your application. For example Department structure has element named "HR" so there will be a HR group and all HR p...

assign different groups for planners , so that user XYZ has access only to Node C. Now XYZ will not be able to plan for other nodes.

Thanks a lot Mckanzie & Tomok !!!
worked.

I was stuck for a day with this !!


Regards
Anoop

Tomok,

Value is defined as Numeric in variables tab.

v2=STR(Value,10,8);

ASCIIOUTPUT('\\TM1\WS\expenseload2UCS\expenseload2UCS_V1.txt',RC,RL,P0,P2,V9,mon,V2);


Thats all I have in the TI .


Regards,
Anoop

Hi All , I have a TI which exports the data into a text file. The following is the TI script ASCIIOUTPUT('\\TM1\WS\expenseload2UCS\expenseload2UCS_V1.txt',RC,RL,P0,P2,V9,mon,V2) The TI is running successfully but negative numbers are displayed as positive in the file. Is this a limitation in ASCIIOU...