TM1 Forum

Hi Nick other forum people might have other ideas but I would try creating 2 MDX statements in 2 separate cells (one for the collapsed view and one for the Drilldownmember statement). Add a data validation list in your excel web sheet in a 3rd cell and give it values "Collapsed" and "...

I dont believe data reservation addresses the issue we had. Data Reservation merely assists with taking ownership of a node once logged in in Contributor - and it should form part of your overall chore / process if you wish to update data for a locked node regardless. in our case the simple act of l...

Hi Nick In our case we had 2 instances (both had Contributor apps). When you log into contributor the behaviour we saw was that contrib would athenticate against every instance listed with the admin server - regardless of where the particular contrib app was pointed to). when the chore ran in one in...

Hi Jodha I believe we encountered this issue as well and our work around at the time was to force a restart of a the instance and then run the chore at which point the chore ran like a dream i.e. the outcome was that there were no logged-on users and hence the server only had to focus on running the...

Hi You can have mutiple content managers (purely from a fail over scenario) so technically you should be able to do that. I would however strongly recommend you read help files on content manager configuration end to end on how to configure it (this is for Version 10). And obviously take a backup of...

Hi PlanningDev I have not used anything other than Visio in the past. I have seen some posts previously on the forum with tools that I assume hooks into the API and then "automatically" draws the soution out for you but I have either been to stupid to make it work or it was too restrictive...

Hi PlanningDev No I have not installed the TM1 client on every dispatcher. I installed it on the Content Manager in every instance and then only used that box to test the connection (which tested successfully depending on how I configured ServerCAMURI). Are you definitely using CAM Security in your ...

Hi Lotsa Found today that ISB is working and yes it is a feature. Robin It is a combination of predominantly not enough trained users and in a small minority some users who are just plain dangerous e.g. MDX, crashing servers etc. i.e. they need a little bit of education to do it properly. We also ru...

Hi

I have the same issue i.e. multiple BI environments, Dispatchers, Content Managers. Does anybody I have any suggestions for making a TM1 datasource logon work through multiple CM's and using CAM Security?

Thanks

Jan

Hi It is a large organisation and there are various TM1 instances in other sections of the business. From our perspective we wish to ensure specific development standards in our instance of TM1. Some of the other areas are less worried about it and hence have released Perspectives to their (untraine...

Hi As a follow up to the original question, we have found a way to limit the running of explorer on end users machines via the Capability Assignments -> Access to Server Explorer. By Setting it to Deny for certain user groups we can limit the access they can have via Server Explorer but still provid...

Hi I have recently encountered something similar where i needed to execute chores using TM1RunTI which according to the documentation it cannot do (I believe it will only execute processes). My work around was to build a cube with a pick list to }Processes and the ability to specify parameters and t...

Hi PlanningDev We have realised that the BI interface will export to excel and are quite comfortable with it. We are looking at watermarking the canned reports. The excel export still restricts the user to a defined format - which ultimately will not stop them from using the data - it just means the...

Tomok, I am in violent agreement. However in this company's case they have purchased the Analytical Applications, Adaptive Warehouse and business viewpoint from IBM and hence have "canned reports" and centralised hierarchies with a direct feed from the ERP. The company has a history where ...

Hi Lazarus If I can determine the software connection type, I could set different security rules. Working at a large organisation that is trying to discourage the use of Excel customised reporting i.e. the preference is to use the BI tools over TM1. A few bad apples have managed to secure Perspectiv...

Hi, I have had look around but because the terms are so generic not finding anything without having to peruse a lot of irrelevant posts - Maybe it is my search term (TM1 determine client connection type). I am essentially trying work out when a client makes a connection what client software are they...

Hi

I have resolved the issue. When you name your alias "Description" it will not use the alias in the approval hierarchy. If you name it something else it will work.

Apologies for posting in the wrong area of the forum.

regards,

jan

Hi I have seen an earlier post (http://www.tm1forum.com/viewtopic.php?f=3&t=3082) asking whether it is possible to use an Alias in the approval hierarchy in Contributor. Is anyone aware if this has been fixed yet? Or is it not an issue and am I missing a glaringly obvious simplistic solution? th...

Hi QML and Tomok I believe QML solved it. There was a zero suppression set on Rows (i previously only looked at the toolbar which does not show row suppression so never picked up that there was zero suppression set). As for Tomok, I was thinking your aproach was what was being used but what threw me...

Hi Steve, There is no zero suppression set in the view. this behaviour is also showing in perspectives (not just in contributor). I am aware that you can achieve this using MDX but there is not a subset set with MDX or filtering so I am curious if anyone else has seen this. see before and after scre...