TM1 Forum

If you are sure that the TI process has not changed, you have not changed TM1 releases then no changes to the cfg then a few other things to look at. 1. Most common cause would be full disc for a server crash, have you checked? 2. Check the rule sheet has not been invalidated, though the server oug...

Hi all, I have a process (runs some calculations on cube data, writes back to cube) which has run successfully in the past. There have been no changes to the actual process (checked vs backups), but running it now causes the server process to stop. Other processes are fine. Any suggestions on what c...

Shouldn't your data source be the sum of the running total and the weekly value? Then you will cover all the intersections that you need to? I failed at getting the record to feed from data source, and instead used rules rather than a TI process for my accumulation. I summarised the list of dimensi...

Hi all, I'm trying to create a running total. My issue is that if a particular week has zero payment, the calculation is ignored, so I get no value in the running total. What I would like is for the calculation to occur only if there is a movement that week or if the previous week's running total is...

You haven't said what you think it is that is causing the Preview to fail, but one example of where a Preview isn't going to work is if you have any TM1 generated values embedded in the SQL statement. When the data is retrieved for the Preview, TM1 doesn't execute the Prolog, so can't perform the s...

Did you execute the SQL in the likes of Toad? Are you getting nothing as that is the result of your query? Jim. The original query works in MS SQL Server, I've included it for reference. For TM1 I removed the comments, but I'm not clear which other parts would need to be changed. --Clearing temp ta...

Tomok wrote: I'd be curious to know where you got that understanding. Data pulled in from an ODBC data source still must go through the confines of the Data tab in order to be made available to the TI process. You can't run an SQL query and assign the results to a variable in the Prolog tab. Someth...

Hi all, My SQL query contains a number of parts that prevent it from previewing in the data source tab. My understanding is that ODBCOpen/Output/Close can be used to directly run SQL queries with minimal TM1 code. Are there any limitations in terms of what SQL commands are possible in TI- e.g. decla...