TM1 Forum

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" into hierarchy "YY...

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.

I build lots of rubik's cubes in a company so that people can play with. That's my job.

Thanks, I am using CAM. Maybe that's the reason?

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?

That is interesting to know. However, this property doesn't seem to work properly at least in 2.0.9.1.

Maybe reduce the number of crossjoin and starts from the minimum?

Hi, do you want to share your MDX first and how did you display the MDX view in PAW?

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.

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

I remember PAW cloud version has email sharing function but don't do it automatically.

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.

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

An admin license is still required if you want to modify objects or other admin tasks through PAW.

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