Search found 20 matches

by Drg
Mon Jul 17, 2017 12:15 pm
Forum: Cognos TM1
Topic: TM1 Java API - pull data from view?
Replies: 14
Views: 4801

Re: TM1 Java API - pull data from view?

kjanssen wrote:
Mon Apr 13, 2015 2:58 pm
ok i found that i have to use view.getColumnSubset(i) & view.getRowSubset(i) and then use thier getElement()
Maybe y read this.

You were able to return the tuple using the method getArrayAxisTuple??? :oops:
by Drg
Sun Jul 16, 2017 6:13 am
Forum: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

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:49 am
Forum: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

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

UP
by Drg
Fri Jul 14, 2017 10:48 am
Forum: Cognos TM1
Topic: TM1 Object dependency walker- get list of all dependent objects
Replies: 4
Views: 457

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: Cognos TM1
Topic: Is it still worth working on a cube auto promotion tool?
Replies: 11
Views: 695

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: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

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: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

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: Cognos TM1
Topic: JAVA API get view array with header???
Replies: 6
Views: 562

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 view TM1View ...
by Drg
Thu Apr 27, 2017 8:27 am
Forum: Cognos TM1
Topic: Replication:transaction log file
Replies: 6
Views: 401

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: Cognos TM1
Topic: Replication:transaction log file
Replies: 6
Views: 401

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: Cognos TM1
Topic: TM1 10.2.2 FP6 IF1 crashing without log entries
Replies: 10
Views: 637

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: Cognos TM1
Topic: What is new in TM1 ?
Replies: 3
Views: 318

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 know if all ...
by Drg
Fri Apr 21, 2017 5:51 am
Forum: Cognos TM1
Topic: TM1 Java API - open connection error
Replies: 8
Views: 905

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: Cognos TM1
Topic: TM1 Java API - open connection error
Replies: 8
Views: 905

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: Cognos TM1
Topic: SQL Query Error On TI Prolog tab
Replies: 4
Views: 499

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: Cognos TM1
Topic: RunTI.exe Serverconnectionfailed
Replies: 12
Views: 783

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: Cognos TM1
Topic: Request for Help, TM1 10.2.2 Architect does noch connect to all servers
Replies: 6
Views: 621

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: Cognos TM1
Topic: What is new in TM1 ?
Replies: 3
Views: 318

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: 4992

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: 4992

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 "admin" -pwd "apple" -process...