Search found 3702 matches

by Alan Kirk
Mon Jun 21, 2021 12:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to access Instance within Server after restart
Replies: 2
Views: 14

Re: Unable to access Instance within Server after restart

I access TM1 through User ID and Password. After restarting the service by logging on the server, I am able to access the Instance from client machine with same ID and password, however unable to access the instance within server. I am using the same ID and password at both places. Do you know why ...
by Alan Kirk
Tue Jun 15, 2021 9:57 pm
Forum: General
Topic: Public Dataset suitable for TM1
Replies: 3
Views: 313

Re: Public Dataset suitable for TM1

It may be an idea to take a look at Microsoft's Adventureworks databases for SQL server. They have a shedload of fictional but (mostly) realistically structured values which could serve as a basis for a TM1 model.
by Alan Kirk
Thu Jun 10, 2021 3:39 am
Forum: Enhancements
Topic: Mode 1 users able to change password in Pafe
Replies: 6
Views: 3038

Re: Mode 1 users able to change password in Pafe

From IBM:
Changed status to 'Not under consideration'. Our strategy is to detach authentication and password management from TM1 and Planning Analytics. No enhancements are planned for TM1 security modes 1-5.
For those who are in the cafe, I'll elaborate my thoughts over there.
by Alan Kirk
Tue May 11, 2021 3:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Source file having duplicate records, need to remove them through a TI process
Replies: 5
Views: 1706

Re: Source file having duplicate records, need to remove them through a TI process

I have a source csv file (having few duplicate records), need this file to get processed in TM1 before that I want to remove all duplicates thru a TI process. How Can I achieve this ? My source file having approx 10 columns C1, C2, C3 ...... C10 While checking manually I find few records are duplic...
by Alan Kirk
Sun Apr 25, 2021 12:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Monthly Poll 202105 - What's your security mode poison?
Replies: 6
Views: 1972

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

Also triggered! I could rant but I've spent all afternoon wrestling with a total bizarre feeder / persistant feeder issue that I'm going to go have a beer instead. Deleted the rant I was drifting nto anyway! Have a good w/e everyone, stay safe. That's a pity; I love me a good rant when the rant is ...
by Alan Kirk
Thu Apr 22, 2021 9:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 14
Views: 2285

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: 6
Views: 1972

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: 6
Views: 3038

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

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

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

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

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

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

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

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

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

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

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

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

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