Search found 32 matches

by AskAndAnswer
Tue May 28, 2019 6:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW is unable to access TM1 databases
Replies: 4
Views: 230

Re: PAW is unable to access TM1 databases

I found messages.log file on the server, the only issue I see is Java security certificate is not trusted. I guess I need to finish SSL install before I can test the server.
by AskAndAnswer
Tue May 28, 2019 6:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW is unable to access TM1 databases
Replies: 4
Views: 230

Re: PAW is unable to access TM1 databases

Where are they located on Linux server?
by AskAndAnswer
Tue May 28, 2019 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW is unable to access TM1 databases
Replies: 4
Views: 230

PAW is unable to access TM1 databases

Hello, Here is an issue. I created a new PAW server to replace an old one. The configuration is the same, and it accesses the same TM1 admin and web server. However, all databases that I still see on old server are not available on the new one. I can successfully login and create a new book, but the...
by AskAndAnswer
Fri May 17, 2019 12:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Single Sign On problem
Replies: 0
Views: 188

Single Sign On problem

I am trying to set up SSO in Planning Analytics 2.0.6 and Cognos 11.0.12, security mode 5. I can use CAM to login, and it works without issues in all applications. The problem is particularly SSO, I am always prompted for user id and password. In Architect if I login once, then log out and login aga...
by AskAndAnswer
Fri May 10, 2019 9:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Instance is crashing because the process cannot access its own log file
Replies: 8
Views: 1373

Re: TM1 Instance is crashing because the process cannot access its own log file

It looks like the new version of TM1 is handling multi-threading differently. The root cause was that the process was in conflict with SaveDataAll process.
by AskAndAnswer
Thu Apr 25, 2019 8:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Instance is crashing because the process cannot access its own log file
Replies: 8
Views: 1373

Re: TM1 Instance is crashing because the process cannot access its own log file

Thank you for your reply. Do you mean Microsoft Process Explorer? It does not exist on the server as of right now. Is there any other way to identify what could lock the file right after it was created by a process?
by AskAndAnswer
Thu Apr 25, 2019 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Instance is crashing because the process cannot access its own log file
Replies: 8
Views: 1373

TM1 Instance is crashing because the process cannot access its own log file

The issue started after an upgrade to Planning Analytics 2.0.35. One of the instances is constantly crashing with the same error message: 153712 [] FATAL 2019-04-25 10:06:48.917 TM1.System.File TM1 Server Abort: sf_Write() - Write error on file "d:\tm1\dbname\logs\TM1ProcessError_20190425100638_7625...
by AskAndAnswer
Wed Mar 06, 2019 4:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0
Replies: 4
Views: 448

Re: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0

It is another TM1 database that's running on the same server. The processes allocate data that's loaded from files that are also on the same server.
by AskAndAnswer
Tue Mar 05, 2019 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0
Replies: 4
Views: 448

TI processes significantly slower after upgrade from TM1 10.2.2 to TM1 2.0

Hello, I have a bunch of processes that significantly slowed down after an upgrade from 10.2.2 to 2.0. The process that used to take 2 minutes now takes 20. There are no changes in the configuration file, and ForceReevaluationOfFeedersForFedCellsOnDataChange is set to "T" on both old and new servers...
by AskAndAnswer
Tue Feb 19, 2019 6:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Operations Console Problem
Replies: 0
Views: 342

TM1 Operations Console Problem

Hello,
Here is an issue:
When I open Ops Console Login page, I do not see anything in Namespace drop-down.
I added default admin host in the configuration, still namespace is empty.
What is that I am missing?
Thanks.
by AskAndAnswer
Mon Nov 19, 2018 2:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 610

Re: MDX using OR

Thank you for your advises. I think I will go with UNION for now and see how it works.
by AskAndAnswer
Thu Nov 15, 2018 7:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 610

Re: MDX using OR

The point is to have a dynamic subset that will change based on the values in the control cube. The rollup needs to be maintained.
Anyway, I created what I needed using UNION. Not sure if it's the best way, but it works.
by AskAndAnswer
Thu Nov 15, 2018 6:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX using OR
Replies: 5
Views: 610

MDX using OR

Hello, How to filter a subset based on another cube value using OR function? I have the following statement: {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {FILTER( {TM1SUBSETALL( [Time] )}, [Time].CurrentMember.Name = Sys_Cube.([Mesure1].[Current Year], [Measure2].[String]) )}, ALL, RECURSIVE )}, 0)} I ne...
by AskAndAnswer
Thu Nov 15, 2018 2:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Two SSL certificate related questions
Replies: 0
Views: 516

Two SSL certificate related questions

Hello, I hope I can get help here. I am trying to apply custom SSL certificates to TM1 Admin server. The certificates were requested and received in three files, two of which, root and intermediate were loaded successfully, but the machine CA returned an error message "The certificate request is not...
by AskAndAnswer
Wed Sep 19, 2018 4:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Question
Replies: 2
Views: 411

Re: MDX Question

This is perfect, thank you!
by AskAndAnswer
Tue Sep 18, 2018 9:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX Question
Replies: 2
Views: 411

MDX Question

Hello, I am trying to write MDX that would return leaf elements for multiple consolidations. For example, {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER( {TM1FILTERBYPATTERN( {TM1SUBSETALL( [Period] )}, "M01")}, ALL, RECURSIVE )}, 0)} will return all dates under M01 (Month1). Is there a way to write MDX so ...
by AskAndAnswer
Tue Apr 17, 2018 10:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Installing PAW on Window Server 2012 R1 on VM
Replies: 2
Views: 832

Re: Installing PAW on Window Server 2012 R1 on VM

I've installed PAW on 2012 VM. The first thing you need to check is if it has a nested VM. Second, the latest version of Docker Toolbox will not work with PAW, you need to downgrade Docker to 17.06.2 or even 1.12.6 in some cases. Also, if you run Docker as an admin, more than likely PAW will have to...
by AskAndAnswer
Tue Apr 17, 2018 10:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process slow
Replies: 2
Views: 710

Re: TI Process slow

It turned out to be a feeder issue in one of the target cubes. Thank you.
by AskAndAnswer
Mon Apr 16, 2018 11:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI Process slow
Replies: 2
Views: 710

TI Process slow

There are two processes - Process 1 and Process 2. Process 1 runs very quickly when executed independently. When it's executed from Process 2, it takes a while to complete hanging on the Epilog procedures. Process 2 is generally very slow, but ExecuteProcess (Process 1) is the first command in the P...