Search found 35 matches

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: 1
Views: 135

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: 6
Views: 756

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: 6
Views: 756

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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