Search found 651 matches

by gtonkin
Fri Aug 16, 2019 8:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule or Process?
Replies: 5
Views: 119

Re: Rule or Process?

To derive the Band, create a standalone dimension with Bands as C Levels and days as N level. If you only need to know the Band, I.e. 1 through 4 then just use elpar to get the parent and possibly if not zero and dimix is zero then maximum band. If you change the components of your C levels, your ba...
by gtonkin
Thu Aug 01, 2019 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Installation Crashes
Replies: 3
Views: 214

Re: Local Installation Crashes

Have had mixed luck with Perspectives over a network-some perform better than others. In my experience, corporate WANs using MPLS networks (my packet lost at the switch) seem to perform the worst whereas clients who use 3G/4G and VPN to the LAN perform better. This apparently is down to MTU settings...
by gtonkin
Mon Jul 29, 2019 4:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 254

Re: Replace an element with same name and different case

Wim Gielis wrote:
Sun Jul 28, 2019 11:23 pm
Hi George,

Good code !
Just in case the user enters a wrong element (or an element that is TM1-wise not equal to an existing element):
...
Thanks Wim, additional validation added to make it a bit more robust.
by gtonkin
Sat Jul 27, 2019 11:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace an element with same name and different case
Replies: 7
Views: 254

Re: Replace an element with same name and different case

Here's another way: Create a new process and use a subset as a datasource, set to any dimension and subset. Create two string paramaters: pDim pElement In prolog have: IF(Dimix('}Dimensions',pDim)=0); LogOutput('Error','Error: Invalid Dimension: '|pDim); ProcessQuit; ENDIF; IF(Dimix(pDim, pElement)=...
by gtonkin
Tue Jul 23, 2019 7:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 471

Re: Reclaiming disk space after PAW upgrade

The only way I have cleaned up stubborn containers in the past has been a sledge-hammer approach i.e. docker-ci-zap
Unfortunately this removes ALL containers in the WindowsFilters folder but is useful when you have broken your PAW beyond repair.
by gtonkin
Tue Jul 23, 2019 6:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 471

Re: Reclaiming disk space after PAW upgrade

Thanks for the reply Dr Nybble.
Disk Management shows 23 sandboxes/portable base layers - all are 19.87GB capacity and all are roughly 19 GB free (995 free) - Nothing untoward here.
What is not shown is any description for each sandbox, the volume is just blank so cannot glean much more.
by gtonkin
Mon Jul 22, 2019 1:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Paw backup
Replies: 4
Views: 299

Re: Paw backup

When you execute backup.ps1 you should supply the folder to which you want it to back up to.
If not, the script looks to create it in a folder called backup of your PAW folder i.e. one folder back from your scripts e.g. C:\PAW 2.0.39\scripts\backup
by gtonkin
Sun Jul 21, 2019 2:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Reclaiming disk space after PAW upgrade
Replies: 5
Views: 471

Reclaiming disk space after PAW upgrade

Just finished upgrading PAW 2.0.39 to 2.0.43 and it worked although I nearly ran out of disk space again and am very low after the upgrade. Subsequent to the testing of PAW, I did go back to the PAW 2.0.39 scripts folder and run the Clean.ps1 script which also for the first time removed some cruft a...
by gtonkin
Tue Jun 11, 2019 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 879

Re: Slow Login in Architect

Anything suspicious in your tm1admsrv log files? May be worthwhile adding some additional loggers in your tm1s-log.properties to see if there is anything untoward going on e.g. log4j.logger.TM1.Server.Network=DEBUG, STATS log4j.appender.STATS=org.apache.log4j.SharedMemoryAppender log4j.appender.STAT...
by gtonkin
Fri Jun 07, 2019 4:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Slow Login in Architect
Replies: 21
Views: 879

Re: Slow Login in Architect

Is there a difference when you use the server name vs the IP address? Have had numerous issues when the DNS is fritzed - it takes forever to connect the dots.
by gtonkin
Tue Jun 04, 2019 12:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 367

Re: Method for handling Rules for Actuals/Forecast periods

In terms of data reservations vs cell security, I would go with cell security as it would be more flexible to code via rules/TI. We have models where we have Stages and set groups to various stages in the process. Based on the stage, cell security blocks/allows input. For a model I am currently busy...
by gtonkin
Wed May 29, 2019 4:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting all the children of an element
Replies: 6
Views: 639

Re: Getting all the children of an element

Glad you found a solution-was going to go ELCOMP direction but saw after posting that you had multiple levels.
by gtonkin
Tue May 28, 2019 2:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI summary display
Replies: 14
Views: 888

Re: TI summary display

My interpretation of the video was that it was running iterations and based on previous iterations was estimating remaining time - not a real-time estimate.
by gtonkin
Wed May 08, 2019 9:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ending Balance in Period Rollup
Replies: 1
Views: 428

Re: Ending Balance in Period Rollup

You could look at adding an attribute to your period dimension e.g. NonCumulativePeriod and set it to the underlying month that it should read from i.e. Q1 would read from Mar. A rule could then be written to derive from the NonCumulativePeriod when the Period is at a C level.
by gtonkin
Wed May 08, 2019 5:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Application - update
Replies: 1
Views: 155

Re: Tm1 Application - update

But based on your note about data validations, look at TM1 Web Configuration Parameters , specifically the RecalcOnDataValidationChange parameter - may have been updated/lost when upgrading TM1 web Could also be that Sandboxing was previously disabled in your TM1S.CFG Have a look at Disable Sandboxi...
by gtonkin
Wed May 08, 2019 5:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active forms - training
Replies: 2
Views: 231

Re: Active forms - training

I found the Guideline document a while back but unfortunately cannot find the original link to point you too. It has some useful information and is worth the read.
Hope this helps.
by gtonkin
Sun May 05, 2019 2:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Upgrade PAW from 2.0.4 to 2.0.6
Replies: 4
Views: 653

Re: Upgrade PAW from 2.0.4 to 2.0.6

Its hard to say exactly but heres what I would do roughly 1. Run backup script from scripts directory to create zip backup of PAW content stores 2. Backup paw.env file 3. Stop paw services from stop script 3. Run clean script 4. Copy paw.env file back to configuration folder of new install 5. run s...
by gtonkin
Fri Apr 26, 2019 6:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW Docker image Error
Replies: 2
Views: 269

Re: PAW Docker image Error

You mention space on your C: drive but the screenshot looks like you are installing to D: Remember that the extract will take up a lot a space (close to 20Gb I think when I last installed). It then needs to copy the images to Docker which will duplicate and consume more space. Watch your space caref...
by gtonkin
Fri Apr 12, 2019 6:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: calculating WTD, YTD and QTD with rules
Replies: 5
Views: 967

Re: calculating WTD, YTD and QTD with rules

I will 3rd that in David's absence. I had a sales performance model at daily level using all sorts of rules to do the same "rollups". Feeding was an absolute nightmare as a sale on 1 Jan had to effectively feed into the rest of the year to ensure that WTD, MTD, YTD were adequately fed. Short of it i...