Search found 16 matches

by konstantin-spb
Mon May 13, 2024 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Domain-Administrator for TM1?
Replies: 2
Views: 1135

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...
by konstantin-spb
Sun May 12, 2024 11:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Ultimate Long TM1 quiz
Replies: 82
Views: 14491

Re: Ultimate Long TM1 quiz

Just remove SKIPCHECK :)
by konstantin-spb
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: 2806

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...
by konstantin-spb
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: 1165

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.
by konstantin-spb
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: 1665

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/
by konstantin-spb
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: 1283

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.
by konstantin-spb
Mon Jun 27, 2022 1:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2250

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...
by konstantin-spb
Mon Jun 27, 2022 1:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2250

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...
by konstantin-spb
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: 1774

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...
by konstantin-spb
Wed Jun 22, 2022 9:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modify default TM1web layout
Replies: 8
Views: 2250

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...
by konstantin-spb
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: 659

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“
by konstantin-spb
Tue Jun 21, 2022 8:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 RULE not consolidating
Replies: 4
Views: 1052

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...
by konstantin-spb
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: 9538

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...
by konstantin-spb
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: 4700

Re: PA and TM1RUNTI separately from installation

Lucas, thanks!
Works fine on PA 2.0.8
by konstantin-spb
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: 5329

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...