TM1 Forum

Hi Martin, nothing in the other tabs. The weirdness seems to be that the ProcessBreak seems to have an impact on the execution of prior lines of script. I'm 99% sure that the logic on the indexes for the while loop is correct (since it works with Process Break in place), it's only after I remove the...

Ahh, there are time when I feel a deep pleasure at the power of TI and the debugging of the script. Anyway I'm writing a TI to compare two versions of the same dimension which involves some nesting of while loops and I'm getting some odd behaviour. The TI script in the prolog fileName=CellGetS( 'Ser...

Hi, One other thing to check is that the values for the second account are in Profit Centre class A, it may be that there is nothing to allocate. To help debugging, navigate to the N level of the cube (all elements are level 0) and right click on the cell where you think there should be a result and...

Just to make a couple of more points vaneagle, Your company should invest in some training for you if they expect to get an ROI in the short term, not training people when you buy a new product is pretty short sighted.... Avoid having element names that are oure numerics, this can cause long term pr...

Wasn't there a tool around a while back that many people were using that worked off the log file that TM1Top produces? Can't remember who wrote it or waht it was called... Was from the old forum days.

Lukas, I get an error message like this in version 9.0 when I rebuild a dimension (almost always by TI) and have a cube viewer open that references the dimension. In my situation though once I OK the message and recalculate the view again I get normal behaviour, I know this doesn't help much but it ...

Just an update on this. I couldn't get David's approach to work, not sure if it it's the same problem as before or not. It also raises another problem in that I have to get ASCIIDelete to work, so that I can perform the test on repeated occasions. I can't get this to work either possibly due to a us...

Hi Andre,
9.0 and Vista / Excel 2007 is not a supported environment AFAIK. There a few threads on getting it to work with Excel 2007 which you can search for but I'm not sure about Vista.
HTH

I'll try that David, I already had a loop in the TI that tested for the existence of the file I was copying. What you suggest is a slightly different flavour of this. I’m not sure that it will help though as it’s my suspicion that it is the OS that is busy rather than TI/TM1.
Cheers

Hi hlw, I suggest that you post the MDX code that is generating the error message, it's kinda hard to debug a piece of script if you can't see the script!
Cheers!

Just a simple TI snippet to introduce a delay into a TI. On my hardware mxInternalLoop=1250000 gives a delay of 1 second, so setting mxLoop=30 gives a 30 second delay. I needed to use this when using ExecuteCommand to copy a large file, see this thread. Note that I had to move mxLoop out to 60 to ge...

Thanks Marcus, I'd already added a CubeProcessFeeders command which introduces a 20 second delay to the proceedings and seems to solve the problem. I'm still not clear on what the problem is though ExecuteCommand ( BatchFile | SourceFile | Destn, 1); The 1 flag in the statement is supposed to force ...

Hi Apple, Just two very quick points. 1. You don't need feed strings to get the rules you have written to work, you are not writing a string rule. 2. IMO You should have Training Site as a dimension in Product_Gross_Margin rather than a piece of data, then alot of your problems should go away. That ...

I seem to be getting a strange timing issue with ODBCOpen in TI. Basically what I'm doing is Step1. Deleting a working copy of an Access DB Step2. Copying the live Access DB to the working area Step3. Executing a stored procedure on a SQL DB that references the working copy of the Access DB My code ...

Hi Hugh, This piece of functionality known as "Stargate", it's a little bit of a mystery as to if it it actually brings a performance benefit. It involves calculating and caching data that has not been asked for but is nearby in terms of the orientation of the view. UseStargateForRules and...

Just to update this thread, I found that I needed to add DatasourceASCIIQuoteCharacter=''; to the prolog to avoid having quotes around my script. It's a very nice way of doing things writing the batch file in the TI itself, +1 to apples mysterious lady friend! so I get this XCopy %1 %2 /R /Y in my b...

Hi David, Yeah you guess right I'm doing an incremental update of an Access table into SQL. I need to do this as I can query SQL from 64 bit TM1 but have not been able to get to Access from the same. The Access DB is an operational DB that I can't really interfer with. I actually don't have the prob...

Hi Xinyu, I think that the only way you are going to achieve this is to process Cube A into Cube B using a TI process. Cube A is still really a table of relational data even if it is already in TM1, to turn this into a OLAP data set you'll need to process the data with a Turbo Integrator (TI) proces...

Hi all, I'm getting a time out issue when reading some data from an Access table into SQL Server 2005. The query I am running is this SELECT DISTINCT derivedtbl_1.* FROM OPENROWSET('Microsoft.Jet.OLEDB.4.0', 'D:\Program Files\Applix\Custom\TM1Data\Wayfarer\CurrentMDB\live.mdb'; 'Admin'; '', Trans) A...

Hi apple, Can you post the exact script that you are using to return the excel values? My guess is there is a bug in your VBA or in the TM1 client that is mixing up the dimension index and subset index. When the subset index and dimension index match and the user security allows access you get the c...