Search found 1315 matches

by David Usherwood
Wed Jul 29, 2020 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Separate measure dimension for each cube VS one singular measure dimension for all cubes
Replies: 7
Views: 223

Re: Separate measure dimension for each cube VS one singular measure dimension for all cubes

The drawback is that this dimension now has 100+ elements, for all kinds of special exceptions etc. Cleanup is especially hard (how do you figure out if one element is used in a cube somewhere in a big model?), maintenance is hard, visually it is not appealing at all. Really you don't need anything...
by David Usherwood
Tue Jul 21, 2020 10:32 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SAP BW as a data source in TM1 (PAL) - Cognos Integration server (CIS)
Replies: 3
Views: 856

Re: SAP BW as a data source in TM1 (PAL) - Cognos Integration server (CIS)

Surely you should ask IBM for their roadmap for SAP connectivity :shock: One possible way forward would be to use TM1PY with a Python SAP library eg: https://sap.github.io/PyRFC/ or (from SAP themselves) https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.02/en-US/d12c86af7cb442d1b9f852...
by David Usherwood
Tue Jul 14, 2020 7:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Stack Frame for Function Returns
Replies: 2
Views: 243

Re: TM1 Stack Frame for Function Returns

It's arguably a step too far to go to TM1PY just for a decent set of coding structures, but it certainly makes the experience more enjoyable.
by David Usherwood
Thu Jul 09, 2020 9:19 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW information for PAX
Replies: 10
Views: 359

Re: PAW information for PAX

Perhaps Marius would be interested in adding it to TM1PY in his spare time... :)
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: 9
Views: 287

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: 386

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: 386

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: 760

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: 556

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: 556

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: 556

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: 1520

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: 840

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: 1338

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: 1338

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: 840

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: 840

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: 1520

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: 1520

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: 1520

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