Search found 1089 matches
- Thu Nov 09, 2023 1:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 11988
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...
- 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: 10189
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...
- Wed Nov 08, 2023 6:11 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 11988
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...
- Tue Oct 31, 2023 2:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Office 2019 Update breaking Pafe
- Replies: 3
- Views: 6271
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...
- 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: 5133
Re: Advice on training in Planning Analytics between jobs
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
- Fri Oct 06, 2023 3:36 pm
- Forum: Enhancements
- Topic: Slice from Cube Viewer should goto a new book
- Replies: 3
- Views: 11992
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...
Holding thumbs for the Idea to get further consideration...
- Thu Oct 05, 2023 11:38 am
- Forum: Enhancements
- Topic: Slice from Cube Viewer should goto a new book
- Replies: 3
- Views: 11992
Re: Slice from Cube Viewer should goto a new book
For now you could try adding the following to your tm1features.json:
Agree though that it should be a setting like it always used to be - my vote added...
Code: Select all
r75_EnableSliceNewBook: true
- 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: 1581
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...
- 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: 1581
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.
- 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: 1929
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...
- 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: 1929
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...
- Mon Sep 11, 2023 9:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help on MDX
- Replies: 4
- Views: 695
Re: Need help on MDX
Have a look at the reference guide for more on how to use StrToMember per Lotsa's suggestion.
- 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: 778
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 ...
- 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: 437
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.
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.
- Sun Sep 03, 2023 1:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Any tm1web log setting to get user access websheet info
- Replies: 6
- Views: 1090
Re: Any tm1web log setting to get user access websheet info
Here's another reference that may help: Using TM1 Web logging Edit: and another that looks useful Include user names and memory usage in TM1 Web logs The following information is included in logs: Timestamp Application and Active Form name Number of rows that were generated User name Current heap me...
- Fri Sep 01, 2023 4:48 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Any recommendations on available RAM
- Replies: 1
- Views: 506
Re: Any recommendations on available RAM
I'll get the ball rolling... Let's ignore the organic growth in cubes, dimension etc. and how that would scale and factor into your answer. In recent months I think where we get pretty close to the edge sometimes in with chores. At some clients we have seen that the chores execute and memory grows t...
- Tue Aug 22, 2023 12:08 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use Sandbox in process
- Replies: 2
- Views: 532
Re: Use Sandbox in process
Looks like what I have used previously for testing.
I typically run these commands in Prolog (activate) and Epilog (deactivate) and have not seen any issues so far but saying that have not used these for over a year.
I typically run these commands in Prolog (activate) and Epilog (deactivate) and have not seen any issues so far but saying that have not used these for over a year.
- Thu Aug 10, 2023 8:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Hello Forum Members, I am reaching out to seek guidance and assistance regarding a setup we have in our client's environ
- Replies: 2
- Views: 948
Re: Hello Forum Members, I am reaching out to seek guidance and assistance regarding a setup we have in our client's env
Have you looked at your PAX logs to see what it may be doing? Have you changed the Log Level to ALL to see more details? Have you checked for known issues that impact performance like cells with errors, including on hidden sheets, named ranges with errors, pointing to invalid addresses? Have you tri...
- Wed Jul 19, 2023 1:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding a New User in Paw - not appearing
- Replies: 5
- Views: 1563
Re: Adding a New User in Paw - not appearing
Another question - so if we are using CAM, they user will automatically get added when they first log in. So good news here. But what if you need to add/remove Tm1 groups? Sounds like you will still need to use architect, and cannot therefore completely ditch it for PAW? You can use TI to add the u...
- Thu Jul 13, 2023 5:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Syntax for deleting records from table using sql inside of TI job
- Replies: 2
- Views: 706
Re: Syntax for deleting records from table using sql inside of TI job
Once you have done what David suggests, I think you will see an issue with your WHERE clause - looks to ultimately be saying WHERE PERIOD = X AND Y - cannot be both, maybe you meant BETWEEN. Also, a better approach for these kinds of expressions is to use Expand() e.g. sSQL = EXPAND('DELETE FROM &qu...