Search found 1341 matches

by David Usherwood
Mon Nov 28, 2022 11:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Requesting Assistance - ODBC connections with expiring Tokens
Replies: 4
Views: 809

Re: Requesting Assistance - ODBC connections with expiring Tokens

I have the CFO and the board very keen to know why all our new DataLake data is not yet in TM1. ... I convince the network security team to let me have an oAuth token that does not expire and I save it permanently into my ODBC. This is the traditional way TM1 works. This is totally possible for the...
by David Usherwood
Sat Nov 19, 2022 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: convert string to code TM1
Replies: 3
Views: 177

Re: convert string to code TM1

That's the easy bit - because the cube name is just a string:

Code: Select all

CubeName ='XXX';
cellputn(cubename, v1,v2....vnn);
However I think you are hoping to build a complete cellputn statement. That's not possible in pure TI code. You could do it in TM1PY using tm1.processes.update_or_create though.
by David Usherwood
Mon Oct 31, 2022 12:34 pm
Forum: Useful code, tips and tricks
Topic: Quickly promote or copy a PAW book
Replies: 7
Views: 1795

Re: Quickly promote or copy a PAW book

I've just done some testing of this. My findings so for are that it works for pointing an existing briefing (or copy) to the same cube on another server, but it does not work for pointing an existing briefing (or copy) to a second cube (with the same dimensions and view name). Clicking the Settings ...
by David Usherwood
Fri Feb 25, 2022 11:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What do IBM still have to do to replace Perspectives with PAW and PAX
Replies: 11
Views: 2253

Re: What do IBM still have to do to replace Perspectives with PAW and PAX

Just heard a rumour IBM plan to deprecate/not support Perspectives in 2022 Q3. I think some knickers have become a little twisted here. Based on IBM's monthly AMAs, the current release stream (11++) will continue to support the old, functional API and the old, functional client tools (known and lov...
by David Usherwood
Sat Nov 27, 2021 6:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How is }ElementSecurity_dimensionname create?
Replies: 4
Views: 16514

Re: How is }ElementSecurity_dimensionname create?

Assigning security to one or more elements will create the dimension.
by David Usherwood
Tue Nov 16, 2021 10:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to iterate over odbc input columns?
Replies: 4
Views: 9952

Re: How to iterate over odbc input columns?

The other approach which I have found useful is to use UNPIVOT in the SQL. https://docs.microsoft.com/en-us/sql/t-sql/queries/from-using-pivot-and-unpivot?view=sql-server-ver15 (Other RDBMS's are available - and a number of those also support UNPIVOT :) ) This turns columns into rows, allowing you t...
by David Usherwood
Mon Nov 15, 2021 3:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cognos PA can not connect to ClickHouse via ODBC
Replies: 9
Views: 19628

Re: Cognos PA can not connect to ClickHouse via ODBC

The Wikipedia writeup talks about an extended SQL-like language that includes arrays and nested data structures, approximate and URI functions, and the availability to connect an external key-value store. which suggests that it wouldn't work like a standard RDBMS query. The same writeup mentions a P...
by David Usherwood
Wed Nov 10, 2021 3:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI View Execution vs MDX View
Replies: 13
Views: 29933

Re: TI View Execution vs MDX View

In my case im trying to use TM1py to execute the mdx which doesn't leave me with an option for ViewExtractSkipZeroesSet (At least not with the ExecutePowerBI function. I may try and play around with some of the other TM1py execute functions to see if anything helps. The best case would be to find a...
by David Usherwood
Tue Sep 28, 2021 2:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading data in a procedure
Replies: 6
Views: 4408

Re: Spreading data in a procedure

TM1Py could likely do this via procedure, also, but IBM won't install that package on cloud-based servers.
TM1Py talks to the TM1 server via the RestAPI - it does not have to be installed on the IBM cloud. Install it on a server (or client) over which you have control.
by David Usherwood
Mon Sep 27, 2021 7:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Spreading data in a procedure
Replies: 6
Views: 4408

Re: Spreading data in a procedure

I looked into that particular function but only it spreads across only one axis
Just tested with Sdata and confirmed CellPutProportionalSpread works multidimensionally.
by David Usherwood
Thu Sep 02, 2021 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pass a dimensional element from a TM1RPTROW row to a parameter in a TI process
Replies: 6
Views: 3986

Re: Pass a dimensional element from a TM1RPTROW row to a parameter in a TI process

I use an approach which isn't as slick but works in Excel and Web: Create a range over the Active Form column you want to select from Use Data Validation to point a 'selector' cell to that range You can then select one of the elements in the column and pass it to your Action Button Key requirement i...
by David Usherwood
Tue May 18, 2021 10:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View in cube does not exist error
Replies: 8
Views: 4532

Re: View in cube does not exist error

I recall that views created in PAW are MDX views (extension .xbv) and these are not visible in Perspectives/Architect.
by David Usherwood
Fri Apr 30, 2021 8:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Deleting the Admin account
Replies: 6
Views: 4039

Re: Deleting the Admin account

I can't recall the specifics, but I do remember writing a TI to delete a set of clients before adding them back and I recall that the server wouldn't let me delete Admin. Try it - perhaps not on a production server :lol:
by David Usherwood
Thu Apr 22, 2021 12:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cube last data pull
Replies: 14
Views: 6394

Re: Cube last data pull

I'm not aware of any way of detecting this. The traditional, slightly naughty, approach is to remove access to the cubes in question and wait for someone to whinge.... 8-)
by David Usherwood
Fri Mar 26, 2021 10:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: citrix crashes with ISB view
Replies: 4
Views: 2844

Re: citrix crashes with ISB view

Looking back I believe the ISB has not been supported since TM1 10.x:
viewtopic.php?f=3&t=2119
Quite surprising to hear it still works sometimes!
by David Usherwood
Fri Mar 19, 2021 9:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX custom reports
Replies: 4
Views: 2287

Re: PAX custom reports

To be clear, the totaling happens on the server, using the rollups in your dimension - so if new elements are properly charted when they are added, the total will be correct. The 'custom' report retrieves values against the dimension element.
by David Usherwood
Fri Feb 05, 2021 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API - Pull data for data warehouse
Replies: 5
Views: 2465

Re: REST API - Pull data for data warehouse

TM1PY is hands down the best way to go. But if you are insistent on doing it by hand then you could have a dig round the TM1PY library to find out what that does to format the response. Watch out for volume issues - I've seen writeups by Paul Simon inter alia that Web Services aren't good for bulk d...
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: 4385

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, a...
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: 5192

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

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()} ) }