TM1 Forum

Hello, Just want to confirm that integrating TM1 Web sheets and cube views into MS SharePoint is as simple as stated in this post by Lotsaram. You can do it easier than that. You can just call the core TM1 Web URL as a frame within SharePoint. If you have integrated login then the users go strainght...

Has anyone configured TM1 Web using the TM1 Web ExternalUrl parameter with Cognos security authentication and a load balancer? Follow up on original question related to load balancing. We have an external load balancer appliance F5 Big IP LTM1600 and would like to deploy it to load balance TM1 Web....

Has anyone configured TM1 Web using the TM1 Web ExternalUrl parameter with Cognos security authentication and a load balancer?

Duncan,

Thank for your assistance. The code is working! I used the switch /y after the move command (i.e., move /Y %1 %2) and I am not getting a pop up window prompting. This may be the solution for the window popping up, someone please confirm.

Thanks again,

dfrench77

I am back. I have come to another stumbling block. I am using the ExecuteCommand in a TI statement to execute the move command to move a log file to another folder. Below is the code: MoveCmd= 'move'|' ' | EXPAND('C:\TM1Files\TM1_Logs\file%') | ' '| EXPAND('C:\TM1Files\TM1_Logs\Old_TM1ProcessErrorLo...

Lotsaram, Thanks for the pointer on the concatenation. No, toemail@xxx.com is not my email account. It will be replaced with appropriate email. Regarding the -a for file, you are correct, as usual, it is documented in the utility. Reading is essential, I heard :D. To my defense, I scanned the docume...

Duncan,

Thanks the code work perfectly. I have used the expand function before in an export to ODBC tables.

Can you help with my 2nd question?

How would you attach a file to the email message? Has anyone done this?

Regards,

dfrench77

Lotsaram, I am trying to implement this solution and I am stuck at the 2nd step. 2/ "Scanning the logging directory for process error logs" - Use a TI with WildcardFileSearch to regularly (hourly, daily, etc.) scan the logging directory for files matching "TM1ProcessError*.log" -...

Tomok, Thank for your inquiries. I understand that you are trying to help by getting more information. Below I tried to answer your questions. Who wrote the TI? What is the data source for the TI? I think I lifted the code from a TM1 Forum post. I have used it successfully for other TI scripts. I wa...

Tomok,

Thanks for your insight. Btw - I am an accountant not an information technology guy. I would you suggest that I update the AssumptionPeriods in the while statement loop?

Thanks,

Desi

I have created a rule to dynamically feed my actuals amount to my forecast. I used a rule because I want the actual amount in the forecast to be read only. I have created a turbo integrator script to copy my budget amount to my forecast periods. Forecast periods are any period >= current month. I us...

Hello All, Any idea why the below code is not exporting all data records. It currently only exports the data for one specific user regardless of what user is executing the process. The requirement is that for any user that executes the export to SQL server process will get all the records for every ...

Hello,

Any ideas why I am not getting all the data from the cube when executing this process?

Thanks,

Desi

Hello All, I need help with modifying my code below so that it exports all the UserIDs with data entered to SQL Server table. I have several UserIDs with data entered in the cube, so when I perform an Export data as Text on the cube I see all the data. The requirement is that for any user that execu...

Tomok, Thanks for directing my attention to the CellGetS. I changed the code to include following and it is now working. However, I do want to ensure that this is the best way of doing what I am doing. Any advise or guidance will be greatly appreciated. Regards, Desi # How long are the dimensions? l...

Tomok, The error message is directing you to line 60 of the Prolog tab. Have you bothered to look at the code on line 60 and see why you are passing an empty parameter for the SNO_Model dimension? I did look at the referenced code in the prolog tab. See below. Why is the Cellgets statement returning...

I am confused at the use of both s_SNO_RowID and RowID. Is this deliberate and if so what is the difference?

Duncan,

There is not difference. The s_SNO_RowID is leftover code from following Misty's code that i carried forward. I can replace s_SNO_RowID with RowID.

Thanks,

Desi

Well... the duplicate record could be caused by the running the test and then trying again to insert in TM1

This is correct. I was running the test without truncating or deleting the records from table. My apologies again.

Regards,

Desi

Hello, I read through this post and it has been very helpful to me in developing and modifying my ODBCOUTPUT to a SQL Table. I have leverage both Alan and Misty's code to develop my code. However, I am still having trouble with writing all the cube data to the SQL table. My source cube currently has...

Duncan, My apologies I tried your the code without the '' '' around %Quantity% and I still get the TI "Error executing SQL query". . The statement is working. Here is the code that I used. ODBCOutput('ODS', Expand( 'INSERT INTO [SNO].[dbo].[StartingInventory] ( [Model], [ItemCode], [Locati...