Search found 168 matches

by AmbPin
Fri Jan 09, 2015 9:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Button - Using a cell reference for the Tm1 Server
Replies: 9
Views: 4857

Re: Action Button - Using a cell reference for the Tm1 Serve

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 ...
by AmbPin
Wed Jan 07, 2015 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 15095

Re: Dynamic Datasource Path

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...
by AmbPin
Wed Jan 07, 2015 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 15095

Re: Dynamic Datasource Path

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 "NVA...
by AmbPin
Wed Jan 07, 2015 8:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Datasource Path
Replies: 43
Views: 15095

Re: Dynamic Datasource Path

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...
by AmbPin
Fri Jan 02, 2015 4:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: what is tm1rawstore?
Replies: 10
Views: 4753

Re: what is tm1rawstore?

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?
by AmbPin
Fri Jan 02, 2015 9:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Raw Store Files
Replies: 0
Views: 932

Raw Store Files

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...
by AmbPin
Wed Dec 17, 2014 3:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1.Audit.PostProcessor Failed to open audit store ...
Replies: 6
Views: 6032

Re: TM1.Audit.PostProcessor Failed to open audit store ...

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
by AmbPin
Thu Oct 03, 2013 2:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Weird happenings w/ Server Explorer
Replies: 5
Views: 1865

Re: Weird happenings w/ Server Explorer

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...
by AmbPin
Fri Sep 13, 2013 2:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA N_Connect
Replies: 1
Views: 820

Re: VBA N_Connect

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" & ":}Clients") Debug.Print Application.Run("DIMNM", "MyServer:}Clients", 1, "Alias...
by AmbPin
Fri Sep 13, 2013 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: VBA N_Connect
Replies: 1
Views: 820

VBA N_Connect

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 Application.Run("DIMNM", "MyServer:}Clients", 1, "Alias") Debug.Print Application.Ru...
by AmbPin
Tue Aug 27, 2013 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sets in rules
Replies: 4
Views: 1328

Re: Sets in rules

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...
by AmbPin
Thu Aug 15, 2013 3:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Simplyfying a Timeinterval MDX subset?
Replies: 8
Views: 1920

Re: Simplyfying a Timeinterval MDX subset?

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:-

Code: Select all

i = 0;
s= '';
while(i < 60);
   i = i + 1;
   s = s | 'blah blah' | NumberToString(i);
end;
by AmbPin
Tue Jul 16, 2013 11:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form websheet not populating
Replies: 11
Views: 7526

Re: Active form websheet not populating

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?
by AmbPin
Tue Jul 16, 2013 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it text or number (TI Question)
Replies: 6
Views: 1386

Re: Is it text or number (TI Question)

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); # Th...
by AmbPin
Fri Jul 12, 2013 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active form websheet not populating
Replies: 11
Views: 7526

Re: Active form websheet not populating

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?
by AmbPin
Wed Jul 10, 2013 3:17 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Load a Measure Dimension element
Replies: 6
Views: 1983

Re: Load a Measure Dimension element

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.
by AmbPin
Fri Jul 05, 2013 8:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX: retain duplicate elements in a UNION
Replies: 6
Views: 2145

Re: MDX: retain duplicate elements in a UNION

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...
by AmbPin
Thu Jul 04, 2013 1:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX: retain duplicate elements in a UNION
Replies: 6
Views: 2145

Re: MDX: retain duplicate elements in a UNION

Here you go:-

Code: Select all

{
	Union(
		  TopCount( { TM1FILTERBYLEVEL( {TM1SUBSETALL( [MyDim] )}, 0)} , 5)
		, TopCount( { TM1FILTERBYLEVEL( {TM1SUBSETALL( [MyDim] )}, 0)} , 5)
		, All
	)
}	
It is actually in the primer if you read down about creating unions. Out of interest why would you want to do this?
by AmbPin
Wed Jul 03, 2013 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AutoCalc Excel with DBRWs and ActiveForm hangs upon opening
Replies: 6
Views: 2872

Re: AutoCalc Excel with DBRWs and ActiveForm hangs upon open

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.