Search found 39 matches

by AskAndAnswer
Fri Nov 01, 2019 9:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Dynamic Report is not rendering to TM1 Web
Replies: 3
Views: 2376

Re: PAX Dynamic Report is not rendering to TM1 Web

Since I figured it out, I'll post the solution:
It looks like this version of Planning Analytics has an issue reading aliases. All row dimension elements should have principal names.
by AskAndAnswer
Fri Nov 01, 2019 4:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Dynamic Report is not rendering to TM1 Web
Replies: 3
Views: 2376

PAX Dynamic Report is not rendering to TM1 Web

Hello, I found several discussions about this issue, but none of them actually answered a question why dynamic reports are not properly rendering in TM1 Web. I am on Planning Analytics and PAX 2.0.6 and I have a dynamic report with four row dimensions, one of which (Time) is based on the subset crea...
by AskAndAnswer
Fri Nov 01, 2019 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use TM1RunTI in the TM1 process
Replies: 7
Views: 6636

Re: Use TM1RunTI in the TM1 process

My response that I cannot install anything on IBM cloud addressed the suggestion to use RushTi. It is my first time trying to create a multi-threaded process. I have an idea how to do it, and my question was about thread control. If I have 10 threads and 20 processes, how do I tell the 11th process ...
by AskAndAnswer
Fri Oct 18, 2019 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use TM1RunTI in the TM1 process
Replies: 7
Views: 6636

Re: Use TM1RunTI in the TM1 process

I am not allowed to install additional tools on IBM cloud.
by AskAndAnswer
Wed Oct 16, 2019 6:46 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use TM1RunTI in the TM1 process
Replies: 7
Views: 6636

Use TM1RunTI in the TM1 process

I'd like to create a multi-threaded TM1 process that will run a TI for each month in the time dimension. The idea is to create a loop that will pick a month and then use TM1RunTI to call another process that will use a month as a parameter that will be passed to a SQL query. My issue is that I have ...
by AskAndAnswer
Fri Jun 28, 2019 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 7
Views: 989

Re: Use subsets in DBRW

That's what I was trying to avoid, and in fact there is a work around - create a hidden dynamic report with the given subset in the TM1RPTROW and a sum underneath, then refer the sum.
by AskAndAnswer
Thu Jun 27, 2019 5:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use subsets in DBRW
Replies: 7
Views: 989

Use subsets in DBRW

I have a report that used a dimension subset in DBRW formula. It worked in Perspectives, but it does not work in PAX custom report. Is there anything that can mimic the functionality besides creating an alternate hierarchy in the dimension? Virtual dimensions don't work in the custom reports, as far...
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: 458

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: 458

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: 458

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: 934

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: 1830

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: 1830

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: 1830

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: 654

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: 654

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: 728

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: 795

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: 795

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.