TM1 Forum

tm1 Turbo Integrator invalid string expression

The datasource variables you are expecting to default to String ended up defaulting to Numeric normally this is the time dimension.

Obvious after the fact but can be maddening!

tm1 rules editor shows out of date copy of the rule

You are using the non advanced rules editor which uses .blb files

http://bihints.com/the_fallacy_of_blb_files

You updated the .rux file when the server was offline and because TM1 displays the .blb file ahead of the .rux REGARDLESS OF MODIFICATION STAMPS you will see an older version of the rule.

Solutions

Always use the advanced rules editor

OR

Kill all .blb files which are as useful as herpes

Dont know if this is only a problem in 90 so if anybody could elicidate...

TM1 user does not have admin rights to run TI proc suddenly

The daft apeth is double clicking which defaults to the editor. Tell the stupid mofo to right click and chose execute.

TM1 only user himself can see the updates he made

User has entered batch update mode (poss through TI failure). Tell user to log off and deal with any commit of his batch update as appropriate.

On accidentally typing a key combination suddenly turns to:
Right click in an area of whitespace in TM1 TI editor and you will see all of the Cut and Paste Options followed by "Right to Left Reading" order. You can tick and untick this to get the effect above.

Unless you have just teleported into this universe from an analog where left and right handedness are different this is not a very useful option though I am going to ask IBOGLIX if they can also provide an option to rotate characters in the editor by 180 degrees as I regularly use glasses that reverse the image on the retina and while I am adapting both ways to wearing or not wearing these I am unable to program TI.

Cannot find dimension element containing a dash

Answer

Dash is em dash that you copied in from word or emai program - always type your dashes into TM1 directly.

John Hammond wrote:Cryptic Error

This Process is not complete and cannot be run

Real Error

You had an error that you fixed but you didn't change the code. Type a blank space in the prolog to amend the code without really amending it and this will go away.

Have also seen this when the name of a parameter clashes with the name of a variable. If you get duplicate variables TI will warn you and revert back to the original name but for some reason not related to coder ineptitude it is not able to do the sane for a variable/paramter name clash and gives you this tosh instead.

Prolog line (0): Unable to open data source CubeName

One of the subsets in your view of CubeName has no elements

Cube Viewer Hierarchy expands upwards instead of downwards

You have Filter -> Sort set which is changing the order of the display

TI Process log displays Cell type is consolidated when it isn't.
Cause: Formula used to calculate the variable being used in CellPutN command had a forward slash for divide not a backwards slash.
See this technote.

Thanks Michael.

TM1 Feeders do not get triggered on attribute change.

Think this par for the course only data value changes to the cube where the feeder is located seem to do this. Feeder containing ATTRS statement is treated as conditional though I havent tested whether REEVALUATECONDITIONALFEEDERS works with this though it does not seem to work that well anyway...

On entering the subset editor: Failed to create document

TM1 will crash the next time you try this!

TM1 Service does not crash, but does not display and stops using CPU after acquiring 10-11Mb of memory.

You have no TM1 data directory!

TM1.Server.Network net_SetBufferAt: Attempted to set position past network buffer size. Probable client crash.

The situation:

A file with a good deal of DBRW formulas works fine (not too fast but it worked without issues).
The file had the hard-coded "server:cubename" text in a cell.

On the same physical server, a second TM1 model was created. Same TM1 versions and so on.
Most of the cubes were the same, some of them had less dimensions. We used a copy of the database directory of what we could use, and built the other parts of the application next to it.
The cube used in the spreadsheet did not change at all.
The user at the company had replaced the "server:cubename" text with a comparable VIEW function.
Using the file locally on the PC, worked fine and correctly.
Using the file through Excel in a Citrix environment: file opens and DBRW's show nothing.
Switching to the Server Explorer shows that the model is not responding and that client is crashing.
Therefore, the entry in the message log shown above. Server remains up and running.

We managed to log on again after a few minutes. Then, we deleted the 12 columns for actuals data in the GL. File worked perfectly.
We added January, worked perfectly. We added February - August, worked perfectly. We added September, did not work, same crash.
Now, September was the moment of moving to the new TM1 model, and the VIEW function.

If we take a hard-coded "server:cubename" if works nice on Citrix. With the VIEW function it did not work on Citrix for data as of September onwards.
(The same file with the VIEW function on the OLD model also works.)

Anyone knows why this would crash on Citrix while it works locally?
I'm not an expert on Citrix so probably I cannot answer questions on that specifically.

Wim I would have a look in the Citrix logs or try to minimise what the citrix session is doing (ie not have it attach your current disks and printers).

Problem: Data Directory copy stops working

Cause: You would expect that the current directory for the service process would be the TM1 data directory and this is true for 99% of the time, but some circumstances mean that the service process picks up the subdirectory of an admin.
(Note that cd does not alter the process running TM1

I dont know the why of this if anyone could shed light on this it would be much appreciated.

Solution: Short term reboot the server which restores the default path as TM1 Data Directory.

Long term: specify the full TM1 data directory ( a pain I know)

TM1 Cubes showing all values as 'N/A'

Something to do with

User has entered batch update mode (poss through TI failure). Tell user to log off and deal with any commit of his batch update as appropriate by right clicking on the TM1 Server > Deferred Updates tab

User cannot select all in subset

soln: in subset editor you can choose whether or not to display a toolbar - (WTF you would want to restrict a user's view i dont know!)

client does not have write privilege on this object

When manually trying to add an attribute, even with ADMIN rights, if the dimension contains no elements.

A TI process lets you do this.

Solution: add at least 1 element to the dimension. Or use TI.

Occurs when you use the PersonalWorkspace and run a TI process which fires lots of feeders in the sandbox and blows the sandbox size.

Rule/TI using ATTRS against an alias does not work

test is

ATTRS(DimName,!Element,'SomeAlias') @= 'Alias Value'

The test fails where the element has no Alias because in the cube it is stored as the null string whereas in the subset editor and the attribute editor it APPEARS as the alias value.

Solution

Either use a TI to actually populate the alias with the core element - this will work without complaint despite the duplication or just change the test

!Element @= 'Alias Value'

Tres Confusant!