Search found 732 matches

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: 261

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: 261

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: 1425

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: 789

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: 789

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...
by macsir
Tue Oct 13, 2020 11:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives and PAfE Both Enabled in Excel
Replies: 5
Views: 789

Perspectives and PAfE Both Enabled in Excel

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.
by macsir
Mon Oct 12, 2020 8:06 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: OptimusPy - Ideal dimension order finder
Replies: 4
Views: 602

Re: OptimusPy - Ideal dimension order finder

Thanks, Marius. Will test it later.
by macsir
Thu Oct 08, 2020 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How you would explain what is TM1 to your mom ?
Replies: 6
Views: 643

Re: How you would explain what is TM1 to your mom ?

I build lots of rubik's cubes in a company so that people can play with. That's my job.
by macsir
Thu Oct 01, 2020 8:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

Thanks, I am using CAM. Maybe that's the reason?
by macsir
Wed Sep 30, 2020 8:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

Thanks, Wim.
I tested it as well in Perspectives but not working. Do you need to reboot the server after this change?
What does the TM1 Perspectives say after disabling? How about PAfe and PAW?
by macsir
Tue Sep 29, 2020 8:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA 2.07 - }ClientProperties cube
Replies: 12
Views: 668

Re: PA 2.07 - }ClientProperties cube

That is interesting to know. However, this property doesn't seem to work properly at least in 2.0.9.1.
by macsir
Sun Sep 27, 2020 8:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 285

Re: MDX views, where / how are they evaluated?

Maybe reduce the number of crossjoin and starts from the minimum?
by macsir
Thu Sep 24, 2020 8:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX views, where / how are they evaluated?
Replies: 6
Views: 285

Re: MDX views, where / how are they evaluated?

Hi, do you want to share your MDX first and how did you display the MDX view in PAW?
by macsir
Thu Sep 24, 2020 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security on Alternate Hierarchy?
Replies: 2
Views: 289

Re: Security on Alternate Hierarchy?

PavoGa wrote:
Thu Sep 24, 2020 7:52 pm
A shot in the dark here, but have you tried applying security to the }Hierarchies_dimname dimension?
Thanks, yes, I have tried and TM1 actually created that security cube for me but still doesn't work. According to IBM's reply, it hasn't been implemented yet but on their roadmap.
by macsir
Sun Sep 20, 2020 11:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security on Alternate Hierarchy?
Replies: 2
Views: 289

Security on Alternate Hierarchy?

I can see the alternate hierarchy is in }DimensionSecurity cube. I thought I can put some securities on them but apparently it doesn't work in PAW. Users with NONE access can still see and use the hierarchies normally. As long as the user has READ access on dimension, then he can use alternate hiera...
by macsir
Thu Sep 17, 2020 8:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW export and send by mail automatically
Replies: 2
Views: 160

Re: PAW export and send by mail automatically

I remember PAW cloud version has email sharing function but don't do it automatically.
by macsir
Wed Sep 09, 2020 1:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design Mode
Replies: 2
Views: 158

Re: Design Mode

Thanks, Steve. After several testing, I just realized this function doesn't work with just only one cell's copying and pasting. If more than one cells, it works as expected. :)
by macsir
Tue Sep 08, 2020 4:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Design Mode
Replies: 2
Views: 158

Design Mode

Hi, I am trying to test the design mode in Custom Report or Dynamic Report. But neither of them work as to the descriptions from the document. Whenever I copy and past any static value into cells with DBRW formulas inside it already in the reports, it always replace it with those static values. It d...
by macsir
Thu Sep 03, 2020 9:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW License
Replies: 4
Views: 252

Re: PAW License

An admin license is still required if you want to modify objects or other admin tasks through PAW.
by macsir
Wed Sep 02, 2020 9:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: UNDEFVALs in PAX vs Websheets
Replies: 1
Views: 170

Re: UNDEFVALs in PAX vs Websheets

PAL 2.0.9.1 has no issue. I use same example you did and the web didn't show 0 for null values and it is just blanks. 0 is shown as 0 anyway. BTW, we enabled the new cell formatting although I don't think it is relevant. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cogn...