Search found 1324 matches

by David Usherwood
Thu Dec 10, 2020 4:55 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Will IBM ever convert Perspectives to use the Rest API?
Replies: 6
Views: 489

Re: Will IBM ever convert Perspectives to use the Rest API?

John Hammond wrote: ↑Wed Dec 09, 2020 10:01 pm In retrospect, I suppose, the PM path of revolution may not have been correct. That's like saying "The charge of the Light Brigade may not in fact have been a tactically prudent exercise". Although my great-grandfather fought in the Crimea, and quotes ...
by David Usherwood
Tue Dec 01, 2020 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Servers with TBs of Memory
Replies: 13
Views: 881

Re: TM1 Servers with TBs of Memory

This thread triggered some memories and I went looking back in our records. Found a response from James Fleming at Applix dated 15 Jul 2005 saying that (at the time) 64 bit Windows supported 16 TB. Also found a more recent post https://www.compuram.de/blog/en/how-much-ram-can-be-addressed-under-the-...
by David Usherwood
Tue Nov 24, 2020 10:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove duplicate elements from the subset
Replies: 7
Views: 506

Re: Remove duplicate elements from the subset

I recall that Hierarchy Sort has the useful side effect of removing duplicates - and it is supported by the MDX Record Expression feature:

Code: Select all

{ HIERARCHIZE( {TM1SubsetBasis()} ) }
by David Usherwood
Mon Nov 09, 2020 9:46 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Annotation Cube: Loading new records
Replies: 7
Views: 734

Re: Annotation Cube: Loading new records

I've done little or nothing with annotations - but I see that TM1PY supports them and the methods look quite straightforward:
  • create(annotation)
  • delete(annotation_id)
  • get(annotation_id)
  • get_all(cube_name)
  • update(annotation)
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: 540

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

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

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

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

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

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

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

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

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

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

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

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: 13
Views: 1892

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

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

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

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.