Search found 67 matches

by jorelb
Fri Aug 14, 2020 3:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Transaction Log search not working
Replies: 5
Views: 171

Re: Transaction Log search not working

There was a fix to the transaction log on PA 2.0.9.
Not sure if the fix addresses your specific situation.

PH16199: INVALID TRANSACTION LOG ID
by jorelb
Mon Apr 20, 2020 8:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.0.7 - PA as datasource in CA 11.1.5
Replies: 2
Views: 829

Re: PA 2.0.7 - PA as datasource in CA 11.1.5

If I am not mistaken, to be able to use PA as a CA data source, the PA version should be 2.0.8 IF (2) or higher.
by jorelb
Tue Nov 12, 2019 3:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX File Frozen
Replies: 1
Views: 606

Re: PAX File Frozen

May be related to defect number PH18955.
Check with IBM Support.
by jorelb
Thu Nov 07, 2019 4:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx Issue
Replies: 5
Views: 648

Re: PAx Issue

Instead of F9 try [Ctrl]+[Shift]+[Alt]+[F9]
by jorelb
Thu Jul 18, 2019 10:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX has blank task pane
Replies: 5
Views: 1792

Re: PAX has blank task pane

In Excel, File->Options->General and check if the excel option “Optimize for Compatibility” is selected/active.
If not select/activate that option.
by jorelb
Wed Jan 09, 2019 3:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAx not fully recalculating
Replies: 8
Views: 1254

Re: PAx not fully recalculating

Try
[Ctrl]+[Shift]+[Alt]+[F9]
See if it works
by jorelb
Mon Dec 10, 2018 10:09 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Multiple PAX issues - Excel Office 365 compatibility?
Replies: 4
Views: 1981

Re: Multiple PAX issues - Excel Office 365 compatibility?

We experience the same issues and below is how we resolve them. 1) 99% of the time, when #NAME comes up with DBR/DBRW formulas, deleting the "Office Connection" located in C:\Users\username\AppData\Local\Cognos solves the problem. Users will just need to set up the connection URL. If the above metho...
by jorelb
Mon Dec 10, 2018 9:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX Set Editor: assigning the “members to view” to default to something other than “All Roots”
Replies: 4
Views: 1179

Re: PAX Set Editor: assigning the “members to view” to default to something other than “All Roots”

I think with PAW 38, the ability to save private default subsets is enabled. With private subsets enabled, when you open the Set Editor, the right pane will display the elements of the private default. There is no mention of this functionality in the release but I have been able to make it work some...
by jorelb
Wed Mar 21, 2018 5:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Restrict non-admin users to create public views and public subsets
Replies: 2
Views: 1031

Restrict non-admin users to create public views and public subsets

Is there a way to restrict non-admin users to create public views and public subsets?
Any help is much appreciated.

Thank you,
by jorelb
Thu Jan 25, 2018 2:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modifying Set Editor Defaults
Replies: 4
Views: 1678

Re: Modifying Set Editor Defaults

Alan,

We do have Default public subsets in the dimensions. However, the Planning Analytics' subset dropdown defaults to All Members.
Is there a way to change the All Members to the Default public subset?

Thank you
by jorelb
Wed Jan 24, 2018 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Modifying Set Editor Defaults
Replies: 4
Views: 1678

Modifying Set Editor Defaults

Is there a way to modify the Set Editor Default?

We have a large dimension and users do not want to dig through all the members as the set editor is set to default to all members.

How can I change the set editor to default to a specific subset.

Tha
by jorelb
Sun Jul 02, 2017 5:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM PAx excel addin conflict with Oracle Web ADI
Replies: 0
Views: 1004

IBM PAx excel addin conflict with Oracle Web ADI

We are converting from Hyperion Planning to IBM Planning Analytics 2.0. At first everything was working smoothly with the IBM PAx excel add-in until our accounting operations staff started using their Oracle EBS journal entry excel templates (Web ADI 12.0). Every time they will enable the Oracle tem...
by jorelb
Mon Sep 10, 2012 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting Cube data to Sql Server Table
Replies: 12
Views: 6921

Re: Exporting Cube data to Sql Server Table

Try exporting the old values using the formula below. SQL is looking for the ‘ ‘.

New Value = ''''| Old Value|'''';
by jorelb
Mon Sep 10, 2012 4:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data lost in TM1 Excel
Replies: 6
Views: 2108

Re: Data lost in TM1 Excel

Try turning off excel auto calculation and save the sheet.
by jorelb
Thu Aug 30, 2012 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ADPlus Restarts Server
Replies: 0
Views: 619

ADPlus Restarts Server

Hello All, I ran ADPlus in our development server using “adplus -crash -pn tm1sd.exe -o d:\dumps –quiet” in the command line. Every time I test ADPLus by ending one of the tm1 services, the development server will restart. Has anybody encountered this situation and how was it resolved? Below are the...
by jorelb
Thu Sep 01, 2011 10:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error installing TM1 9.5.2 with Excel 2010
Replies: 4
Views: 1958

Re: Error installing TM1 9.5.2 with Excel 2010

Excel 2010 64 or 32 bit? TM1 will only work with Excel 2010 32 bit.
by jorelb
Tue Aug 30, 2011 9:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Independent Certificates
Replies: 0
Views: 774

Using Independent Certificates

Our company requires that we use our own certificates in TM1 and all my attempts to get it running fails. I have been following the instructions in the attached document and still I am not able to get the tm1admsd.exe to start. The tm1admsrv log keeps returning the error below. 3936 INFO 2011-08-24 ...
by jorelb
Mon May 23, 2011 9:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC Connection for Oracle is not Working
Replies: 8
Views: 5301

Re: ODBC Connection for Oracle is not Working

I am also having the same issue but on Oracle R12. I added the additional parameter in the tm1s.cfg file and everytime I click on the variable tab, I get the blank error message and it crashes the service. Is there a known fix?

Thank you.