Search found 1095 matches

by gtonkin
Mon Dec 04, 2023 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RAM usage exploding with CubeUnload and ViewConstruct
Replies: 5
Views: 11734

Re: RAM usage exploding with CubeUnload and ViewConstruct

I have noticed similar behaviour when using MTFeeders=T and MTFeeders.AtStartup=T

Are you using these in your TM1s.cfg?
by gtonkin
Wed Nov 29, 2023 6:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 9335

Re: Prerequisites and Challenges: PAW installation

Unfortunately going Linux may not mean you are in the clear wrt antivirus. One of my clients had Defender running creating all sorts of havoc requiring dispensations to exclude to container folders and related programs. May be worthwhile checking what the stack would look like and if you are likely ...
by gtonkin
Sun Nov 19, 2023 7:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW reports error
Replies: 2
Views: 9779

Re: PAW reports error

Looks like something failing in the underlying MDX based on that error.
You may want to try open the board specification (Ctrl + / + q) then copy and paste into notepad and do a search to see where Label may be used.
by gtonkin
Fri Nov 17, 2023 6:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API Dimension Clone
Replies: 16
Views: 18666

Re: REST API Dimension Clone

This series may help you get familiar with some of the commands and then those concepts could be translated to Powershell.

YKud’s article may be very helpful too…
by gtonkin
Tue Nov 14, 2023 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10249

Re: Tm1 Model - Limit Overall RAM Usage

More fiddling needed - I have not had time to look at running DebugUtility 125 to clear the cache, unload certain cubes etc. before attempting a shutdown. Still not a perfect solution by any stretch but if this model and others were going to simply crash, limiting to one that may need to be killed m...
by gtonkin
Sun Nov 12, 2023 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10249

Re: Tm1 Model - Limit Overall RAM Usage

I had some time to play around a bit more with this parameter. Looks like my initial server crashes were due to too little memory on startup. Bumping this up a bit allowed the server to start as per normal. This parameter appears to be Static - no changes to it whilst running seemed to have any effe...
by gtonkin
Thu Nov 09, 2023 1:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX With Member Dynamic
Replies: 10
Views: 12071

Re: MDX With Member Dynamic

Without knowing what elements you actually have and are trying to derive, I was grasping. Sorry for the confusion. I have had issues with specifying the dim.hierarchy and the following may work in your case: WITH MEMBER [Period].[Period].[VAR] AS STRTOMEMBER("[Period].[" + [System Variable...
by gtonkin
Thu Nov 09, 2023 6:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Model - Limit Overall RAM Usage
Replies: 8
Views: 10249

Re: Tm1 Model - Limit Overall RAM Usage

So there actually seems to be a way though not official/documented. If you add PooledMemoryMaxLimit=<threshold in MB> to your tm1s.cfg, that instance will basically just crash when the threshold is reached. Not ideal normally but may be what you need in your specific case. My TM1server.log shows the...
by gtonkin
Wed Nov 08, 2023 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX With Member Dynamic
Replies: 10
Views: 12071

Re: MDX With Member Dynamic

Do you have members that are called something like [Sep - Oct] in the Period dimension? If yes, then something like this may work: WITH MEMBER [Period].[Period].[Sep - Oct] AS STRTOMEMBER( "[Period].[" + [System Variables].([System Variables Lines].[Previous Actual Period],[Data Type].[Str...
by gtonkin
Tue Oct 31, 2023 2:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Office 2019 Update breaking Pafe
Replies: 3
Views: 6296

Re: Office 2019 Update breaking Pafe

HI Steve, Experienced the same the other day and made these notes once I noticed the problem: Over the weekend my Excel/MS 365 updated (Microsoft® Excel® for Microsoft 365 MSO (Version 2310 Build 16.0.16924.20054) 64-bit ) This morning launching the PAfE addin seems to do the necessary but no ribbon...
by gtonkin
Wed Oct 18, 2023 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Advice on training in Planning Analytics between jobs
Replies: 7
Views: 5168

Re: Advice on training in Planning Analytics between jobs

Paul Segal wrote: Wed Oct 18, 2023 10:37 am However, the trial is somewhat limited ...
The above link had an extra close bracket preventing it from going to the intended page.
However, I think that was the old trial that has been removed.

The new PA on AWS (PA aaS) trial is here
by gtonkin
Fri Oct 06, 2023 3:36 pm
Forum: Enhancements
Topic: Slice from Cube Viewer should goto a new book
Replies: 3
Views: 12363

Re: Slice from Cube Viewer should goto a new book

Damn, sorry - looks like the option is no longer available in PAfE 2.0.90 - possibly added for something internal and removed.
Holding thumbs for the Idea to get further consideration...
by gtonkin
Thu Oct 05, 2023 11:38 am
Forum: Enhancements
Topic: Slice from Cube Viewer should goto a new book
Replies: 3
Views: 12363

Re: Slice from Cube Viewer should goto a new book

For now you could try adding the following to your tm1features.json:

Code: Select all

r75_EnableSliceNewBook: true
Agree though that it should be a setting like it always used to be - my vote added...
by gtonkin
Tue Sep 19, 2023 7:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1-VBA-Addin in Excel wanted!
Replies: 4
Views: 1598

Re: TM1-VBA-Addin in Excel wanted!

In perspectives unless you are using the C API, you just use Application.Run("<macro", <par>,...) This applies to functions like ELCOMP, DBRW, DBRA etc. that you may want to use in macros. If you are using PAfE then you need to follow here: https://ibm.github.io/paxapi/#set-up But based on...
by gtonkin
Mon Sep 18, 2023 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1-VBA-Addin in Excel wanted!
Replies: 4
Views: 1598

Re: TM1-VBA-Addin in Excel wanted!

Please could you explain what you are trying to accomplish, may be easier to advise on the route to follow.
by gtonkin
Thu Sep 14, 2023 10:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service
Replies: 9
Views: 1978

Re: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service

Once started up, your feeders would have fired and memory usage should be based on the data and the feeders related to them. Only when data changes would you expect more memory to be used due to additional areas being fed. "data changes" is ambiguous here as there is a concept of going fro...
by gtonkin
Thu Sep 14, 2023 9:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service
Replies: 9
Views: 1978

Re: Memory usage gradually increased to maximum (64 GB) after restarting the tm1 service

I would say that this is expected behaviour. Even if you have set tm1s.cfg parameters to load sets and views, I would expect that opening views where TM1 needs to recalculate would increase memory usage (assuming no memory to recycle from garbage). If you are running processes, these would consume m...
by gtonkin
Mon Sep 11, 2023 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on MDX
Replies: 4
Views: 711

Re: Need help on MDX

Have a look at the reference guide for more on how to use StrToMember per Lotsa's suggestion.
by gtonkin
Mon Sep 11, 2023 4:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Failed to open temp file for processing tm1rawstore.<DateTime>
Replies: 5
Views: 813

Re: Failed to open temp file for processing tm1rawstore.<DateTime>

The error typically indicates that another process has the file locked. Have you ruled out antivirus or other program locking the file to scan it? ProcessExplorer can assist in telling you what process is locking. Your service stuck in stopping state could be that it is just taking too long to shut ...
by gtonkin
Mon Sep 04, 2023 11:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Global Variable Scope in TI; a Public Service Announcement
Replies: 1
Views: 462

Re: Global Variable Scope in TI; a Public Service Announcement

Been caught out before with a chore reporting failures each day. Running the process was fine though.
Turned out to be exactly this, old value retained from chore to chore each day.
After Initialising in the first process's Prolog, all smooth.