https://community.ibm.com/community/use ... 4eda43146bTo improve the user experience for our cloud clients
Search found 1347 matches
- Mon Apr 29, 2024 10:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Architect/Perspectives to be removed from PAoC
- Replies: 3
- Views: 581
Architect/Perspectives to be removed from PAoC
- Fri Apr 19, 2024 4:30 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Methods for Inputting Data into TM1 Cube
- Replies: 12
- Views: 1278
Re: Methods for Inputting Data into TM1 Cube
As an alternative, you could open the file in Excel and add DBSW formulae down the rows to send the data to the cube. Not the neatest, but TM1 had this in version 6 before Turbo Integrator was a gleam in Manny Perez' eye.
- 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: 747
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.
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.
- 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: 1439
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...
- Thu Mar 02, 2023 11:16 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need Help with a feeder
- Replies: 9
- Views: 1433
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...
- Tue Feb 28, 2023 4:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Migration from Perspectives to PAX
- Replies: 12
- Views: 3354
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...
- 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: 5523
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...
- Sat Nov 19, 2022 2:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: convert string to code TM1
- Replies: 3
- Views: 907
Re: convert string to code TM1
That's the easy bit - because the cube name is just a string:
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.
Code: Select all
CubeName ='XXX';
cellputn(cubename, v1,v2....vnn);
- Mon Oct 31, 2022 12:34 pm
- Forum: Useful code, tips and tricks
- Topic: Quickly promote or copy a PAW book
- Replies: 8
- Views: 14775
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 ...
- 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: 4209
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...
- Sat Nov 27, 2021 6:21 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How is }ElementSecurity_dimensionname create?
- Replies: 4
- Views: 16966
Re: How is }ElementSecurity_dimensionname create?
Assigning security to one or more elements will create the dimension.
- 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: 10403
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...
- 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: 20689
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...
- 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: 31741
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...
- Tue Sep 28, 2021 2:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spreading data in a procedure
- Replies: 6
- Views: 4997
Re: Spreading data in a procedure
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.TM1Py could likely do this via procedure, also, but IBM won't install that package on cloud-based servers.
- Mon Sep 27, 2021 7:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Spreading data in a procedure
- Replies: 6
- Views: 4997
Re: Spreading data in a procedure
Just tested with Sdata and confirmed CellPutProportionalSpread works multidimensionally.I looked into that particular function but only it spreads across only one axis
- 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: 4453
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...
- 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: 6123
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.
- Fri Apr 30, 2021 8:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Deleting the Admin account
- Replies: 6
- Views: 4593
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
- Thu Apr 22, 2021 12:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Cube last data pull
- Replies: 14
- Views: 7744
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....