Search found 62 matches

by Drg
Wed Oct 18, 2017 10:54 am
Forum: Cognos TM1
Topic: TM1 instances are running in cognos configuration but not appearing in TM1 architect.
Replies: 3
Views: 186

Re: TM1 instances are running in cognos configuration but not appearing in TM1 architect.

also check you architect version and tm1 version.

architect <= 10.2.2 fp4 not see tm1 instance run on 10.2.2 fp4>
by Drg
Mon Oct 09, 2017 9:21 am
Forum: Cognos TM1
Topic: Performance of Architect Vs Perspectives
Replies: 14
Views: 424

Re: Performance of Architect Vs Perspectives

I agree with my colleagues and add my assumptions.
ARCHTECT and PERSPECTIVE are launched from one machine that is not a server?
If this is a server from which directories are the clients running?
you use VMM VMT ?
Do your tests have a chaotic startup order?
by Drg
Mon Oct 09, 2017 8:59 am
Forum: Cognos TM1
Topic: Improve TI process time for cubes with heavy rules
Replies: 11
Views: 455

Re: Improve TI process time for cubes with heavy rules

If you Output generate many data and cube receiver not final in chain calcultion. You need find the narrow neck of your process: long calc or long insert. based on the result of the analysis, I can assume that you have further logic for calculating the data, and the TI side-by-side starts will not g...
by Drg
Mon Oct 09, 2017 8:41 am
Forum: Cognos TM1
Topic: Need help to create TI process to copy data
Replies: 5
Views: 293

Re: Need help to create TI process to copy data

emmm... Use

Code: Select all

while 
copy data from one month to other month 
end;
maybe should use bedrock process !
by Drg
Fri Sep 29, 2017 7:25 am
Forum: Cognos TM1
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 462

Re: Dynamic subset based on a cube value, with another dimension

You can't do this. If you need filter dimension differently in different cube and use Only one MDX Subset? you need in each cube have system measure element containing dimension for filter. also need store(maybe as attributes dimension Product) filter mask for each Department(attr1...attrN). I'm sti...
by Drg
Mon Sep 25, 2017 8:06 am
Forum: Cognos TM1
Topic: ExecuteCommand on SFTP file transfer
Replies: 5
Views: 275

Re: ExecuteCommand on SFTP file transfer

fleaster wrote:
Tue Sep 19, 2017 11:24 pm
Thanks for the responses... yes, I have run it via direct logon to the server and it works perfectly... might have a look into Powershell, otherwise am not sure what else can be tried :(

M.
Use double quotes!!!
by Drg
Mon Sep 25, 2017 7:40 am
Forum: Cognos TM1
Topic: How to Feed this Rule ??? pls help!!!
Replies: 3
Views: 213

Re: How to Feed this Rule ??? pls help!!!

In fact, at all, the curious question is for sure everyone has their own experience in fusion from cubes of smaller dimension to larger, would it be interesting to hear from people with experience how they solve these tasks? Ugly variant(to working this rules need use ti functions cubeprocessfeeders...
by Drg
Mon Sep 25, 2017 7:19 am
Forum: Cognos TM1
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 478

Re: Rules Created by Links are not allowing us to copy data from source version to target version

Hi Wim, Thank you for your reply. i don't think so,because our TI is able to copy data from current version to final version for some of the cells .please see the attachment.Highlighted cell is not transferring data. Regards, Rajesh Dayaneni You can test the work of your code yourself by asking the...
by Drg
Mon Sep 25, 2017 7:05 am
Forum: Cognos TM1
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 10
Views: 512

Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?

My process use queCube to create logs wich view created(or need be create run ti proc) and 2 level process(es) read this cube(but this no good idea to store large text fields). my logic looks like: p1 prepare data (i use savecubedata to save my prepared view and subsets ) p1 log runti params to self...
by Drg
Fri Sep 22, 2017 6:26 am
Forum: Cognos TM1
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 10
Views: 512

Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?

Yes, i am using some global parameters and attributes in the child processes that run with TM1RunTi. but the case is when i send 12 processes for a year i see in logfile only 11 executions... why this happens? i have verified the MaximumPorts parameter in }CLientProporties control cube and is set t...
by Drg
Wed Sep 20, 2017 7:15 am
Forum: Cognos TM1
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 462

Re: Dynamic subset based on a cube value, with another dimension

Thanks Drg, This will not help. The problem is because "dimension in a mapping cube" and "dimension in context of budget cube view" are equal, but different (Dep1 and Dep2). When you filter by a cube value in MDX, you do not specify the elements of coincident dimensions (like !Dim in DB). But the d...
by Drg
Tue Sep 19, 2017 2:13 pm
Forum: Cognos TM1
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 10
Views: 512

Re: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?

Do you use any anchors (cells of the queue cubes, attributes, global variables) for the process that you run through the Runti? It is important to understand that each RUNTI process is isolated and has access to the data relevant for different times. Suppose we run a 3 process instance that reads th...
by Drg
Tue Sep 19, 2017 12:46 pm
Forum: Cognos TM1
Topic: ExecuteCommand on SFTP file transfer
Replies: 5
Views: 275

Re: ExecuteCommand on SFTP file transfer

1. Run service as user with same premission
2. cmdd= 'cmd /c " YOUR COMMAND HERE "';
3. Maybe need use powershell ????
by Drg
Mon Sep 18, 2017 10:37 am
Forum: Cognos TM1
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 462

Re: Dynamic subset based on a cube value, with another dimension

Create new element [Measures].[Value2] solve your problem?
by Drg
Mon Sep 18, 2017 6:57 am
Forum: Cognos TM1
Topic: Undocument tm1s.cfg replication parameters
Replies: 0
Views: 116

Undocument tm1s.cfg replication parameters

This two parameterst fix some bug(delete trnsactions on servers, turn off transfer transactions between three or more servers)

Code: Select all

TransactionLogSearchOptimization=F
TwoServerReplicationMode=T
this params works only both on.

can help explain me how it's work?
by Drg
Fri Sep 15, 2017 1:01 pm
Forum: Cognos TM1
Topic: Wrap alias in TM1 Web view
Replies: 6
Views: 601

Re: Wrap alias in TM1 Web view

just need write you Javascript function check all data in table and change width in column, appent this in tm1web.js
by Drg
Fri Sep 15, 2017 12:56 pm
Forum: Cognos TM1
Topic: Create hierarchy by attributes in PA
Replies: 3
Views: 169

Re: Create hierarchy by attributes in PA

I'm not convinced you will be able to see the hierarchy in TM1 Web, pretty sure it is only available in PAW and PAX. The "old" clients won't be able to see them, I'm slightly hesitant as I know they refreshed TM1 Web a little in the last release and I have not directly checked. Just checked on PA 2...
by Drg
Wed Sep 13, 2017 8:08 am
Forum: Cognos TM1
Topic: Drill from Cube View to Websheet
Replies: 3
Views: 206

Re: Drill from Cube View to Websheet

you can create your own JavaScript code which would catch the links created by the ti process or rules, but this is not the best practice.
Note that TM1 replaces the "<>" tags, which makes it impossible to write

Code: Select all

<a href='tm1web sheet'>DRILL</a>
to cells
by Drg
Wed Sep 13, 2017 8:01 am
Forum: Cognos TM1
Topic: Transfer rule value to other cube using TI
Replies: 3
Views: 256

Re: Transfer rule value to other cube using TI

show your TI code!