Search found 320 matches

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

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

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

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

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

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

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

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

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

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

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

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...
by Andy Key
Sat Jul 16, 2016 9:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 12220

Re: TM1 10.2.2 FP6

Creating a view extract using ViewConstruct was already possible before FP6. Indeed it was, and that was what I was describing. If you still need to go this way after FP6, than this new feature does not bring much new in my opinion. [...] but the nice thing of the Skip Consolidations feature is tha...
by Andy Key
Fri Jul 15, 2016 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6
Replies: 57
Views: 12220

Re: TM1 10.2.2 FP6

Regarding the MTQ usage I'm wondering how much benefit this bring if you have to include consolidated values in the view extract... If you set the view up so that you don't have any consolidations in the view definition to start with (why have them there if you are only going to skip them anyway?) ...
by Andy Key
Tue Apr 19, 2016 4:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cfg parameter - RulesOverwriteCellsOnLoad
Replies: 8
Views: 1231

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

That looks to be a similar issue, but we found it in 10.2.2 FP4 rather than 10.1 as that link shows, and the setting of PersistentFeeders didn't make any difference for us. I don't have the precise APAR number to hand, so it is possible that it is just a mis-identification on that ticket. If it is c...
by Andy Key
Thu Apr 14, 2016 3:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 cfg parameter - RulesOverwriteCellsOnLoad
Replies: 8
Views: 1231

Re: TM1 cfg parameter - RulesOverwriteCellsOnLoad

Be aware that there is an open issue with IBM where RulesOverwriteCellsOnLoad=F can cause feeders to not fire properly.

You may find that your faster startup and smaller memory footprint is because your model is not completely calculated.
by Andy Key
Wed Apr 06, 2016 3:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ViewExtractSkipRuleValuesSet
Replies: 21
Views: 2248

Re: ViewExtractSkipRuleValuesSet

How these values will get exported will depend on your setting for RulesOverwriteCellsOnLoad in the config file.
by Andy Key
Thu Jul 02, 2015 3:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Number formatting on charts in Slices / Active Forms
Replies: 4
Views: 1616

Re: Number formatting on charts in Slices / Active Forms

The thing that you are overlooking is: The string passed to the NUMBR function must use. (period) as the decimal separator and , (comma) as the thousand separator. Any other decimal/thousand separators will cause incorrect results. Give this a go instead: StringToNumberEx(String, DecimalSep, Thousan...
by Andy Key
Wed Jun 10, 2015 12:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: New Config Parameter - LicenseMetricTime
Replies: 4
Views: 2048

Re: New Config Parameter - LicenseMetricTime

Such a well documented parameter You always were too impatient. You asked, they've answered. Although I'm not quite sure they've chosen the best of examples. Example: LicenseMetricTime=01:30:55 ...means that the metric log would begin 'tomorrow' at 09:30 Yep, I understand the 01 being 'tomorrow', b...
by Andy Key
Tue Jun 09, 2015 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 TI <--> PS1
Replies: 3
Views: 1338

Re: TM1 TI <--> PS1

Are you specifying the full path, in double quotes if necessary, to the TM1RunTI executable?