Search found 1095 matches
- 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: 1111
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: 518
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: 542
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: 953
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: 1593
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: 717
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: 9834
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: 1059
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: 1013
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: 1059
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: 2173
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: 2205
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: 592
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.
- Wed Apr 05, 2023 9:50 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!
- Replies: 2
- Views: 1014
Re: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!
Let's go with the random words option...
- Wed Apr 05, 2023 8:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!
- Replies: 2
- Views: 1014
You cannot append to a file when using AsciiOutput and TextOutput, right? Wrong!
Cross-posting this topic here in case someone needs it. TL:DR Inserting the below function will allow you to append to a file when using AsciiOutput or TextOutput. Works across Prolog, Metadata, Data and Epliog as well as other TI processes: AsciiOutputOpen(<filename>,0|FILE_OPEN_APPEND|FILE_OPEN_SH...
- Sat Apr 01, 2023 4:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ever needed to recover a TM1 user's password when using native security i.e. mode 1?
- Replies: 1
- Views: 794
Ever needed to recover a TM1 user's password when using native security i.e. mode 1?
The below script uses some undocumented functions to do the decryption. These are not recognized in PAW but save and just ignore the error or use Architect. Create a new process with a string parameter called pClient then add the following to the prolog section: IF(pClient@=''); pClient=TM1User; END...
- Wed Mar 29, 2023 1:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW to Powerpoint
- Replies: 4
- Views: 1493
Re: PAW to Powerpoint
Know nothing about functionality etc., only that Intito offers Office Connect which may meet your requirement MarenC.
- Wed Mar 29, 2023 7:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Get children with Multiple Parents
- Replies: 6
- Views: 1495
Re: MDX Get children with Multiple Parents
Glad it helped.
I left the duplicates in as I have ideas of adding more MDX around them to show their parents in the rollup so that it is easy to track down the nonsense. A project for another day...
I left the duplicates in as I have ideas of adding more MDX around them to show their parents in the rollup so that it is easy to track down the nonsense. A project for another day...
- Tue Mar 28, 2023 3:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX Get children with Multiple Parents
- Replies: 6
- Views: 1495
Re: MDX Get children with Multiple Parents
Are you stalking me? Did this just yesterday to meet a requirement: Basically looking at all the elements in a rollup and counting those that appear multiple times. You could likely add your own TM1FilterByLevel where/if necessary: FILTER ( {DESCENDANTS({[<dim>].[<hier>].[<rollup>]})}, COUNT( {INTER...
- Mon Mar 13, 2023 1:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: tm1 how to copy private view from one user to another user?
- Replies: 5
- Views: 1101
Re: tm1 how to copy private view from one user to another user?
Consider that if you are dealing with a private view, those views may have private sets which would need to be copied along with the .vue