Search found 53 matches

by ykud
Tue Jul 16, 2019 12:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 6033

Re: Planning Analytics using twice the memory of 10.1

I’ll just leave it here for anyone finding this thread later: another reason for memory growth is that PA is preloading all the views and subsets definitions on startup, whereas 10.2.2 didn’t do that. There will be a parameter in tm1s.cfg to disable this behaviour in future releases, but you can che...
by ykud
Tue Jun 04, 2019 3:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Method for handling Rules for Actuals/Forecast periods
Replies: 9
Views: 291

Re: Method for handling Rules for Actuals/Forecast periods

I usually do something simple like:

Code: Select all

[{'Forecast Version1','Forecast Version 2', etc for live versions}] = IF (DB(LookupCube(!Version, !Month, 'is Actual') = 1, ['Actual], CONTINUE);

FEEDERS;
['Actual'] => ['Live Versions'];
by ykud
Wed May 08, 2019 6:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 1932

Re: RunProcess and threads

But I do not agree that the processes of orchestration are not solved. In our production environment there are several solutions for sequential queues, one based on files, the other based on a cube of queues, both work (I note that a solution based on a cube is rather complicated, but it works!) Wh...
by ykud
Mon May 06, 2019 1:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 1932

Re: RunProcess and threads

As I said, process A and B would have their own transaction sets, so would not see the changes made by the other process. The process that finishes last commits its changes last. Thank you very much for confirming this. To get back to Yuri's point about controlling or orchestrating batch processes....
by ykud
Fri Apr 26, 2019 4:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunProcess and threads
Replies: 20
Views: 1932

Re: RunProcess and threads

Can I also jump on with some questions on RunProcess (don't have 2.0.6 to test yet): what's with transaction isolation in RunProcess? A simple test is to start with an empty cube with 1 cell. Process A: 1) CellPutN 1 into that cell 2) RunProcess (B) 3) CellGetN that cell in a loop for a minute (does...
by ykud
Thu Apr 04, 2019 3:50 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load
Replies: 9
Views: 548

Re: TM1 - External URL - PA2.0.4 - Contributor Grid Fails to Load

Does TM1Web work with https, only contributor fails? I find IKeyMan a lot simpler to use than ThirdPartyCert tool, it can show contents of your cacerts and highlight whether there are any issues with imported certificate (for example, it's missing the whole authority chain or is not trusted). http:/...
by ykud
Mon Mar 18, 2019 12:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 12
Views: 1393

Re: TM1 report bursting

- If I schedule the task to run at a certain point in time, so scheduled, and I am logged on: it works fine. Can you see under what user 'excel.exe' process is running in this case? Yours or the one you set up in Scheduled tasks? Interactive Identity setup will launch excel under your account, spec...
by ykud
Sat Mar 16, 2019 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 report bursting
Replies: 12
Views: 1393

Re: TM1 report bursting

This works perfectly if me or anyone else is logged on to the server when the TI process executes the vbscript. However, in the case of NO USER being logged on to the server at that time, it does not work completely. I don't understand why. It seems that the Application.Run "TM1REFRESH" or "TM1RECA...
by ykud
Thu Feb 28, 2019 1:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 11
Views: 516

Re: Manage Rights when a big chunk of elements are deleted

Hi Elessar, Thanks for the reply. It takes about an hour for SecurityRefresh normally. On PA 2.0.4 and 2.0.6, it takes about 1.5 hours. Since it was taking longer, I asked IBM and they gave us an interim fix and that does not complete securityRefresh. It stops before completing with an error as bel...
by ykud
Thu Feb 28, 2019 1:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a way to refresh all Contributor Views of all users globally?
Replies: 8
Views: 977

Re: Is there a way to refresh all Contributor Views of all users globally?

Thanks Ykud. Contributor views are not private views. The subsets change from time to time. They are, each connecting user will create a view with node_id in the name the moment he rearranges anything in the application, try yourself, you'll see them created in the user folder under data directory :)
by ykud
Thu Feb 28, 2019 12:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 11
Views: 516

Re: Manage Rights when a big chunk of elements are deleted

Hi all, In 10.2.2, when ever I delete a chunk of elements from the "Approval hierarchy" dimension and apply manage Rights, it takes 4-5 hours to complete the process in multi threaded configuration. <deployment maxThreads="4"/> Normal manage rights with 4 threads takes about an hour. What happens i...
by ykud
Fri Feb 22, 2019 4:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads
Replies: 8
Views: 1091

Re: MTCubeLoad vs MTFeeders.AtStartup vs MaximumCubeLoadThreads

I have also been sceptical that MaximumCubeLoadThreads has only impact on cubes with conditional feeders, I would have thought any out of order cube processing with cross-cube feeders (DB and ATTRS/n references) could potentially impact data integrity if the Dependent Cube runs to a completion befo...
by ykud
Wed Jan 30, 2019 12:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 6033

Re: Planning Analytics using twice the memory of 10.1

You have done a better job than the IBM Support Desk Well, that's not really a challenge, I've been at it longer than most people in support. Glad it worked, happy to help :) Try the fonts as well, defaults annoy the hell out of me. I'm guessing the css change is only going to be available to on-pr...
by ykud
Thu Jan 24, 2019 9:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 6033

Re: Planning Analytics using twice the memory of 10.1

Hi Paul, Sure, here you go: Changes I've done to flat.css in TM1Web: 1) Removing Helvetica Neue as default font to align numbers and increasing size new: tm1webDataCell{font-size: 10pt; font-family: Helvetica,Arial,sans-serif; old: tm1webDataCell{font-size: 8pt; font-family: Helvetica Neue,Helvetica...
by ykud
Thu Jan 24, 2019 4:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 43
Views: 6033

Re: Planning Analytics using twice the memory of 10.1

d) Text in TM1 Web Cube Viewer is right aligned. This is apparently fixed in 2.0.6 which we are installing at the moment. I fixed text alignment with a CSS change in flat.css as well as changing the number font to be Helvetica instead of Helvetica Neue, can't for the life of me understand why would...
by ykud
Thu Jan 03, 2019 10:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Who has a "huge" TM1/PA installation ?
Replies: 3
Views: 1346

Re: Who has a "huge" TM1/PA installation ?

Hi Bob, I did a couple largish deployments (>1k users), but they are still on 10.2.2 with the goals to migrate this year, so the stuff below is more of my thinking on the topic before we upgrade rather than real experience. disclosure: I work for a consultancy, not on client-side. Re your boxes: a. ...
by ykud
Sun Nov 25, 2018 10:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Setup IntegratedSecuritymode 3
Replies: 4
Views: 1297

Re: Setup IntegratedSecuritymode 3

SPN should be set up for the AD account running the TM1 services, not the tm1 service itself.
This:
example\PlanTest
should be
example\TM1ServiceUser

Cheers
by ykud
Wed Nov 07, 2018 11:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 mode 2 or 3 with SSO
Replies: 9
Views: 2436

Re: Tm1 mode 2 or 3 with SSO

Is it possible to have SSO in Integrated security Mode 2 or 3. I would like to configure. What version? 10.2.2 is possible, for PAX I'd say that TM1Web is a mighty challenge (Architect & Perspectives is dead easy as long as you set up delegation). WLP based TM1Web doesn't seem to be working with SS...
by ykud
Wed Sep 05, 2018 3:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube Data reservation Acquire
Replies: 6
Views: 943

Re: Cube Data reservation Acquire

We avoided this issue by making sure that all 'Actual load' TIs were executed as admin user (ADMINs bypass data reservation). So a user will click 'Update Actuals' button, we'd run a TI that will use runti to connect to the same TM1 server with admin credentials and execute the data load TI.