TM1 Forum

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

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

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?

I use cam new client parameter and delete the user from }clients dim will disable the user.

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

Do you have any antivirus software which was running or scanning in the backend?

RAM=Storage
CPU=Speed
Lotsaram is not just enough, prefer Tonsaram.

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

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

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

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

I think it is only available for Impact Diagram when you create score card type of cubes in TM1.

Did you check your log files in the PAW install folder? Any error msg from there?

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

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

it seems like a fairly basic thing to test before release

I agree.

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.

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

Hi, I am considering to keep TM1 Perspectives addin (from 2.0.8 install) and PAfE (v55) both enabled in Excel when we deploy to end users.
Is there any disadvantage for doing so or any problem you are aware when using any of them in Excel? Thanks.

Thanks, Marius. Will test it later.