Search found 22 matches

by mail_kupi
Wed Apr 24, 2013 2:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form Performance Issue
Replies: 7
Views: 5084

Re: TM1 Active Form Performance Issue

Hi Guys, sory for late response and thanks a lot for your reply. cGaunt, in CPU PF there is no significant usage, but in client CPU PF usage increase dramatically. in TM1TOP there is no paralel activity that happen same time when i hit TM1REFRESH. i just only have a problem in current active form, a...
by mail_kupi
Tue Apr 23, 2013 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form Performance Issue
Replies: 7
Views: 5084

Re: TM1 Active Form Performance Issue

Thanks for Reply Tomok

My DBRW Formula point to a cell that contain a View TM1RPTVIEW formula, so i dont think its not the problem.
Any suspect and suggestion?
by mail_kupi
Tue Apr 23, 2013 12:45 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Active Form Performance Issue
Replies: 7
Views: 5084

TM1 Active Form Performance Issue

Hi Guys, I'm using Cognos TM1 10.1.1, with 24 Core and 16 GB Ram on Hardware ( share with another application ) i have a report using excel where i build the report from active form using DBRW formula. the report is using one cube with 23 dimension, where consist of 16 row dimension, 2 column dimens...
by mail_kupi
Tue Dec 06, 2011 3:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect Not Showing another TM1 Remote Server
Replies: 4
Views: 2992

Re: TM1 Architect Not Showing another TM1 Remote Server

Thanks for your reply jim,

I have tried pinging to the name server or using ip server. so far we dont have any issue IP4/6.
by mail_kupi
Fri Dec 02, 2011 11:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect Not Showing another TM1 Remote Server
Replies: 4
Views: 2992

Re: TM1 Architect Not Showing another TM1 Remote Server

Hi Jim,

thanks for your reply.

I haved tried using the machine IP before active directory installed.
if DNS written right all over it, do you have any suggestion what i have to check with my network guys?

Thanks a lot.
by mail_kupi
Thu Dec 01, 2011 11:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Batch File running over and over again until time out
Replies: 1
Views: 1739

Batch File running over and over again until time out

Hi All, i have command to execute spss package ExecuteCommand('C:\Program Files\IBM\SPSS\StatisticsServer\20\statisticsb.exe -f "E:\SPSS\process.sps" -type text -out E:\SPSS',1); when i run this command using tm1 web in remote dekstop, the batch only running once which is the package is su...
by mail_kupi
Thu Dec 01, 2011 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Architect Not Showing another TM1 Remote Server
Replies: 4
Views: 2992

TM1 Architect Not Showing another TM1 Remote Server

Hi All,

I Have A problem when trying to access TM1 server from another PC Server.
Acctually this problem occured after the PC server install active directory.
is there any suggestion?

Regards,
Kupi
by mail_kupi
Fri Jul 22, 2011 9:47 am
Forum: Useful code, tips and tricks
Topic: Copying Data from 1 Element to Another via TI
Replies: 29
Views: 73605

Re: Copying Data from 1 Element to Another via TI

Hi Wim,

I had an error regarding in Data tab, where there is one element that using picklist show the error
"Data Source line (1) Error: Data procedure line (0): Cannot convert field number 7, value "% KPI" to a real number."

thanks for your attention
by mail_kupi
Thu May 26, 2011 5:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Workflow Security and locking issue
Replies: 1
Views: 1755

Workflow Security and locking issue

Hi guys, im actually newbie for implement tm1 using workflow, i have several question regarding reject and submit process let said that the hierarchy has 3 level, the scenario are level1 submit the worksheet to level2, where level2 is act to review level1. after level2 review and approve, level2 sub...
by mail_kupi
Thu Apr 28, 2011 3:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Reference
Replies: 8
Views: 7186

Re: Subset Reference

So its mean i cannot using subset to fullfil what i want, but instead using multi consolidation to achieve that, is it right?

ok then,

Thanx a lot kpk... :D
by mail_kupi
Tue Apr 26, 2011 8:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Reference
Replies: 8
Views: 7186

Re: Subset Reference

Thanks Alan,

but actually the element has a consolidation but i just want to take some element child from that consolidation.

Regards
Novianto
by mail_kupi
Tue Apr 26, 2011 8:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subset Reference
Replies: 8
Views: 7186

Subset Reference

Hello all, i want to get value from another cube but only certain element. ['Sales1'] = DB['Production','Book'] + DB['Production','Pencil'] +DB['Production','Bag'] my intention is want to have sales1 value base on cube production which is from book, pencil and bag element only is there more simple r...
by mail_kupi
Tue Apr 26, 2011 8:01 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Edit alias using cube Element attribute
Replies: 5
Views: 4305

Re: Edit alias using cube Element attribute

Ok guys.. thanx a lot for the suggestion
i will try it...

really.. really.. thanx..
by mail_kupi
Wed Apr 13, 2011 1:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Edit alias using cube Element attribute
Replies: 5
Views: 4305

Edit alias using cube Element attribute

Hi Everyone,

I try to make alias that is SUBST from own element. i found cube }element attribute save the attribute value and i can use rule to modified.
but i cannot used function in there SUBST([ELEMENT],1,4). any sugestion?

Thanks for your attention
by mail_kupi
Tue Apr 05, 2011 7:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation not working cause of skipcheck
Replies: 10
Views: 9788

Re: Consolidation not working cause of skipcheck

Hi Martin,

I try to look the config file, but i cannot found it. is it tm1s.cfg file?
or the configuration is stated in rules guide documentation?
by mail_kupi
Thu Mar 31, 2011 4:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation not working cause of skipcheck
Replies: 10
Views: 9788

Re: Consolidation not working cause of skipcheck

Hi Mikko, actually my need is want to get price not by average but using C: sales \ C: Qty so its different from C:Price \ count(price). any idea ? Steve, ['Price'] =N: ['KG','Price'] * DB('Convert',!Product,!Unit Measures); ['Sales'] =N: ['Price'] * ['Qty']; ['Price'] = C: ['Sales'] \ ['Qty'] ; its...
by mail_kupi
Wed Mar 30, 2011 7:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation not working cause of skipcheck
Replies: 10
Views: 9788

Re: Consolidation not working cause of skipcheck

so what you mean there is something wrong with my rule that having value in N: level point?
by mail_kupi
Wed Mar 30, 2011 4:29 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation not working cause of skipcheck
Replies: 10
Views: 9788

Consolidation not working cause of skipcheck

Hi Guys, Please help me. i have cube that input in KG and i want to convert Price and Qty to another unit measures exp.DOOS Price consolidate is not using aggregate or average but using Sales C: \ Qty C: SKIPCHECK; #Sales = Price * Qty ['KG','Sales'] = N: ['KG','Price']*['KG','Qty']; #Calculate Cons...