Search found 1345 matches

by David Usherwood
Wed Jul 12, 2023 7:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Syntax for deleting records from table using sql inside of TI job
Replies: 2
Views: 706

Re: Syntax for deleting records from table using sql inside of TI job

TM1 doesn't require special SQL syntax - it just sends what you give it.

The best way to debug ODBCOutput SQL statements is to replace
ODBCOutput(Source,sSQL);
by
AsciiOutput('test.csv',sSQL);
and inspect the text you are trying to send. Very likely you haven't got the quotes right.
by David Usherwood
Mon Apr 10, 2023 11:35 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Perspectives Excel 64 bit slice crash
Replies: 8
Views: 1342

Re: Perspectives Excel 64 bit slice crash

(windows 11 is not supported for perspectives) I did a light test running Windows 11 under VMWare, bypassing the silly install restrictions, and all server and client components worked. For PAFe you have to tweak the Edge settings to support 'IE Mode'. Doubt IBM will take support calls on this topi...
by David Usherwood
Thu Mar 02, 2023 11:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need Help with a feeder
Replies: 9
Views: 1335

Re: Need Help with a feeder

As David Usherwood is now enjoying retirement I can only repeat the point he has made countless times on this forum; the purpose of feeding is for consolidation ergo if a rule calculated measure doesn't need to consolidate then don't feed it. Rates are such a measure, you shouldn't feed rates. Than...
by David Usherwood
Tue Feb 28, 2023 4:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Migration from Perspectives to PAX
Replies: 12
Views: 3187

Re: Migration from Perspectives to PAX

DBRW and DBR are treated the same in PAfE That's interesting... I use a mix of DBR and DBRW when I need to ensure that (eg) picklists are populated (DBR) before data is retrieved/updated (DBRW). The last time I did this was with PAFe and the behaviour (which I needed) was as in the days of yore (Pe...
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: 5
Views: 4696

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

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: 8
Views: 13444

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

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

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

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

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

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

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

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

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

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

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

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

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

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.