TM1 Forum

The TM1 function NOW returns a value that is interpreted as UTC time.
So you need to pass 'Etc/UTC' as the timezone when formatting it.

Passing a different timezone would be useful if, for example, you were parsing timestamps that were not UTC but a local time.

Package extract does not use Package Connector. It builds a report specification and extracts it to CSV as you mentioned.
If it is leaving CSV files lying around after the process executes -- that is a defect.

If you do want to do this I suggest writing a program to do it that uses one of the TM1 APIs. The problems with trying to directly edit the .pro files have been mentioned. In particular, the properties that hold TI script are multi-line properties and you not only need to insert your line, but also ...

TM1 Server is not able to read Excel files. TM1 Performance Modeler / Cognos Insight use Apache POI (http://poi.apache.org/) to read .xls or .xslx files and convert them to CSV. If the Excel data is in crosstab format, the client converts it to a list format. You can also do this in Excel with the T...

At this time the only OLAP source we permit you to extract fact data from is SAP BW. There is special support for efficient extraction from SAP BW. The Cognos BI compatible mode query stack does not have good support for null suppression for a variety of sources. This leads to almost certain failure...

You need to install TM1 Package Connector for BI 8.4 from its separate kit. I think that TM1 9.5.2 was the last TM1 to include an 8.4 TM1 Package Connector kit. You don't need to set anything in tm1s.cfg, Architect and TM1 Server on Windows will pick its location up from an environment variable that...

The main method is using TM1 Package Connector with BEx Queries. It leverages BI packages as the data source, so if you are already using BI it is pretty straightforward.

It seems that the error your are getting is not related to setting prompts -- that appears to be working (see my post in the other thread for a hint on how to find out what the prompt values should look like). You are getting data back but it is complaining that there is no element called "2500...

For CGAddPromptValue(), have a look here: http://www-01.ibm.com/support/docview.wss?uid=swg21614922 What I would recommend is to set prompt values through the UI. Then find the <process-name>.blb file in your TM1 Server data directory. Open it up in Notepad, locate the prompt entry and see how it is...

Cognos Insight has an import wizard that builds TI processes. If you want to go beyond wizard-like imports and do a bunch of custom scripting then you either need to use TM1 Architect or TM1 Performance Modeler, as the full TI editor is not exposed in Cognos Insight.

The message isn't the best. I looked at the code, it looks correct. The TI process type is "Custom Query" but the version reported by TM1 Package Connector on your TM1 Architect system is not high enough to open them. Ensure you have a recent TM1 Package Connector installed on the client t...

This is now a logged defect in TM1 and will be fixed in an upcoming release. When an error occurs a minor error is logged but the ATTRS function does not clean up the stack properly so it returns the third argument to the function (the attribute name) rather than empty string.

I tried a "Recreate" test with two static subsets on the dimension. Where the static subset contained an element not in the new source file it was cleared as expected. But where it contained elements also in the new source file it was preserved -- I don't see the issue you are describing. ...

If you look at the TI script generated from selecting "Recreate" you will see that the DimensionDeleteAllElements TI is used (by TM1 Architect anyways). From the docs: if you use DimensionDeleteAllElements to delete elements, then recreate those elements with the same names in the Metadata...

Definitely TM1 Architect should not be crashing so I would suggest contacting support. It is complaining that the version of TM1 Package Connector being used by TM1 Architect is too old to edit the "Custom Query" type process. Double-check that the TM1_PACKAGE_CONNECTOR environment variabl...

FWIW the maximum number of columns is 530.

Note that TM1 team members are not able to comment on future product releases.....

I have directed various TM1 folks to this thread so you will be heard.

Sorry, it is not possible to dynamically set the credentials for TM1 Package Connector processes. Any BI and/or data source signons are stored in the underlying model and must be edited in TI.

You need the IBM Cognos samples install kit. The data files are still there in 10.1.1.

Transformer does not allow you to import fact data from OLAP sources (except SAP BW). This is because efficiently importing fact data from anything other than a very small cube is not viable through the reporting-based query engine. Transformer does have special query support to efficiently extract ...