Search found 16 matches
- Mon May 13, 2024 7:36 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Domain-Administrator for TM1?
- Replies: 2
- Views: 1146
Re: Domain-Administrator for TM1?
TM1 service account rigths and privileges: * Local Administrator Group * Act as part of the operating system * Adjust memory quotas for a process * Bypass traverse checking * Log on as a service * Replace a process level token * Have read and write privileges on the Windows Registry item (read level...
- Sun May 12, 2024 11:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Ultimate Long TM1 quiz
- Replies: 85
- Views: 15114
Re: Ultimate Long TM1 quiz
Just remove SKIPCHECK
- Sun May 12, 2024 8:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process to increment value in a cell
- Replies: 2
- Views: 2828
Re: TI Process to increment value in a cell
Nothing is clear, but so interesting… Maybe you are looking for this solution: ValueSrc = CellGetN(CubeSrc, e1, e2 [,...en]); ValueTrgCurrent = CellGetN(CubeTrg, e1, e2 [,...en]); CellPutN(ValueSrc + ValueTrgCurrent, CubeTrg, e1, e2 [,...en]); or ValueSrc = CellGetN(CubeSrc, e1, e2 [,...en]); CellIn...
- Sun May 12, 2024 6:15 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: log file for tm1a.exe
- Replies: 4
- Views: 1272
- Fri Apr 26, 2024 10:02 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Methods for Inputting Data into TM1 Cube
- Replies: 12
- Views: 1278
Re: Methods for Inputting Data into TM1 Cube
Excel + VBA:
1) First button on the sheet = write the range (or the desired cells and rows) to CSV (the directory and file must be accessible from tm1);
2) Second button on the sheet = run “tm1runti.exe” with parameters and call the process to read the CSV and write data to the cube.
1) First button on the sheet = write the range (or the desired cells and rows) to CSV (the directory and file must be accessible from tm1);
2) Second button on the sheet = run “tm1runti.exe” with parameters and call the process to read the CSV and write data to the cube.
- Fri Apr 26, 2024 9:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process with Cube and View Name as Parameter
- Replies: 5
- Views: 1755
Re: TI Process with Cube and View Name as Parameter
Yes you can do it.
See bedrock for an example or use bedrock right away.
https://code.cubewise.com/open-source/bedrock/
See bedrock for an example or use bedrock right away.
https://code.cubewise.com/open-source/bedrock/
- Fri Apr 26, 2024 8:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Action Button - Process Failed - with No Log
- Replies: 6
- Views: 1404
Re: Action Button - Process Failed - with No Log
1) No security rights to run the process;
2) There are many models on one server
and a different model is specified for the button.
Logs are written to a log file of a different model.
2) There are many models on one server
and a different model is specified for the button.
Logs are written to a log file of a different model.
- Mon Jun 27, 2022 1:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modify default TM1web layout
- Replies: 8
- Views: 2252
Re: Modify default TM1web layout
I also have a requirement to add a new Icon which will launch another site. The requirement is to add the Icon on the Top Banner, just after Log Out Not sure which files need to be updated for 2.0.9.4 Thanks Hi, PAL 2.0.9.4 use PASS (Planning Analytics Spreadsheet Services). Unfortunately I don't h...
- Mon Jun 27, 2022 1:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modify default TM1web layout
- Replies: 8
- Views: 2252
Re: Modify default TM1web layout
Hi, PRODUCT_NAME :"IBM® Planning Analytics 2.0.9", ABOUT_STR :"About", HELP_TOOLTIP_STR :"Help", LOG_OUT_STR :"Log Out", On windows installation for PAL 2.0.9 you can find this "magic words" in the file <installation path>\webapps\tm1web\scripts\tm1...
- Thu Jun 23, 2022 9:18 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.0.9.5 - TM1 Web not working
- Replies: 2
- Views: 1783
Re: PA 2.0.9.5 - TM1 Web not working
Hi, https://www.tm1forum.com/viewtopic.php?t=16128 2020-07 (Jul) PAL 2.0.9.2 (27 Jul 2020) TM1sd Version Number 11.8.00100.13 TM1 Web's installer was taken out of the server's "Long Cadence" release and is now on the short cadence release along with the Spreadsheet Services installer. http...
- Wed Jun 22, 2022 9:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Modify default TM1web layout
- Replies: 8
- Views: 2252
Re: Modify default TM1web layout
Hi, PRODUCT_NAME :"IBM® Planning Analytics 2.0.9", ABOUT_STR :"About", HELP_TOOLTIP_STR :"Help", LOG_OUT_STR :"Log Out", On windows installation for PAL 2.0.9 you can find this "magic words" in the file <installation path>\webapps\tm1web\scripts\tm1w...
- Wed Jun 22, 2022 7:29 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW - Configure Event Notifications - Password Risk
- Replies: 1
- Views: 660
Re: PAW - Configure Event Notifications - Password Risk
Hi,
What mail server are you using?
For MS Exchange try a google search like this “Allow anonymous relay on Exchange servers“
What mail server are you using?
For MS Exchange try a google search like this “Allow anonymous relay on Exchange servers“
- Tue Jun 21, 2022 8:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 RULE not consolidating
- Replies: 4
- Views: 1055
Re: TM1 RULE not consolidating
Hi, Try something like this: Source cube ( in your code with a SPACE at the end of the cube name? ): 'MDA Trial Balance ' FEEDERS; ['Opening Balance'] => DB( IF( ATTRS('Calendar', !Calendar, 'IsMonthApril') @= 'Y' & ATTRS('Account - MDA', !Account - MDA, 'Flags') @= 'Y', '', 'Unnamed Cube', !Cal...
- Thu Oct 10, 2019 9:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube Viewer suppress zeroes hiding non-zero cells
- Replies: 12
- Views: 9550
Re: Cube Viewer suppress zeroes hiding non-zero cells
Suppose you have the right feeders... What rules (calculations) do you use for totals? N or C? If you use the calculation of totals (sum or percent) like this ("supress zeroes" will hide them): ['Accounts{PL':'GM' , 'Measures{PL':'1'] = C:['Accounts{PL':'60'] + ['Accounts{PL':'61']; ['Acco...
- Tue Aug 20, 2019 11:47 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA and TM1RUNTI separately from installation
- Replies: 4
- Views: 4704
Re: PA and TM1RUNTI separately from installation
Lucas, thanks!
Works fine on PA 2.0.8
Works fine on PA 2.0.8
- Thu Sep 14, 2017 9:57 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Wrap alias in TM1 Web view
- Replies: 6
- Views: 5336
Re: Wrap alias in TM1 Web view
Find this code in TM1 css file (standaloner.css or contributor.css or whatever you use) .CVHeaderCell { padding-right: 3px; padding-left: 3px; font-size: 8pt; font-family: Tahoma, 'Trebuchet MS', Arial, Verdana, Helvetica, sans-serif; color: #333333; background-color: #DFE3E8; border-right: 1px soli...