Search found 21 matches

by sypkens
Mon Sep 08, 2014 3:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form Hierarchy expand all question
Replies: 2
Views: 1439

Re: TM1 Active Form Hierarchy expand all question

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 "Expanded" and s...
by sypkens
Mon Jun 23, 2014 7:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bulk data Mode TM1 server not responding
Replies: 6
Views: 2035

Re: Bulk data Mode TM1 server not responding

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...
by sypkens
Mon Jun 23, 2014 6:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bulk data Mode TM1 server not responding
Replies: 6
Views: 2035

Re: Bulk data Mode TM1 server not responding

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...
by sypkens
Mon Jun 23, 2014 4:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Bulk data Mode TM1 server not responding
Replies: 6
Views: 2035

Re: Bulk data Mode TM1 server not responding

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...
by sypkens
Fri Jun 28, 2013 12:38 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Can two server machines use single Content Store
Replies: 3
Views: 1512

Re: Can two server machines use single Content Store

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...
by sypkens
Mon Jun 24, 2013 4:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application Design Tools Like Visio?
Replies: 2
Views: 820

Re: Application Design Tools Like Visio?

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 in how it...
by sypkens
Thu Jan 10, 2013 12:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to connect to TM1 cube from different Cognos BI env
Replies: 7
Views: 4583

Re: Unable to connect to TM1 cube from different Cognos BI e

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 ...
by sypkens
Tue Jan 08, 2013 7:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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...
by sypkens
Tue Jan 08, 2013 7:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to connect to TM1 cube from different Cognos BI env
Replies: 7
Views: 4583

Re: Unable to connect to TM1 cube from different Cognos BI e

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
by sypkens
Tue Jan 08, 2013 5:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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...
by sypkens
Mon Jan 07, 2013 5:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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...
by sypkens
Wed Nov 21, 2012 3:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to run chore one after another?
Replies: 2
Views: 1150

Re: How to run chore one after another?

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...
by sypkens
Tue Aug 21, 2012 1:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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...
by sypkens
Thu Aug 16, 2012 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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 business u...
by sypkens
Mon Aug 13, 2012 6:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Re: Determine Client Software Connection Type

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...
by sypkens
Wed Aug 08, 2012 6:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Determine Client Software Connection Type
Replies: 17
Views: 2545

Determine Client Software Connection Type

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...
by sypkens
Tue Dec 06, 2011 9:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contributor Approval Hierarchy alias
Replies: 2
Views: 2391

Re: Contributor Approval Hierarchy alias

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
by sypkens
Tue Dec 06, 2011 7:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Contributor Approval Hierarchy alias
Replies: 2
Views: 2391

Contributor Approval Hierarchy alias

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? thanks...
by sypkens
Fri Nov 18, 2011 4:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Views (Non MDX)
Replies: 7
Views: 3893

Re: Dynamic Views (Non MDX)

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...
by sypkens
Thu Nov 17, 2011 10:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic Views (Non MDX)
Replies: 7
Views: 3893

Re: Dynamic Views (Non MDX)

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