Search found 1311 matches

by David Usherwood
Fri Jul 03, 2020 1:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Turbo Integrator - Data tab dont run?
Replies: 2
Views: 43

Re: Turbo Integrator - Data tab dont run?

Most likely you have selected to skip consolidated elements but the selections in one or more of your dimensions have no N level elements. Easiest way to check this is to export the view to a file. It will have a cma extension but is in fact a csv file.
by David Usherwood
Fri Jul 03, 2020 6:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 166

Re: SQL Query Length Limit for TI

tomok wrote: ↑Thu Jul 02, 2020 1:42 pm HighKeys wrote: ↑Thu Jul 02, 2020 12:15 pm why you dont create a SQL View and just import the View? Better yet, use a stored procedure. Each individual INSERT INTO statement is going to have to be compiled before execution. Depending on how often you call the ...
by David Usherwood
Thu Jul 02, 2020 9:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Length Limit for TI
Replies: 10
Views: 166

Re: SQL Query Length Limit for TI

Per this thread, a TM1 string cannot be > 32k so that would limit an ODBCOutput statement.
https://www.tm1forum.com/viewtopic.php? ... ize#p70027
by David Usherwood
Wed Jul 01, 2020 12:58 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Experience with PAW and its future prospects
Replies: 12
Views: 481

Re: Experience with PAW and its future prospects

Spending some time developing systems with 'another' cube engine which mandates web for development, I worked round the issues by opening multiple connections in different tabs which I could tear off and rearrange. Main gotcha was that changes in one session would not show up in another without doin...
by David Usherwood
Tue Jun 23, 2020 2:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security issue with TM1 REST API
Replies: 7
Views: 418

Re: Security issue with TM1 REST API

I've tested further at Steve Rowe's suggestion and my non-admin user can see and cancel their threads. (Updated - I was cancelling an Architect session - no change to the open view but the user had been logged out.) (Further update) If the (non-Admin) user is in the OperationsAdmin group they can ca...
by David Usherwood
Tue Jun 23, 2020 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security issue with TM1 REST API
Replies: 7
Views: 418

Re: Security issue with TM1 REST API

Suggest you recheck your script. I have just reproduced the situation with TM1PY and a non admin user can only see their own threads. There is a quirk in that the Github release of tm1py has a function 'cancel_all_running_threads' which is not in the release (py -m pip install) version - but looking...
by David Usherwood
Tue Jun 23, 2020 9:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Security issue with TM1 REST API
Replies: 7
Views: 418

Re: Security issue with TM1 REST API

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.
by David Usherwood
Fri Jun 19, 2020 9:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1129

Re: Local Backup

I'm intrigued to know whether dropping EXE files onto the TM1 cloud environment is formally permitted by IBM's SaaS Ts&Cs?
by David Usherwood
Wed Jun 17, 2020 10:51 am
Forum: Useful code, tips and tricks
Topic: Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords
Replies: 4
Views: 658

Re: Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords

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.
by David Usherwood
Mon Jun 15, 2020 10:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py and python integration with TM1
Replies: 13
Views: 1073

Re: TM1py and python integration with TM1

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...
by David Usherwood
Mon Jun 15, 2020 8:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1py and python integration with TM1
Replies: 13
Views: 1073

Re: TM1py and python integration with TM1

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...
by David Usherwood
Wed Jun 10, 2020 7:59 am
Forum: Useful code, tips and tricks
Topic: Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords
Replies: 4
Views: 658

Re: Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords

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.
by David Usherwood
Tue Jun 09, 2020 10:19 am
Forum: Useful code, tips and tricks
Topic: Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords
Replies: 4
Views: 658

Using TM1PY with the Windows Credential Manager to secure ODBCOpen passwords

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...
by David Usherwood
Mon Jun 01, 2020 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1129

Re: Local Backup

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 foun...
by David Usherwood
Sun May 31, 2020 4:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1129

Re: Local Backup

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.
by David Usherwood
Wed May 27, 2020 9:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Local Backup
Replies: 22
Views: 1129

Re: Local Backup

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 ...
by David Usherwood
Thu May 14, 2020 4:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Variables info missing when deploy a TI process
Replies: 4
Views: 325

Re: REST API: Variables info missing when deploy a TI process

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.
by David Usherwood
Sun May 03, 2020 7:39 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect the ODBC on -premise with the Planning Analytics on Cloud
Replies: 7
Views: 853

Re: Connect the ODBC on -premise with the Planning Analytics on Cloud

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.
by David Usherwood
Fri Apr 24, 2020 11:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1+CAM Security: see what any user would see
Replies: 17
Views: 1544

Re: TM1+CAM Security: see what any user would see

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...
by David Usherwood
Fri Apr 24, 2020 11:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Suggestion - TM1 Performance Modeler or Planning Analytics
Replies: 8
Views: 2009

Re: Need Suggestion - TM1 Performance Modeler or Planning Analytics

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