TM1 Forum

Juts along the lines of Xavier, Do you have multiple TM1 instances, other than the financial model? Do you have action buttons on the websheets? If so have you checked that they all point to the financial model server. I had an issue where one of the action buttons on the websheet, which simply reca...

Hi Wim,

Does this only appear when the source is ODBC?

I tried testing with a csv data source, had 3 rows in the source, made the middle row blank and did dimensionelementinsert and when I ran the process it just inserted the 2 populated rows and ignored the blank one?

Maren

Hi,

I am seeing some WARN messages in the message log, the message reads:

TM1.Dimension Object Name is Blank

It appears this error is against a process which ODBC's to a sql database

Does anyone have any ideas what could trigger this error?

Maren

I updated to use sleep instead, thanks.

Maren

have you tried putting in a wait to allow PS to finish?

That was the problem. I had ExecuteCommand(vCmd, 0), I changed to ExecuteCommand(vCmd, 1) and it worked ok

Thank you very much

Maren

Hi Wim, Yes I defined all the variables using a file I had already created. This file was then deleted and the file is created in the prolog via powershell. If I run the process it creates the file but then aborts saying it can't open the data source. If I immediately run the process again it works ...

Hi Wim,

I know I can create the file manually and it will work. The point is that I want to create the file in the prolog (using powershell) and then use this file created in the prolog in the meta and data tabs. I can do this when the data source is a cube view but not when it is a text file.

Maren

Something about making an ass of u and me!

But how do you deal with where the code was consolidated but is now a simple n? (as tuckster3 indicated).

Hi, with those parents with no children, in my experience there is usually a consistent way the parents are named compared to the children. So if there is some way you can distinguish between the parents and the childs by their name then you can use elcompn and if for the parents that = 0 then delet...

Hi, I have created a process using a cube view as the source and have dynamically built the view on the prolog and then in the same process I have updated the meta and data tabs. So in the prolog I have the following to make this work: DatasourceType = 'VIEW'; DatasourceNameForServer = vCube; Dataso...

Hi I managed to solve this by replacing the double quotes in the file path with single quotes. So now I have: vCmd = 'Powershell get-childItem ' | char(39) | 'C:\EX_MW\SearchFiles\*.csv' | char(39) | '| foreach {[System.IO.File]::AppendAllText(' | char(39) | 'C:\EX_MW\SearchFiles\TestNewFile.csv' | ...

Hi, I am trying to create a powershell script to append some files. I want to run this from a TI process but when I try to run the TI process powershell opens briefly, literally in the blink of an eye and then closes. More to the point the powershell command does not run. When the powershell window ...

Hi, I was wondering what happens if I create a process with datasource as a txt file, and tab delimited. In the prolog I set the DatasourceNameForServer = FilePath | File But then imagine that for whatever reason the source file changes to a comma separated file. I would expect the process to fall o...

Hi, When I posted my comment I thought you had taken undefvals back out again? So why do you have to populate every empty cell with zero? I also thought you said you took out Zeroweightoptimization as per advice from Orlando? All I was saying is if you have some weightings as zero and you want to in...

Hi,

I experienced a bug with this, see here: https://www.tm1forum.com/viewtopic.php?t=13414

If your weightings are zero you will have to add the Zeroweightoptimization back in.

MarenC

Hi and thanks for the reply

enforceUnique argument which will automatically concatenate the principal name to the end of the string

Looking at the IBM guide, it says this argument is LangLocaleCode, nothing about enforceUnique?

Maren

Hi, I noticed some errors in the message log, which read Cell type is consolidated . I checked the elements and they were simple. The error occurred on a line with the following code: CellPutS(vName,'}ElementAttributes_Employee',vEmp, vAttrName); Puzzled, I then decided what would happen if I change...

Many thanks for the explanations.

I will defer using it on the data tab until I know what I am doing!

Maren

Hi, I have read the explanation for RunProcess which, "lets you run TurboIntegrator processes in parallel, each on its own thread that is managed by TM1 Server". What I can't figure out is how to actually use it! So would I put a number of RunProcess statements in one TI master process and...

Hi,

The data will be loaded by TI but can be modified by the end user.

The reason I was reluctant to add in another dimension was because if the user wanted to modify the values this new dimension for bandings would add an extra level of granularity for them to deal with.

Maren