Search found 116 matches

by Drg
Mon Sep 25, 2017 7:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to Feed this Rule ??? pls help!!!
Replies: 3
Views: 825

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rules Created by Links are not allowing us to copy data from source version to target version
Replies: 16
Views: 3025

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 11
Views: 2468

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 11
Views: 2468

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 2892

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1RunTi, what is the Maximum TM1 Server Conections allowed in parallel execution?
Replies: 11
Views: 2468

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: ExecuteCommand on SFTP file transfer
Replies: 5
Views: 1251

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset based on a cube value, with another dimension
Replies: 11
Views: 2892

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Undocument tm1s.cfg replication parameters
Replies: 0
Views: 615

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Wrap alias in TM1 Web view
Replies: 6
Views: 2003

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Create hierarchy by attributes in PA
Replies: 3
Views: 1163

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill from Cube View to Websheet
Replies: 3
Views: 770

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 7:55 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to pull views in TM1 Cafe
Replies: 4
Views: 1131

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Data Tab (TI)
Replies: 2
Views: 972

Re: Data Tab (TI)

ENJOY :)

Code: Select all

IF(NUMBR(vt_months)>NUMBR(vMonthActual)); 
by Drg
Thu Aug 10, 2017 8:47 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Migration between different environments
Replies: 4
Views: 1332

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Region Settings
Replies: 6
Views: 1308

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Application name not listed in TM1 web URL
Replies: 9
Views: 2547

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

Re: Inspecting TM1 processes and chores

awesome, gret job.