Search found 8 matches

Go to advanced search

by SBrenner
Thu Jan 20, 2011 1:40 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI-Job - access to db connection info
Replies: 1
Views: 2038

Re: TI-Job - access to db connection info

I found it. The data are stored in the internal Turbo Integrator variables. They are (in 9.4.x): DatasourceNameForServer DatasourceASCIIDecimalSeparator DatasourceNameForClient DatasourceASCIIThousandSeparator DataSourceODBOCatalog DatasourceType DatasourceASCIIQuoteCharacter DataSourceODBOConnectio...
by SBrenner
Thu Jan 20, 2011 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI-Job - access to db connection info
Replies: 1
Views: 2038

TI-Job - access to db connection info

Hi, I use a TI process to load data from a RDBMS into a cube. I specified the database in the TI-tab 'Datasource' (the entered data are 'name of data source', 'user', passwort' and the SQL). Is it possible to use these data in my code? Because I have to write back log infos to the same database. I k...
by SBrenner
Wed Nov 03, 2010 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Zero-out data in TM1 cube
Replies: 14
Views: 27613

Re: Zero-out data in TM1 cube

Thanks to all, it works!
These few lines made it possible.

Code: Select all

CubeSetLogChanges('WekoMCP', 0);
ViewExtractSkipCalcsSet ('WekoMCP', 'AllBillData', 1);
ViewZeroOut('MCPWeko', 'AllBillData');
CubeSetLogChanges('WekoMCP', 1);
Greetings

Steve
by SBrenner
Tue Nov 02, 2010 1:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to clear all values
Replies: 7
Views: 7936

How to clear all values

Hi, is there a simple way to clear all values of a dimension entry (without deleting and recreating the dimension entry)? The purpose is that I get billing data fpr two dimension entry of a cube. Because the delivered data are the complete snapshot of the previous day and values may be exists anymor...
by SBrenner
Fri Oct 01, 2010 10:54 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DifferentTimes between server and TM1
Replies: 7
Views: 6732

Re: DifferentTimes between server and TM1

Thanks for the hint. It works as described.
by SBrenner
Thu Sep 30, 2010 12:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: DifferentTimes between server and TM1
Replies: 7
Views: 6732

DifferentTimes between server and TM1

Hello,

after looking for an error I found out, that the timestamp in the log files differs from Windows Server time by two hours.
I'm in the time zone "UTC+1h". Any idea what time zone TM1 has by default and how can I change it?

Kind regards

Steve
by SBrenner
Mon Aug 30, 2010 2:10 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to 'deploy' a TI process
Replies: 2
Views: 2930

How to 'deploy' a TI process

Hi, actual I 'develop' all TI processes on my local server. Is there a (simple and easy) way to deploy the TI process to the production server? My idea is to copy the corresponding '*.pro'-file into the data directory of the production server. But (as far as I know) the server will find the new TI p...
by SBrenner
Mon Jul 26, 2010 4:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Picklist for TI Parameter dialog possible
Replies: 1
Views: 3457

Picklist for TI Parameter dialog possible

Hello everybody, is it possible to use a picklist (or a kind of) for TI parameters? I have to specify a parameter for dimension and the possible values are cryptic strings. My idea ist to provide a selection box (or something similar) with valid values as parameters for the dimension. Any idea how t...

Go to advanced search