Search found 1320 matches

by David Usherwood
Fri Oct 02, 2020 12:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unexpected behavior of consolidations
Replies: 8
Views: 282

Re: Unexpected behavior of consolidations

Easily fixed - use weightings. This will also be faster. Adam is right that c level rules do not consolidate onwards.
by David Usherwood
Wed Sep 09, 2020 9:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation in Centos Linux or Windows Server 2012
Replies: 11
Views: 399

Re: PAW installation in Centos Linux or Windows Server 2012

Apologies - I was responding to declanr's post about the clashing use of 9510 and the totally unnecessary, untested split of TM1Web for a release that was, amazingly, described as Long Term Support :)
by David Usherwood
Tue Sep 08, 2020 4:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation in Centos Linux or Windows Server 2012
Replies: 11
Views: 399

Re: PAW installation in Centos Linux or Windows Server 2012

Perhaps IBM could sort out the dreadful mess they have made of the latest install? LTS version, my <unprintable>
by David Usherwood
Tue Sep 08, 2020 11:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW installation in Centos Linux or Windows Server 2012
Replies: 11
Views: 399

Re: PAW installation in Centos Linux or Windows Server 2012

A possibility - I got caught out getting Centos 8 from Centos themselves - but it turns out that only Centos 7 is supported. Sure this is documented somewhere :roll: I have run PAW on Centos 7 within Windows 10 Pro using both VMWare (Player) and (briefly - not a good experience) Hyper-V, connecting ...
by David Usherwood
Thu Aug 20, 2020 7:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: ODBC connection to EXCEL
Replies: 4
Views: 460

Re: ODBC connection to EXCEL

Perhaps look at this?
https://code.cubewise.com/odbc-connect
Also, I recall this from earlier releases. Can't say whether it survived in TM1 11/PA:
https://www.ibm.com/support/knowledgece ... proxy.html
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: 555

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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