Search found 117 matches

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

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

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

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

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

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replication:transaction log file
Replies: 6
Views: 1700

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

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

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

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Java API - open connection error
Replies: 8
Views: 2651

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

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

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

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

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

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

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

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...