Search found 329 matches

by Andy Key
Thu Jan 12, 2023 3:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess
Replies: 2
Views: 700

Re: RunProcess

The 'error' in 'The string is the JobID, or an empty string if an error occurs.' is an error with the call to the RunProcess function itself (e.g. non-existent process, mismatched parameters etc), not an error in the process that RunProcess is calling. As soon as the RunProcess function successfully...
by Andy Key
Mon Jul 19, 2021 2:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics 2.0.9.9
Replies: 39
Views: 44265

Re: Planning Analytics 2.0.9.9

ykud wrote: Mon Jul 19, 2021 1:13 am I always get tripped up by the fact that the last line of the section records the number of lines in it, i.e.

Code: Select all

575,84
means that there are 84 lines in Data.
First line not last line. 575 is the start of the Epilog... ;)
by Andy Key
Wed Jul 01, 2020 2:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: check if a parameter value is numeric
Replies: 9
Views: 7967

Re: check if a parameter value is numeric

You still need to change it if you're on 2.0.6 or earlier.

IFERROR only got TM1Web support in 2.0.7.
by Andy Key
Fri Jun 19, 2020 1:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Millennium Bug
Replies: 8
Views: 3721

Re: Millennium Bug

Using Formatting in a View assumes any number being displayed as a date is an Excel Serial Date number. TimVl assumes any number being passed to it is a TM1 Serial Date number. In PA you can set UseExcelSerialDate in the config file to make all of TM1 use Excel Serial Dates, but that's not something...
by Andy Key
Tue May 12, 2020 4:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Linux shell
Replies: 5
Views: 3219

Re: TM1 Linux shell

Both of your examples should be fine.

Check that ftp.sh is in a unix format (see dos2unix) then also check that the user that your TM1 instance is running as has execute permissions to the script (chmod).
by Andy Key
Fri Dec 13, 2019 4:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View not loading in TI Process
Replies: 8
Views: 5200

Re: View not loading in TI Process

MaximumViewSize doesn't affect views used for TI processing except if you use ViewConstruct in which case it does. ...and since 10.2.2 FP6, TM1 has had the ability to perform an implicit ViewConstruct on views used for TI processing. This was originally disabled by default - but this changed in FP7...
by Andy Key
Fri Jun 28, 2019 4:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Operators in TI : SQL IN equivalent
Replies: 7
Views: 3632

Re: Operators in TI : SQL IN equivalent

As string comparison is not case sensitive ('b'='B'), but Scan is (Scan( 'b', 'B') = 0); and as you are matching on a specific term not a combination of terms (i.e. sCode = 'B' should pass but sCode = 'BC' should fail) I would go with: If( Scan( '<' | Upper( sCode) | '>', '<A><B><C>') > 0) Include a...
by Andy Key
Wed Feb 06, 2019 3:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ascii Quote Fun and Games
Replies: 6
Views: 4009

Re: Ascii Quote Fun and Games

If you're only writing the data out to a file so you can read it back in again, won't SetOutputEscapeDoubleQuote cover it? No need to use anything other than the standard double quote, although you can still choose something else if you want, it will double up whatever character you have as the ASCI...
by Andy Key
Tue Jan 30, 2018 2:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation value based on values of children
Replies: 4
Views: 3673

Re: Consolidation value based on values of children

The ConsolidatedXXX functions have been available from as far back as at least 9.5.2.

They weren't added to the documentation until much later, but is anyone surprised by that?
by Andy Key
Fri Aug 04, 2017 5:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 12894

Re: Finding out which Views a Subset belongs to?

This post got me to thinking about private views. Since as far as I know private objects are ignored at startup and only read into memory when the user logs on then if deleting a public subset will the server throw an error if the subset is only referenced in a private view belonging to a user who ...
by Andy Key
Wed Aug 02, 2017 7:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Finding out which Views a Subset belongs to?
Replies: 19
Views: 12894

Re: Finding out which Views a Subset belongs to?

If using a built-in feature of Notepad++ or a simple one line command is too much like hard work, and you are feeling new school and fancy a REST: You can use javascript to loop over a list of cubes and return a list of those that use the dimension you are checking (which is only really necessary if...
by Andy Key
Fri Mar 03, 2017 3:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action Buttons Resizing
Replies: 5
Views: 5236

Re: Action Buttons Resizing

Normally I would have expected the response to this to be along the lines of change the Placement property to 1 on the Active Form (I did notice Chewza said Active Report and not Active Form). So my question is, what am I missing here? Which given the responses above from the experts is clearly som...
by Andy Key
Wed Jan 11, 2017 2:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TSQL limitations in TI
Replies: 8
Views: 6476

Re: TSQL limitations in TI

You haven't said what you think it is that is causing the Preview to fail, but one example of where a Preview isn't going to work is if you have any TM1 generated values embedded in the SQL statement. When the data is retrieved for the Preview, TM1 doesn't execute the Prolog, so can't perform the su...
by Andy Key
Thu Dec 08, 2016 5:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 7129

Re: TM1 Security question

Nope. First guess at the search terms, fifth item on the list..!
by Andy Key
Thu Dec 08, 2016 3:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Security question
Replies: 11
Views: 7129

Re: TM1 Security question

EvgenyT wrote:Interesting info. Haven't been able to locate any documentation on that however.
Try this for size.
by Andy Key
Mon Sep 26, 2016 6:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule not working if I change the order
Replies: 3
Views: 3392

Re: Rule not working if I change the order

...even when they are being applied to different areas of the cube (N: and C: Level)... From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is: [Area] = [Qualifier] [Formula]; The [Area] part of a rule is everything to the left hand side of ...
by Andy Key
Mon Sep 26, 2016 6:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule not working if I change the order
Replies: 3
Views: 3392

Re: Rule not working if I change the order

...even when they are being applied to different areas of the cube (N: and C: Level)... From a TM1 terminology point of view, your rules are not applied to different areas. The definition of a rule is: [Area] = [Qualifier] [Formula]; The [Area] part of a rule is everything to the left hand side of ...
by Andy Key
Tue Sep 20, 2016 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does TM1 10.2.2 support Excel 2016 ?
Replies: 14
Views: 14651

Re: Does TM1 10.2.2 support Excel 2016 ?

Product Compatibility Report looks fine to me.

This being an IBM website, to find the Excel 2016 compatibility you need to look at Note 4 in the Office section rather than look at all the other Excel versions listed under the Excel section.
by Andy Key
Fri Jul 29, 2016 3:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 43370

Re: TM1 10.2.2 FP6

We still can't use temporary views as data source. Are you saying that you have tried them in FP6 and they don't work? Using temporary views as a datasource was fixed in one of the early FP4 IFs, so even if you didn't get that particular IF, it should have been an early enough fix to have been incl...