Search found 1102 matches
- 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: 1654
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: 1654
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: 2050
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: 2050
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: 776
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: 874
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: 516
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: 1149
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: 544
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: 575
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: 962
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: 1666
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: 747
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...
- Sat Jul 08, 2023 4:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Identify All References to Cube
- Replies: 7
- Views: 9884
Re: Identify All References to Cube
Another way is to use Debug utility 123 (all the usual exclusions and waivers apply when using undocumented features) Extracts a file with information about all cubes and dimensions So in short given the following: DebugUtility( 123, A, B, 'Model_Information_0_1.txt', '', '' ); A = 1 suppresses cont...
- Wed May 24, 2023 8:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements in MDX subset build
- Replies: 6
- Views: 1141
Re: Remove duplicate elements in MDX subset build
Lotsa's solution is far more elegant for what you are trying to achieve here.
- Wed May 24, 2023 8:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1SET function - Any trick getting it to work?
- Replies: 5
- Views: 1103
Re: TM1SET function - Any trick getting it to work?
Hi John, iirc, my connection in PAfE used the URI to the PASS server rather than the TM1 server and HTTPPortNumber.
The PASS "pass-through" was the missing link.
The PASS "pass-through" was the missing link.
- Wed May 24, 2023 5:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Remove duplicate elements in MDX subset build
- Replies: 6
- Views: 1141
Re: Remove duplicate elements in MDX subset build
If you are building vi TI there are any number of ways to do this. Simplest is probably to add the elements to a string and scan the string. If you are about to add an element check if it is in your string i.e. previously added. If not add otherwise skip. You could also build an MDX string - add the...
- Fri May 12, 2023 7:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Turning on the performance monitor in PAW
- Replies: 6
- Views: 2199
Re: Turning on the performance monitor in PAW
... So which is wrong...Garbage or Cube..... If there is a process running, you would not see how much memory it is consuming with transactions in case it needs to roll back. And then don't forget that all the dims, sets etc. eat memory too - can still use the properties window in architect from th...
- Fri May 05, 2023 4:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
- Replies: 7
- Views: 2248
Re: 2.0.9.16 Rule save time dramatically less - Feeder calcs?
Noticed this parameter in the TM1S.CFG - may be worthwhile checking/reviewing. Default is True though. SaveFeedersOnRuleAttach When set to False, postpones writing to feeder files until SaveDataAll and CubeDataSave are called, instead of updating the files right after rules are changed and feeders a...
- Thu Apr 06, 2023 9:38 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives Active Form generating duplicate sections
- Replies: 1
- Views: 607
Re: Perspectives Active Form generating duplicate sections
After deleting all rows below the TM1RPTROW, have you tried removing the named range referring to the DATARNG? This should be regenerated on rebuild.