Search found 747 matches
- Thu Jan 14, 2021 8:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1.SQLAPI error message in TM1Server log
- Replies: 4
- Views: 155
Re: TM1.SQLAPI error message in TM1Server log
What is the version of your TM1 server? I have seen some in 2.0.8 but they disappeared after upgrading to 2.0.9.1.
- Mon Dec 21, 2020 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW not showing values until pressing enter in cells
- Replies: 2
- Views: 488
Re: DBRW not showing values until pressing enter in cells
I should say there is no sequence of wrong-refreshed sheet with a subset inside it. As long as you have a subset in DBRW references in PAfE, then all sheets are just partially refreshed no matter where the subset is.
- Sun Dec 20, 2020 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Dimension Element Security - Most restrictive
- Replies: 5
- Views: 329
Re: Dimension Element Security - Most restrictive
There is a flag CELLSECURITYMOSTRESTRICTIVE in }CubeSecurityProperties. When CELLSECURITYMOSTRESTRICTIVE is yes, Element and Cell Security behave such that the most restrictive applies. For instance, if Element Security for a specific element is set to READ for a given Group and Cell Security for a ...
- Wed Dec 16, 2020 10:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW not showing values until pressing enter in cells
- Replies: 2
- Views: 488
Re: DBRW not showing values until pressing enter in cells
After all testing, I found it is due to a subset was used in one of DBRW formulas in a sheet. As IBM decided not to support this, the report was actually partially refreshed. Only the parts before this referencing point was refreshed fine, not the ones after or including this specific sheet. This ch...
- Wed Dec 16, 2020 7:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Dashboards Sluggish after upgrade to 2.0.59
- Replies: 4
- Views: 511
Re: PAW Dashboards Sluggish after upgrade to 2.0.59
Have you tried to build a new one from scratch which is the same as old one to see if it is still slow?
Is there any clue from the PAW log files?
Are you running PAW server on windows? If yes, anything special in the windows event viewer?
Is there any clue from the PAW log files?
Are you running PAW server on windows? If yes, anything special in the windows event viewer?
- Mon Dec 14, 2020 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PA 2.07 - }ClientProperties cube
- Replies: 15
- Views: 1488
Re: PA 2.07 - }ClientProperties cube
I use cam new client parameter and delete the user from }clients dim will disable the user.
- Mon Dec 14, 2020 11:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW not showing values until pressing enter in cells
- Replies: 2
- Views: 488
DBRW not showing values until pressing enter in cells
I have an existing slicing report with DBRW. Most of them are fine in PAfE v52 except for several cells which are always showing ”#value”. The formula is alright with right value in Perspectives. And in PAfE, it can show the right value until I press enter in the formula. Did I miss something and ne...
- Thu Dec 10, 2020 8:26 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE CPU "Leak"
- Replies: 3
- Views: 433
Re: PAfE CPU "Leak"
Do you have any antivirus software which was running or scanning in the backend?
- Mon Nov 30, 2020 8:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 Servers with TBs of Memory
- Replies: 13
- Views: 795
Re: TM1 Servers with TBs of Memory
RAM=Storage
CPU=Speed
Lotsaram is not just enough, prefer Tonsaram.
CPU=Speed
Lotsaram is not just enough, prefer Tonsaram.

- Sat Nov 07, 2020 12:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: JAVA Extension
- Replies: 9
- Views: 2421
Re: JAVA Extension
Hi, Alan Yes, I totally understand. However, at least the Java extension works beautifully for me at the moment and I can't find other better way to replace it. Python is hot nowadays but who knows the future? Maybe golang becomes the next candidate when IBM releases the next generation of TM1 serve...
- Sat Nov 07, 2020 12:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: What is the TM1 element member name maximum size limitation?
- Replies: 5
- Views: 3165
Re: What is the TM1 element member name maximum size limitation?
Interesting to know and thanks for the code. After testing, if wants the element to display properly in Architect, then nMax = 43679 is the limit. Otherwise, it will show empty element name with numeric icon at the first but definitely the element exists and is valid. In PAW, the limit goes above th...
- Thu Nov 05, 2020 10:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: JAVA Extension
- Replies: 9
- Views: 2421
Re: JAVA Extension
Actually, the latest note is here https://www.ibm.com/support/pages/deprecation-notices-ibm-planning-analytics-20 Java TI support Java TI remains supported in Planning Analytics version 2.0.7. However, the use of Java TI is discouraged in cases where it is not required. IBM supports only the version...
- Thu Oct 29, 2020 8:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: AIX (TM1 10.2.2) to Windows Server 2016 (PA 2.0)
- Replies: 2
- Views: 226
Re: AIX (TM1 10.2.2) to Windows Server 2016 (PA 2.0)
Haven't had chance to use it but looks like the tool is still available. https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_op.2.0.0.doc/c_tm1_op_tools_tm1xfer.html May I know the reason for the transfer? I heard about that the general performance on Unix is faster th...
- Mon Oct 26, 2020 8:33 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAw range handle bars for Dimensions?
- Replies: 2
- Views: 209
Re: PAw range handle bars for Dimensions?
I think it is only available for Impact Diagram when you create score card type of cubes in TM1.
- Sun Oct 25, 2020 8:32 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW installation in Centos Linux or Windows Server 2012
- Replies: 11
- Views: 830
Re: PAW installation in Centos Linux or Windows Server 2012
Did you check your log files in the PAW install folder? Any error msg from there?
- Wed Oct 21, 2020 11:44 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can't change from N to C in PA with hierarchy enabled?
- Replies: 2
- Views: 420
Re: Can't change from N to C in PA with hierarchy enabled?
Hi, mate Thanks. Yes, as long as the leaf is not used in other hierarchies other than the default and leaves hierarchies, it still can be converted from N to C automatically. I actually might find a bug while playing with this when using DIRECT version of dimension functions. i.e. DIMENSIONELEMENTIN...
- Tue Oct 20, 2020 3:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can't change from N to C in PA with hierarchy enabled?
- Replies: 2
- Views: 420
Can't change from N to C in PA with hierarchy enabled?
Hi, so for a dimension with hierarchy enabled in PA, if I want to change 'N' element "XXX" to 'C' element by adding a child under that element in a hierarchy, it won't allow as it is a leaf in 'Leaves' hierarchy already. It pops with the following error, Insertion of element "XXX" into hierarchy "YY...
- Sun Oct 18, 2020 8:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Corrupt CAMKeystore when using IBM Cognos Configuration in 2.0.9.1
- Replies: 7
- Views: 1905
Re: Corrupt CAMKeystore when using IBM Cognos Configuration in 2.0.9.1
I agree.it seems like a fairly basic thing to test before release
- Thu Oct 15, 2020 9:58 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives and PAfE Both Enabled in Excel
- Replies: 5
- Views: 1068
Re: Perspectives and PAfE Both Enabled in Excel
Thanks for sharing the experience, both. Yes, you are right. Better to commit to PAfE only. I will select a group of key users to start testing and disable Perspectives by default after installing PAfE.
- Thu Oct 15, 2020 4:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Perspectives and PAfE Both Enabled in Excel
- Replies: 5
- Views: 1068
Re: Perspectives and PAfE Both Enabled in Excel
Hi, Ajay Thanks for the detailed info. The main reason I want to do this is that don't want to cause any inconvenience and panic to end users during this transition period when deploying although I will give out some training in advance. Yes, I did have some snapshotting or slicing issues from Persp...