Search found 159 matches

by Drg
Sun Jul 16, 2017 6:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA API get view array with header???
Replies: 6
Views: 3894

Re: JAVA API get view array with header???

This is a pretty obscure question and I'm not surprised no one has answered. I've never even looked at the Java API and quite frankly, don't know why I ever would unless I was trying to create some third-party tool to try and sell to the TM1 community. Bumping it up to the top each day is not going...
by Drg
Fri Jul 14, 2017 10:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Object dependency walker- get list of all dependent objects
Replies: 4
Views: 4008

Re: TM1 Object dependency walker- get list of all dependent objects

I do not think that there are any real means to track the following dependencies(With the exception of staff resources that are not represented in any SDK): Cube A DB( DB('Get cube for rule feeders',!a,!b,!c) , !a ,!b ,!c , !d , if(!a@='true' ,'total' ,'subtotal') , SUBST( ATTRS( 'MEASURE' , !e , DB...
by Drg
Fri Jul 14, 2017 10:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is it still worth working on a cube auto promotion tool?
Replies: 11
Views: 8359

Re: Is it still worth working on a cube auto promotion tool?

Hi. nice screenshot and cool idea.

same function places in perfomance modeler.

for models crated in architect i use powershel script.Wich compare each files in two models and generate object to copy(but this is no good solution anyone).
by Drg
Wed Jul 12, 2017 6:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA API get view array with header???
Replies: 6
Views: 3894

Re: JAVA API get view array with header???

Wim Gielis wrote:Personally I haven't used that API yet so it would be difficult to give assistance.
IBM even says that it is part of the SDK(rest api, java extension). So I suspect that sooner or later it will remain a part of Performance modeler. :evil:
by Drg
Tue Jul 11, 2017 6:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA API get view array with header???
Replies: 6
Views: 3894

Re: JAVA API get view array with header???

No ideas?
Am I the only one who has faced such a challenge?
by Drg
Mon Jul 10, 2017 3:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: JAVA API get view array with header???
Replies: 6
Views: 3894

JAVA API get view array with header???

Hi guy's tell me how to build a view with setSuppressZeroes(true) and get coordinates of the cell? Or the resultant arrays along the coordinate axes? Example: //Create connection ... //get cube TM1Cube Cube =ts.getCube("CUBENAME"); ... //loop dims, create N elements subset ... //create vie...
by Drg
Thu Apr 27, 2017 8:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 5262

Re: Replication:transaction log file

Most of your questions are answered in the documentation: https://www.ibm.com/support/knowledgecenter/SS9RXT_10.2.2/com.ibm.swg.ba.cognos.tm1_op.10.2.2.doc/c_synchronizationprocess_n1106bb.html#SynchronizationProcess_N1106BB. Traversal of multiple tx log files is handled automatically-- doesn't mat...
by Drg
Wed Apr 26, 2017 12:50 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 5262

Replication:transaction log file

Hi to all. Does anyone have any knowledge of how replication happens ?? How does TM1 know which transaction log(tm1s[TIMESTMP]) file is being replicated for replication? What happens if replication fails, but a new transaction log(tm1s[TIMESTMP]) file has already been created? What happens if a part...
by Drg
Mon Apr 24, 2017 6:26 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 10.2.2 FP6 IF1 crashing without log entries
Replies: 10
Views: 7728

Re: TM1 10.2.2 FP6 IF1 crashing without log entries

maybe you use empty view in ti process ? I have this problem some times when use mtq=-1 or >1
http://www.tm1forum.com/viewtopic.php?t=12634
by Drg
Fri Apr 21, 2017 5:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is new in TM1 ?
Replies: 3
Views: 2906

Re: What is new in TM1 ?

Thank you for your answer, I don't remember the last version :(, It was from 3 years ago, it was seems very legacy. And I was working on the "Architect" to create the dimensions, cubes, rules, TI processes, manage security and everything. and there was a product called TM1 web. I don't kn...
by Drg
Fri Apr 21, 2017 5:51 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java API - open connection error
Replies: 8
Views: 6911

Re: TM1 Java API - open connection error

kjanssen wrote:Hey Drg,

unfortunately this is not possible. As the project using the TM1 API requires Java8 and the JRE provided by TM1 is only Java7.
After FIXPACK 4 ibm change core JRE.
Maybe you help downgrade tm1 to 10.2.2 fp4 :o
by Drg
Thu Apr 20, 2017 12:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java API - open connection error
Replies: 8
Views: 6911

Re: TM1 Java API - open connection error

HEY MAN use tm1 JRE in your eclips project C:\Program Files\ibm\cognos\tm1_64\bin\jre\7.0 C:\Program Files\ibm\cognos\tm1_64\bin64\jre\7.0 JUST copy this folder on your comp append new envierment varible(path) on your computer or in your eclips project > property > java build path > java system libr...
by Drg
Thu Apr 20, 2017 12:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQL Query Error On TI Prolog tab
Replies: 4
Views: 4095

Re: SQL Query Error On TI Prolog tab

hey how DB you use???

maybe you need more quotes ' or "


sSQLQry = 'Select substr(clm1,1,2) ||''*'' as clm1,
,clm2
From Tbl
where clm1= ''1'' '
OR
sSQLQry = 'Select substr(clm1,1,2) ||''*'' as clm1,
,clm2
From Tbl
where clm1= "1" '
by Drg
Thu Apr 20, 2017 11:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RunTI.exe Serverconnectionfailed
Replies: 12
Views: 8434

Re: RunTI.exe Serverconnectionfailed

try "apple" in pwd parms and try copy paste use architect to connect to server ans do not use localhost use short(wide) domain name or ip
by Drg
Thu Apr 20, 2017 11:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Request for Help, TM1 10.2.2 Architect does noch connect to all servers
Replies: 6
Views: 4728

Re: Request for Help, TM1 10.2.2 Architect does noch connect to all servers

architect before fix pack 5
do not show instance of service fp6 and higher...
by Drg
Thu Apr 20, 2017 11:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is new in TM1 ?
Replies: 3
Views: 2906

Re: What is new in TM1 ?

Your last Version of tm1? :?
basicaly no more new. ibm some times chose wrong ways in develop product...
by Drg
Mon Apr 10, 2017 3:11 pm
Forum: Useful code, tips and tricks
Topic: TurboIntegrator User Variables
Replies: 5
Views: 24313

Re: TurboIntegrator User Variables

Simply solution:
:P :P :P :P :P :P :P
Thread=10;
SCRIPT='powershell -command "& { while((get-process | Where-Object name -EQ "tm1runti").count -gt '|NUMBERTOSTRING(Thread)|' ){sleep -Seconds 1} } "';
ExecuteCommand(SCRIPT, 1);
by Drg
Sat Apr 08, 2017 4:31 pm
Forum: Useful code, tips and tricks
Topic: TurboIntegrator User Variables
Replies: 5
Views: 24313

Re: TurboIntegrator User Variables

Sorry that I raise old posts Tell me whether it is possible to avoid the isolation level by using global variables? Example: Process_1: get one variable n n=n+1; #run second process no wait execution ExecuteCommand('"..tm1runti.exe" -adminhost "hst" -server "INst" -user...