TM1 Forum

Does anyone know a solution for this? I have seen refernces for the TM1 server instance disappear from action buttons on all versions from 9.5 onwards, am currently using 10.1 and it still happens. If you have a Dev/Test/prod environmet it is convenient to have a server selection sheet to determine ...

Did you allow for redundant columns in the text file vs he actual runtime data source? My dummy csv file has 20 columns, the cube I am using to test on which my dynamic view is craeted has 11 dimensions. Did you men that implicitly the view would therefore present 14 columns with the 3 hidden varia...

Thanks very much for your reply, I have now set the three variables in the prolog as you suggested. If leave the data tab compltely blank then, as you may expect, the process completes OK. However if I put anything in the date tab E.g. AsciiOutput('File.nam', 'Hello'); I get the error "Variable...

Hello, I stumbled upon this page whilst looking for something else, however I really like the idea of initializing a procedure with a dummy csv file. As has been stated above this would be especially beneficial where the procedure configures the data source during the prolog tab and therefore may us...

Hi,
Do you know if there is any guidance as to when it is safe to clean up files created in a raw store folder?

Hello, I have a system where several processes are making frequent additions to dimensions which has resulted in a number of timestamped RawStore files being generated. I have read and understood why these files are being created and following advice found on this site I have set the CFG file so tha...

Hello thanks for this, was having a similar problem myself so have changed to a UNC path and will see what happens.

Could anyone point me in the direction of some reference material on rawstore files, or in particular let me know if/when it is safe to delete them?

Thanks

Hello, I think I found this BAT file on here somewhere that might do the trick for you:- @echo off REM **************************************************************************************************** REM * Removes window positions from the TM1P.INI file which can result in TM1 windows being crea...

Just added a call to TM1Refresh as shown below:- Dim s As String s = Application.Run("N_CONNECT", sTM1Server, "UID", "PWD") If s = "" Then Application.Run "TM1Refresh" Debug.Print Application.Run("DimSiz", "TM1Server" & "...

Hello, Regarding the simple code extract below:- Dim s As String s = Application.Run("N_CONNECT", sTM1Server, "UID", "PWD") If s = "" Then Debug.Print Application.Run("DimSiz", "TM1Server" & ":}Clients") Debug.Print Applicatio...

Hello, Is your example correct:- ['2013', 'CompanyB', 'Product1', 'Sales'] = [!Year, 'CompanyA', !Products, !Measures]; ['2013', 'CompanyA', 'Product1', 'Sales'] => [!Year, 'CompanyB', !Products, !Measures]; If we assume that you have years in your time dimension before 2013 then I believe that ['20...

There must be a better way to achieve what you are trying to get at, however you could build up the MDX string in a while loop something like this:-

Hmm,
Just tried that method myself and it works fine both In Excel & TM1 web.

Could you put another formulae on your sheet that refers to the named range to ensure that it resolves correctly?

If you wanted to check the whole string one way might be:- sTestString = '1234a'; nStringPos = 0; While(nStringPos < Long(sTestString) & nStringPos > -1); nStringPos = nStringPos + 1; If(Scan(SubSt(sTestString, nStringPos, 1), '0123456789') = 0); nStringPos = -1; EndIf; End; If(nStringPos > 0); ...

When this happens here we usually find that there is some calculated column/row label that has not worked as expected on the web.
Have you un-hidden any hidden cells so that you can check that they work correctly on the web?

Perhaps it might be worth looking at a training course or getting a few days consultancy to get you up and running.
You are not going to be able to get very far without if you are asking questions like this.

Another approach. I have a short generic process that I call when I want to create a subset via MDX. This process first deletes the subset, if one already exists with that name, then creates the new subset based on the parameters with which my process was called. In the main process, after I call my...

"All" yes that it.

Here you go:- It is actually in the primer if you read down about creating unions. Out of interest why would you want to do this?

When you press OK lots of times does the TM1 ribbon start to dismantle itself?
I have seen this on some users machines but think we have mostly fix packed our way out of it.
You could try disabling the TM1 ribbon in Excel to see if the problem goes away.