TM1 Forum

Try this: powershell.exe -Command "(Get-Content -Path 'C:\Temp\Data File with random LF.csv' -Raw) -replace '([^\r])\n', '' | Set-Content -Path 'C:\Temp\Data File without random LF.csv'" And Perl has some problems with LF on Windows: The ultimate guide to Windows and Unix file line ending ...

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

Just remove SKIPCHECK

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

Maybe this will help you

https://stackoverflow.com/questions/489 ... s-7-64-bit

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.

Yes you can do it.
See bedrock for an example or use bedrock right away.

https://code.cubewise.com/open-source/bedrock/

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.

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

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

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

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

Hi,

What mail server are you using?

For MS Exchange try a google search like this “Allow anonymous relay on Exchange servers“

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

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

Lucas, thanks!
Works fine on PA 2.0.8

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