TM1 Forum

I found a copy of tm1runti.exe in version 10.1 rar file I had backed up. Thanks.

I am working with a client that will not allow me direct access to the production server and I have TI processes that need to be run to load data to/from a sql database via ODBC connection. I was going to attempt to use the tm1runti.exe and the tm1crypt.exe tools to establish the connection via encr...

Duncan - I did just find out that the dataypes for each column/element is varchar(2000), null).

I haven't done your tests as of yet because I am working on another task at the moment.

Duncan -I will try your recommendation and see what happens. As far as the the characteristics of each field in the SQL table, I reached out to the DBA to find out and am awaiting his response.

Thanks everyone for your replies.

I have attached the variables tab and a view of the SQL table structure, as I don't have direct access to the SQL table. Please let me know if you need any additional infomation. Thanks for your assistance.

I have been working on trying to move data from TM1 to a SQL server database. The process runs successfully, however the only data that shows up in the SQL table are numerics. I cannot get any string data to show up in the SQL table. *********************************************** Here is my Prolog ...

Issue resolved by saving the parameters first and then going back and changing the Sql code to reflect the new parameter fields. Thanks for your assistance. I did not realize there was an order of precedence required.

I have been attempting to set up a parameter in SQL with TI via ODBC connectivity. The process was pulling data yesterday evening and the parameter was working fine. I came in this morning and no data is available. I am using to data fields from the ODBC pull: FY_CD and PD_NO. In the where clause I ...

Thank you for your response. I went back into the rules editor and tried saving the rule again and it save. It was pretty wierd, as I thought the rule was correct to begin with, per your comments. Oh well. It is good to go.

The cube dimensions are as follows for the EAC Cube:

Version; DataSource; Org; Account; Time; Measures

I am trying to use the ATTRS function in a rule with an IF statement to perform a calculation when the Service Accounting Field is not 'Y', however I am getting an error when trying to save the rule. The rule I have created is in an EAC cube and should not calculate Total Sales before Adjustments on...

Thanks to everyone for the feedback. I was able to fix my rounding issue.

...btw, I do respect the amount of time each of you provide to this forum, as this site has been a true asset to me , and probably many other TM1 users, over the years. Thank you for what you have done for the TM1 community through the work you have put in on the site.

All, as I stated in my last post I apologize for not adhering to the rules when posting a question. I made a mistake and felt the comments Tomok made were accurate, but could have been said in a nicer way. Again I am sorry for not following the rules and believe I have provided all that is needed wh...

As I said previously I don't normally use the forum for support, but for this instance I am and apologize for missing some of the rules for assistance. I am providing the rule and feeder for this calculation in the attached file. The Pool 29 Total for FY 14 is derived from the GL cube rule, while th...

As you can see the final total do not match between the allocation and GL Cubes. One value is 828 and the others are 824. I believe there is a rounding error, as well as an error on how the data is being fed, as the monthly values should each be different by Org. As you can see this is not the case....

Can you post a screen shot of the final rule with the recommended change? Thanks

I am having an issue where one of my rules is rounding the value, where the other rule which has a feeder is not. How can I fix the value so they are both rounding the values and the total are the same?

Thanks all. I got it up and running, but it wasn't easy.

Could you provide me with the details on how to make this happen? Thanks in advance.