TM1 Forum

Maybe a couple of things to look into.
1) If a custom report, is the "Refresh data on writeback" option set to "None" in the Planning Analytics Options?
2) Is the Excel Calculation Option set to "Manual".

We see this happen when Microsoft updates are pushed on existing setups with certain builds.
However, we also have seen this on new installs but not as often with existing setups.

I have seen this a few times.
We were able to fix the issue by trying the different display resolution options in your windows display settings.

Try the different display resolutions of your monitor.
We have had out of the ordinary display issues which were resolved by trying the different resolution options.

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

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.

May be related to defect number PH18955.
Check with IBM Support.

Instead of F9 try [Ctrl]+[Shift]+[Alt]+[F9]

In Excel, File->Options->General and check if the excel option “Optimize for Compatibility” is selected/active.
If not select/activate that option.

Try
[Ctrl]+[Shift]+[Alt]+[F9]
See if it works

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

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

Thank you much!

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

Thank you,

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

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

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

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

New Value = ''''| Old Value|'''';

Try turning off excel auto calculation and save the sheet.

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