Search found 747 matches

by macsir
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.
by macsir
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.
by macsir
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 ...
by macsir
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...
by macsir
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?
by macsir
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.
by macsir
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...
by macsir
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?
by macsir
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. :D
by macsir
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...
by macsir
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...
by macsir
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...
by macsir
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...
by macsir
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.
by macsir
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?
by macsir
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...
by macsir
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...
by macsir
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

it seems like a fairly basic thing to test before release
I agree.
by macsir
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.
by macsir
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...