Search found 52 matches

by Drg
Wed Sep 20, 2017 7:15 am
Forum: Cognos TM1
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 4
Views: 113

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: 6
Views: 204

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: 3
Views: 78

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: 4
Views: 113

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

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

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

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

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: 2
Views: 141

Re: Transfer rule value to other cube using TI

show your TI code!
by Drg
Wed Sep 13, 2017 7:55 am
Forum: Cognos TM1
Topic: Unable to pull views in TM1 Cafe
Replies: 4
Views: 161

Re: Unable to pull views in TM1 Cafe

maybe you data in vie so big and you need config CAFE for this dataset?

try change params in cafe ->IBM cognos -> parapmetars -> ibm cognos analysis
by Drg
Fri Aug 18, 2017 9:18 am
Forum: Cognos TM1
Topic: Data Tab (TI)
Replies: 2
Views: 560

Re: Data Tab (TI)

ENJOY :)

Code: Select all

IF(NUMBR(vt_months)>NUMBR(vMonthActual)); 
by Drg
Thu Aug 10, 2017 8:47 am
Forum: Cognos TM1
Topic: TM1 Migration between different environments
Replies: 4
Views: 436

Re: TM1 Migration between different environments

Maybe you sould change odbc conection to another DB???
by Drg
Tue Aug 08, 2017 4:11 pm
Forum: Cognos TM1
Topic: Region Settings
Replies: 6
Views: 310

Re: Region Settings

If you use TI to load data you must define decimal separate char and thousand saparate char in TI.
Image
by Drg
Tue Aug 08, 2017 3:58 pm
Forum: Cognos TM1
Topic: Application name not listed in TM1 web URL
Replies: 9
Views: 335

Re: Application name not listed in TM1 web URL

check your admin host in fpmsvc_config.xml
by Drg
Tue Aug 08, 2017 7:05 am
Forum: Useful code, tips and tricks
Topic: Inspecting TM1 processes and chores
Replies: 3
Views: 577

Re: Inspecting TM1 processes and chores

awesome, gret job.
by Drg
Mon Aug 07, 2017 9:44 am
Forum: Cognos TM1
Topic: Perspectives hang when performing a slice or snapshot to Excel
Replies: 17
Views: 1075

Re: Perspectives hang when performing a slice or snapshot to Excel

hi faced with use perspectives and cafe in same excel.(create snapshot, slice)

IBM create a fix pack for cafe.


IBM Cognos CAFE IF 10.2.2.7 IF2
by Drg
Mon Aug 07, 2017 9:23 am
Forum: Cognos TM1
Topic: Process does not update updateable cell
Replies: 5
Views: 309

Re: Process does not update updateable cell

use textoutput() function on your process to create snapshot of action on the TI script. Check rule on cell where you don't see you data(maybe on some action of users cell lock's CellIsUpdateable etc...). Faced in same trouble wheen copy data from version to version. We check al ldata flow and find ...
by Drg
Mon Aug 07, 2017 9:11 am
Forum: Cognos TM1
Topic: Need help in attaching files in commentary without changing File Name - TM1 10.2.2
Replies: 6
Views: 355

Re: Need help in attaching files in commentary without changing File Name - TM1 10.2.2

The first thing is to parse the structure of the form stored in the cube} ElementAnnotations_DimensionName cube to get a list of files (in the OS) and their names (the names that are needed to display to users) After this, two operations must be performed 1) replace the names in the folder} app 2) o...
by Drg
Fri Aug 04, 2017 2:28 pm
Forum: Cognos TM1
Topic: Feeders - for conversion rule
Replies: 8
Views: 426

Re: Feeders - for conversion rule

maybe ?
[Currency:'Local Currency'] => [Currency:'USD'];

This implies that all other dimensions of the feeds are one to one