TM1 Forum

Firstly I would probably call your quarters YYYY - Q# as this way you can do alphanumeric manipulation to go through your dimension rather than relying on the dimnm method which relies on you always ensuring your dimension is built correctly and indexed in the right order. As currerntly your Q2 - 20...

TM1 Guru's, I have been trying to get a series of TI's to be execute only for normal users in my TM1 Model. In the Process Security window everythings greyed out except Read and None. So for the Ti's in question i have set it to Read for the relevant group and this enables them to not only run but a...

Came across this thread on a search for something else completely but thought of a potential compelling reason. We currently have a series of TI's in our live environment that we utilise when we need to set up a new Development or UAT Environment i.e. we take a copy of Live, postfix UAT/Dev onto the...

Could run a AI system which automatically designs and deploys TM1 solutions with that system Kyro!

Was it a good deal, branded / non branded, or were you just maxing out the companies budget!!

Thanks for the posts fellas.

Probably will for go for the extra Cores in order to ensure I have at aleast a minimum performance when connecting up some virtual machines for testing.

No comes the hard bit of forcing the credit card out of the wallet and hiting the buy it now button!!

Hi, Looking at picking up a new Notebook, as mine is now dying a death after 7 years of loyal service! The obvious choice would have been to go for a Dell but after reading Alans comments in a previous post, dont really wish to run through some red lights! Any recent experience anecdotes would be ap...

Hmm Interesting, i thought this would be possibly but having tried it, it appears not especially if you want the Hierarchy sort first as it will always structure it according to the original consolidation set up. ( I also tried clicking on the sorting icons a number of items, which sometimes works!!...

We went to 9.5.2 a few months ago and had the same issues. We are utilising a similar technique to lotsaram but instead we have one sheet which has the processing message which is visible and every other sheet is invisible until all the calcs and reformatting etc is completed. Once completed we unhi...

Andy, We have had the same issue when we upgraded from 9.0.2 to 9.5.2. Personally I do not see it as a Bug, and to my knowledge is not a server side setting. What we have done in our VBA when doing any DBR's is to wrap the statment in a custom function which will handle any errors. i.e. ErrorTrapN(D...

You might also possibly have an issue with your .blb files which tend to be formatting files for your .rux files. I have seen it in the past when copying .rux files from a backup when a server is down but I forget to remove the .blb files the server can corrupt the rule files as there is a conflict ...

lotsaram, Yes we are on 9.5.2 here. Seems like you may have hit it on the head. As a temporary measure I am putting in an asciidelete straight after the dimensiondestroy rather than have a separate process to remove the .dim file from the data directory seeing as it is removing it from the in memory...

Thanks Alan, Did some more testing to try and isolate the issue further. I wrote a simple Ti that had a series of DimensionDestory(DimName); in it for dimensions which existed in the data directory and were visible in server explorer. These executed fine and were deleted from the data directory. I t...

Alan, QML Code from the epilog of the second TI is attached. This is basically where i dump out the data into a flat file to create a report and tidy all the cubes/views/subsets/dimensions up PCExportFile = SUBST(pExportFile,1, long(pExportFile) - 4) | 'PC.txt'; DetailExportFile = SUBST(pExportFile,...

Ok. heres the process. VBA kicks of TI No 1 passing it relevent params to build up a Temp Dimension using a user defined text file as source. In Epilog of same TI a Temp Cube is built using this dimension and another fixed dimension. VBA Kicks of Ti No 2 by passing it relevant params to executes the...

Alan,

Just tried the save data, to no avail. Still in the Data Directory, done a F5 on TM1 server explorer and its not visible.

Hi,

On a restart all the Temp Dims appear again in server explorer.

Hello TM1 Guru's.. I am having an issue deleting Dimensions in 9.5.2. I have a VBA led process which kicks off 2 Tis. The first one builds up a mapping Dimension from a flat file and a Temporary Cube and the Second Ti populate this temporary cube with data and flat files out certain consolidation po...

Thanks guys.

I have used the TM1RunTI.exe and it works a treat. Rather than show a progress bar after that just showed a Processing Message with the time is has taken thus far in seconds with a max time of 90 seconds.

Its informative yet comforts the user knowing something is still happening

Hi All, I have a Excel based process that kicks of a TI and dependant on the datasource and the user the TI that gets kicked off via VBA could take anything between 2 - 40 seconds. If its longer than 9/10 seconds Excel as always tends to be freeze and looks like it may have crashed, when in fact it ...

Hi Guys, We had a similar issues with having rule fired dimension/elements security. Had to tweak the config setting for "PrivilegeGenerationOptimization" for it to work. Basically setting this to "F" will ensure it treats the relevant security cube as if the sparse consolidation...