TM1 Forum

Working with TM1PY I have found the Rest API to honour security pretty well. Can you check your scripts to see whether you are using admin access? If you are not, please raise a ticket with IBM.

I'm intrigued to know whether dropping EXE files onto the TM1 cloud environment is formally permitted by IBM's SaaS Ts&Cs?

There may be some benefit in using the Credential Store over encrypting a file on the disc - but not much, and as you say the PS-based approach has less components. Good to see that being published - I certainly wasn't aware of it.

In order to boost the adoption of tm1py and Python in cooperation with TM1, maybe it would be good to post some parts of what you used in the “Useful code, tips and tricks” subforum. Of course, anonymous data and names and such. I've discussed this somewhat with Mariusz and I believe his initial pr...

My take on your questions: 1. Why use python with TM1? To do something you can't do with the builtin tools 2. What are the benefits we get which we are unable to get so far with existing TM1 tools? Integration: With Python libraries for functionality which is not in TM1 - eg IRR, stats With other pr...

Interesting alternative. Good for PA SaaS as Powershell is available but Python would not normally be.
I'm not concerned about AsciiOutput as the aim is not to protect it from devs/admins, but from users.

This is not a full Blueprint-ey writeup, but it may be of interest. A recent thread on Another TM1 Forum discussed the issues with using ODBCOpen to connect to external databases. I suggested there that TM1PY (of course) could be of use - since I saw that Mariusz recently introduced storing TM1 pass...

upload it to the tm1 server and I've been able to download 7zip on the server that has Architect and Perspectives Without being familiar with the IBM SaaS Ts & Cs, I think it likely that dropping random EXEs into the instance would not comply with them. (I used to be a systems auditor before I ...

Indeed. But on IBM SaaS, you have to raise a ticket to get utilities like 7Zip installed. I don't know if anybody's tried, but it is good to know that you can do backups without anything extra.

Alternatively you can use Powershell Compress-Archive cmdlet. All thee are available on Windows Server as long as PowerShell is not disabled. I recently tested this out on the IBM SaaS. Powershell is enabled (bear in mind that the remote session you log into is not where TM1/PA itself runs) and it ...

Why not just use tm1py to do the transfer? It's a pretty impressive piece of work and well looked after (last update 12 May 2020). I'm just building an interface for a client to one of the cloud ERP packages, pulling ledger balances and transactions straight back to TM1, and it's working well.

As per my earlier post your users will be issued IBM IDs and use the CAM in place on SaaS. You can mirror the on premise Cognos groups on SaaS but I believe you have to do this via a support ticket. I don't believe IBM offers any way to connect the two - but asking them would be sensible.

I would tend to look at the IsDisabled property of the }ClientProperties cube. Yes that too. Although this trick is even newer. I don't know when the IsDisabled property was actually introduced to v11 but it is as yet undocumented. Unless you have access to some super top secret stash of IBM docume...

Performance Modeler was built by the Cognos EP team as a 'skin' over TM1, to make TM1 more accessible to EP-ers. It was not successful. However there remain a small set of tasks for which it is either required or very helpful: Required Creating metric content (note that the generated rules are among...

I recall building a routine which would place a user into the Admin group but did not require admin access to run. To test security I would mimic the group membership I was testing then take myself out of admin (manually) - then run the TI to restore admin. Very useful when working with CAM, especia...

They have just published the documentation for the worksheet function on the page for the rules function.

Makes sense - not sense as in sensible, but the syntax looked really silly.

Looking at IBM's own documentation: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_wrk_elementfirst.html For this and some (but not all :roll: ) of the new hierarchy functions, you need to specify the server name: ElementFirst("plan...

What about HierarchySubsetDeleteAllElements? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_hierarchysubsetdeleteallelements.html Although it is clearly related to the new (unfinished :roll: ) hierarchy functions (you can also tel...

What about HierarchySubsetDeleteAllElements? https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_ref.2.0.0.doc/r_tm1_ref_tifun_hierarchysubsetdeleteallelements.html Although it is clearly related to the new (unfinished :roll: ) hierarchy functions (you can also tell...

Look at SubsetMDXSet.