Search found 1248 matches

by David Usherwood
Sun Nov 04, 2018 7:59 am
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 316

Re: Deactivating chores in Architect takes time

It's Marius' (sample) code, not mine. I suggest you install Python and TM1PY and play around with it. My own view is that this is far and away the best way to use the REST API for most purposes. (I have made some progress with using TM1PY to integrate TM1 with PowerBI.)
by David Usherwood
Fri Nov 02, 2018 2:17 pm
Forum: Useful code, tips and tricks
Topic: Deactivating chores in Architect takes time
Replies: 9
Views: 316

Re: Deactivating chores in Architect takes time

I sometimes feel like a stuck record promoting TM1PY, but one of Marius' examples does exactly that: https://github.com/cubewise-code/TM1py-samples/blob/master/Update%20Objects/update%20chore.py To repeat the key code: with TM1Service(**config['tm1srv01']) as tm1: # Read chore: c = tm1.chores.get('r...
by David Usherwood
Fri Oct 26, 2018 11:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos Applications (Contributor) Question
Replies: 3
Views: 197

Re: Cognos Applications (Contributor) Question

It's not been said in this thread, but 'Applications Web' (=Contributor) is still available with PA. I doubt it supports named hierarchies (which, IMO, are not really finished anyway) but, with all its known fragility and flakiness, it's there. I have my doubts about what IBM will do in PAW to deliv...
by David Usherwood
Wed Sep 26, 2018 5:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to delete a view via right click in PAW?
Replies: 5
Views: 438

Re: How to delete a view via right click in PAW?

The toolbar I see at the top left (if that's what you have in mind) has no delete icon (I imagine a dustbin or whatever) when a view is selected (in chrome, as admin). Can you elucidate?
by David Usherwood
Wed Sep 26, 2018 6:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Vb.net with Pax
Replies: 9
Views: 906

Re: Vb.net with Pax

Hope Revelwood won't mind me posting their writeup of PAX and VBA (I know, not vb.net, but it is relevant IMO):
https://knowledgecenter.revelwood.com/i ... api-calls/
by David Usherwood
Tue Sep 25, 2018 8:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Excel Recalculation Speed Issue
Replies: 3
Views: 494

Re: Excel Recalculation Speed Issue

(c) Do you have a properly constructed View() function to specify the cube name so that TM1 minimises the amount of calculation that it does? If the answer is no, create one. (c) - Not sure what this refers to...can you point me in the right direction? Looks like that's your problem then. Create a ...
by David Usherwood
Sun Sep 23, 2018 11:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How should I do it? I want to modify the rules without anyone using TM1.
Replies: 3
Views: 943

Re: How should I do it? I want to modify the rules without anyone using TM1.

I recall a post but cannot track it down, suggesting that a good way to lock CAM/AD users out while work is going on is to change IntegratedSecurityMode from 5 to 1. This TM1S.CFG is dynamic in PA 2 at least (not I believe in TM1 10.x) https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com....
by David Usherwood
Thu Aug 16, 2018 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Web Dashboards via REST API
Replies: 5
Views: 778

Re: Web Dashboards via REST API

Why not just use PAW?
by David Usherwood
Mon Jul 30, 2018 11:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics using twice the memory of 10.1
Replies: 32
Views: 2713

Re: Planning Analytics using twice the memory of 10.1

The annoying thing is that MUNs are only there for Cognos BI as all elements in TM1 have to be unique I don't believe that non-leaf elements in the new, named hierarchies need to be unique across all hierarchies. This kinda sorta confirms this - from a post by harrytm1 dated 21 Dec 2016: Hierarchie...
by David Usherwood
Thu Jul 12, 2018 9:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Check if the data of two cubes are the same
Replies: 5
Views: 637

Re: Check if the data of two cubes are the same

Where to start... Firstly, it wouldn't be sensible to review the destination cube till all the concurrent processes are complete. Secondly, TM1 exists to roll up data to totals. If the dimensions of your cubes have been designed sensibly there will be totals on almost all dimensions. Create a slice ...
by David Usherwood
Thu Jul 12, 2018 9:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 1199

Re: Executing Java application through TM1 process

I would argue that you can do much, much more with the REST API than just retrieving data from a TM1 server. But I agree with you that TM1Web is not customisable in the way that the OP had imagined. That doesn't stop them from using the REST API to populate a TM1 cube which can then be put on a webs...
by David Usherwood
Tue Jul 10, 2018 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 1199

Re: Executing Java application through TM1 process

I just gave it as a first hand example as this was not the only thing we wanted to do, that is why I dabbled with the API, so that we can expand on it. Getting logged clients is just a starting point of our TM1 extension using TM1 API. Be aware that there are many APIs available. I would recommend ...
by David Usherwood
Mon Jul 09, 2018 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Executing Java application through TM1 process
Replies: 10
Views: 1199

Re: Executing Java application through TM1 process

I would suggest you are out of luck, since you can neither transfer the JAR file to the server nor execute it there. Time to rethink your approach. If you are willing to recode in Python, I have a good opinion of Marius Wirtz' TM1PY libraries ( https://code.cubewise.com/tm1py/ ) I'm also going to as...
by David Usherwood
Fri Jun 29, 2018 9:05 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Benefits of REST API over native TM1py/TM1JavaApi
Replies: 3
Views: 370

Re: Benefits of REST API over native TM1py/TM1JavaApi

To quote from the TM1PY page: By wrapping the IBM Planning Analytics (TM1) REST API in a concise Python framework, TM1py facilitates Python developments for TM1. So, by using TM1PY, you are using the Rest API - just wrapped in a more manageable package. I'm a fan of TM1PY and think Mariusz has done ...
by David Usherwood
Fri Jun 22, 2018 8:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PA when running TI processes Kick out RDP
Replies: 6
Views: 556

Re: PA when running TI processes Kick out RDP

Probably the issue is that the credentials under which the TM1 instance on the server is running do not have the same access as those on the local instance - remember it's the instance rather than the user who executes the TI which determines access. But I have some wider questions - since TM1 as a...
by David Usherwood
Tue Jun 19, 2018 5:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using dimension PickList to filter data on import to cube
Replies: 9
Views: 1174

Re: Using dimension PickList to filter data on import to cube

Suggest IF (DimIx ('2 Major Project PL List', Planning_Project_Code) > 0); CellPutS(Planning_Project_Code, 'Major Project Assumption', job_unique_id, 'Major Project Number'); ELSE; itemskip; ENDIF; Also - I don't think you should be adding elements into the dimension using if (DIMIX('3 Major Project...
by David Usherwood
Wed May 09, 2018 10:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: stored values in tm1
Replies: 6
Views: 762

Re: stored values in tm1

I had an actuary client who didn't like the leftover rounding bits and bobs - so I just took the small change out of my pocket and offered 1 UK penny as full and final settlement for the discrepancy.
by David Usherwood
Sun May 06, 2018 11:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: In pop up window - After successful login into Cognos BI redirect to c# application
Replies: 7
Views: 793

Re: In pop up window - After successful login into Cognos BI redirect to c# application

Surely you should just implement IBM's approach to using CAM authentication with TM1:
http://www-01.ibm.com/support/docview.w ... wg21958925
I find it pretty messy but it what the vendor documents and supports - and your approach seems even harder work.