TM1 Forum

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

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

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?

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/

I agree. You can do it in PAX though.

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

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

Why not just use PAW?

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

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

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

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

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

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

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

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

EXCEPT should do what you want
http://www.mdxpert.com/Functions/MDXFunction.aspx?f=113
ie (pseudo-code)
except([Top20],[Top10])

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.

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.

TM1 supports the (rarely used) ASCENDANTS function which could help. Alternatively write a recursive TI - but remember that elements can have multiple parents.