TM1 Forum

Hello TM1 community ! Trying to migrate assets via PAW lifecycle management tool. Got this error: "Asset creation is failed" Then tried to perform migration via ctrl + Q + / promoting code book by book, and this works well without any errors... I've thought errors happen because of PAX web...

Finally, it started work properly after I added tm1api.config to C:\ibm\cognos\tm1_64\ bin Before it was only in C:\ibm\cognos\tm1_64\ bin64 folder. It looks quite strange because this is x64 server and installation pack was 64... And if I open windows Start menu => IBM Cognos TM1 - 64 => Architect ...

Thank you all for your answers and suggestions!
I'll try to figure it out and give here feedback. Most likely this is a cert issue.

Hi, folks! I'm diving into tm1 git integration and implementation of ci cd concept to tm1 development. Just have read discussions here, but they seems to be a bit outdated. Since then some things happened, e.g. PAW 2.0.92 released. I want to revive this discussion and aggregate here more useful link...

Is the install set up to use the IBM certs or self certified certs? If it uses self certified the issue it may be the certificates are missing... Here's a link on it... https://www.ibm.com/support/pages/how-configure-custom-ssl-certificates-planning-analytics-20-and-201 I'm wondering if the tm1api....

ascheevel wrote: ↑Tue Feb 20, 2024 8:17 pm Did you populate anything for Admin Host in File->Options within Architect?

No, all fields are empty. So, I expect to see a list of models from the localhost.

Hi everyone! After updating TM1 version to 2.0.9.19 cannot see models list in TM1 Architect. Update was performed without deleting previous version. I've stopped services, backup config files and run installation in the same folder. Models are running and list of models is visible and accesible from...

Hi, the solution is here: https://www.ibm.com/support/pages/paw-error-message-ssl-error-ssl-tlsv1alertprotocolversion-tlsv1-alert-protocol-version-sslc661 The reason is that the new Docker Toolbox version requires a new TLS version. You need to add the line: SET COMPOSE_TLS_VERSION=TLSv1_2 in the St...

Hi Wim I use SubsetCreate function and then SubsetMdxSet twice : SubsetMdxSet ( Dimension, TempName , MDXExpression ) ; SubsetMdxSet ( Dimension, TempName , '' ) ; Just read your articles: https://wimgielis.com/tm1_subsetcreatebymdxandsubsetmdxset_EN.htm and https://www.wimgielis.com/tm1_mdxstatemen...

Hi Steve!

Thank you for testing on your environment!
The trick is that my ti-process accepts such mdx without errors. MDX expression is defined on the prolog tab. Versions of tm1 on which I tried: 2.0.6 and 2.0.9.9

Hi Mark Simple static MDX behaviour looks like this: {[Year].[2021]} return 2021 element {[Year].[blablabla]} return empty set But when we use FILTER function the game changes, expression [Year].[blablabla] in context of "FILTER" function starts working. The problem is that this behaviour ...

Hi Just noticed strange behaviour in working of mdx query. We have "Division" dimension and cube with mapping. Cube name: 08.01.00._Logistics_Map Mapping-cube dimensions: Versions Years CFO_Logistics Divions Meas_Map MDX: {FILTER ( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [Division] ) }, 0) }, [0...

raeldor, hi! Facing similar problem with PAW... But difference is that timeouts happen when TI-process is working, not TM1PY. Rest api queries from PAW to tm1 are waiting this process, so nobody can work at this moment. I noticed that locks do not happen when you open the same cube slice in architec...

Thank you
We have not tried to do this with python. We will try.

Hi, this maybe solution for your case: 1) We have a system parameter cube, where current date is defined by the DAYNO function: ['Current_Day_Number','ME_001'] = S: TRIM(STR(DAYNO(DATE(NOW() , 1)),6,0)); 2) In week dimension there are attributes with start and end date of each week, e.g.: Week: YW_2...

UPD Make PMR to IBM. An answer from IBM: Development has reviewed the details and they are treating connections to ClickHouse as a new feature. A fix for this issue is expected to be made available with PA 2.0.9.12 expected tentatively in early Q1 next year. So we are waiting :) And now, as a work a...

Hi! Already have tried this... When we try to connect to ClickHouse from TI-process Architect reports: "SQL statement error", and at the same moment error appears in tm1server.log But the fact is that SQL Statement is OK. It works successfully from ODBConnect or Excel. We tried default SQL...

Hi Paul, thank you for response.

Tried each of these parameters separately, the same error.

Facing problems with connection Cognos Planning Analytics to database ClickHouse (https://clickhouse.tech/) via ODBC driver. Error in tm1server.log looks like: 10800 [2] ERROR 2021-08-26 14:11:42.175 TM1.SQLAPI 01000[Microsoft][ODBC Driver Manager] Cursor library not used. Load failed We use 64-bit ...