Search found 3697 matches

by Alan Kirk
Thu Apr 22, 2021 9:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 12
Views: 189

Re: Cube last data pull

I would expect IBM provide value for getting last access timestamp for a cube via REST API in the future. You, good sir, win the "optimist of the year" award. The need for something like this has been obvious for literally decades, yet it's nowhere in sight. One glimmer of hope is that if it comes ...
by Alan Kirk
Thu Apr 22, 2021 6:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 202105 - What's your security mode poison?
Replies: 3
Views: 74

Monthly Poll 202105 - What's your security mode poison?

Remember when we used to have these so that even the lurkers could have a little interactivity? I just realised that it has been years rather than months since we've had one, so let's see whether there is still an appetite for them. Let's start with an easy one. This far down the track, are people s...
by Alan Kirk
Wed Apr 21, 2021 7:17 pm
Forum: Enhancements
Topic: Mode 1 users able to change password in Pafe
Replies: 2
Views: 72

Re: Mode 1 users able to change password in Pafe

Steve Rowe wrote:
Wed Apr 21, 2021 12:17 pm
(....words fail me...)
Anch'io... :roll:
Steve Rowe wrote:
Wed Apr 21, 2021 12:17 pm
https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-619

I'd appreciate any votes that can be cast in my "ideas" direction.
One from me as well.
by Alan Kirk
Tue Apr 20, 2021 12:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

My mileage varies greatly indeed. If I'm having users testing reports in a dev environment (especially complex reports which draw from multiple servers), websheets on TM1 web etc, etc, I want them using EXACTLY the same documents that they are or will be using in production. Faffing around changing...
by Alan Kirk
Mon Apr 19, 2021 7:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

BTW, I don't like the idea of having prod and non-prod services sharing the same name. YMMV. My mileage varies greatly indeed. If I'm having users testing reports in a dev environment (especially complex reports which draw from multiple servers), websheets on TM1 web etc, etc, I want them using EXA...
by Alan Kirk
Sun Apr 18, 2021 10:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

BTW, I don't like the idea of having prod and non-prod services sharing the same name. YMMV. My mileage varies greatly indeed. If I'm having users testing reports in a dev environment (especially complex reports which draw from multiple servers), websheets on TM1 web etc, etc, I want them using EXA...
by Alan Kirk
Sun Apr 18, 2021 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 21
Views: 25342

Re: Fix Pack Releases: PA2 / V11 Series

Version 2.0.9.7 is now out. PAL 2.0.9.7 (16 Apr 2021) Release Page . Key Fixes The fix list consists of a mere 7 items which would be great if there were only 7 bugs, but I think we know that to be unlikely. Almost half of them relate to hierarchy issues: Planning Analytics Workspace: rule values ot...
by Alan Kirk
Fri Apr 16, 2021 8:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1s.cfg my own parameters
Replies: 13
Views: 283

Re: Tm1s.cfg my own parameters

Is there any issues with adding parameters in tm1s.cfg which don't exist? E.g. we need parameter to determine if current model is production or non-production (lets call it ProductionServer=0) The idea is: at model startup chore executes, process reads tm1s.cfg and puts this parameter into cube "Sy...
by Alan Kirk
Mon Apr 12, 2021 1:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ASCIIOUTPUT does not create output file
Replies: 18
Views: 1344

Re: ASCIIOUTPUT does not create output file

Here's what I tested. I select a view from cube A (consists of 17 dims) from the Data Source tab. At the Variables, I set all to Others At the Prolog, I use code asciioutput('\\analyst-app\libraries\Lib\TM1\Cost\aaa.txt','zzzTEsting'); MetaData, i use code asciioutput('\\analyst-app\libraries\Lib\T...
by Alan Kirk
Sat Apr 10, 2021 10:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

What about Belgium with 3 official languages (Dutch, French, German), even not including English ? 😉 Pah, only three? Switzerland has four official languages; German, French, Italian and Romansch. They have an easy way of dealing with it though: The entire population (aside from about 20 people in ...
by Alan Kirk
Sat Apr 10, 2021 3:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

Wim Gielis wrote:
Fri Apr 09, 2021 9:39 pm
If a TM1 model needs to be made multi-language, it can be done with a Caption:
Aaaah, I see! :D

That's kind of an "edge case" for most users (Swiss and Canadians being the most likely exceptions), but still very useful to know.
by Alan Kirk
Fri Apr 09, 2021 8:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

In fact, I know what is the reason but I thought: hmmm, maybe my Dimix() test isn't so fool-proof. What we observe is valid and correctly working functionality that can be used in a TM1 model, which leads to the actual behavior. You know that you haven't actually said "what the reason is" there? :?
by Alan Kirk
Fri Apr 09, 2021 8:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Does the dimension already exist ?
Replies: 10
Views: 278

Re: Does the dimension already exist ?

Who can explain the below result ? The text file is the one generated by the TI process. I can't access TM1 at the moment, but my best guess would be either: (a) A new dimension that has been registered in memory, but the system hasn't updated the control dimension yet (or it has updated a copy but...
by Alan Kirk
Tue Mar 16, 2021 10:44 pm
Forum: Useful code, tips and tricks
Topic: Checkboxes for "flag" measures in TM1
Replies: 8
Views: 705

Re: Checkboxes for "flag" measures in TM1

Elessar wrote:
Tue Mar 16, 2021 6:44 pm
There is an RFE for adding a checkbox format in PAW. Please vote: https://ibm-data-and-ai.ideas.aha.io/ideas/PAOC-I-517
I've done my civic duty, bringing it up to 7 votes.
by Alan Kirk
Tue Mar 16, 2021 10:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Fix Pack Releases: PA2 / V11 Series
Replies: 21
Views: 25342

Re: Fix Pack Releases: PA2 / V11 Series

It looks like I haven't been receiving some of the release updates. Maybe IBM just doesn't like me, though I can't imagine why that might be. In any case I got the one for the newly released 2.0.6, and have updated the master post with all of the missing releases. PAL 2.0.9.6 (16 Mar 2021) Release P...
by Alan Kirk
Sun Mar 14, 2021 10:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 614

Re: TM1Tools is there one for PAX

It's almost as if IBM want everyone on cloud, so deliberately make it too damn difficult to get PAW working in it's local form, isn't it? The! Cloud!, where they would then have you over a barrel with pricing because of the inertia that would be involved in trying to move your data from their platf...
by Alan Kirk
Sun Mar 14, 2021 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1Tools is there one for PAX
Replies: 7
Views: 614

Re: TM1Tools is there one for PAX

Been using this excel add-in for ages, the one made by Alan, Steve & Martin - namely the hierarchy documenter and formula trace. The forum search gave me a 0 result, maybe noone uses it anymore :?: or maybe I spelt it wrong. Just wondering if a PAX/PAFE version was ever put together. Storm.jpg I th...
by Alan Kirk
Mon Mar 08, 2021 6:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )
Replies: 19
Views: 1304

Re: Upgrading from TM1 10.2.2 to Planning Analtyics Local ( is PAW required? )

The concept of PAW delivering the shared objects for Pafe is showing benefits at some of our customers. The updates to the set editor and cube viewer are made to the PAW server, so with a single central update it is possible to get new / revised functionality to the client installs. Where there is ...
by Alan Kirk
Mon Mar 08, 2021 9:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Subsets turning static
Replies: 5
Views: 521

Re: Dynamic Subsets turning static

In what environment? If you're talking about the subset editor in classic Perspectives you would need to manually open the Expression Window from the View menu to see the MDX; it doesn't open automatically when you open the subset in Subset Editor. Hy Alan, nope I use the Subset-Editor in TM1-Archi...
by Alan Kirk
Fri Mar 05, 2021 11:47 pm
Forum: General
Topic: About Forum Ranks And Voting
Replies: 31
Views: 55004

Re: About Forum Ranks And Voting

It's that time of the month again, so let's take a look at the poll results

New MVPs
We've had the largest influx for a while now. Congratulations (and thanks for their work to date) to: We'll leave the washroom keys under your mats.