Search found 6 matches

by chesteronrada
Thu May 12, 2011 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues on TM1 Contributor
Replies: 1
Views: 1822

Re: Issues on TM1 Contributor

Issue solved!
the problem is that I put WRITE access on the workflow dimension.
It should be READ only.

Thanks to Girish! :D

but the auto data spread on consolidation is not yet solved. T_T
by chesteronrada
Wed May 11, 2011 3:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issues on TM1 Contributor
Replies: 1
Views: 1822

Issues on TM1 Contributor

Hi All, having problem with Contributor Application. Need help please. TopNode -Approver1 --Contributor1 -Approver2 --Contributor2 my approval dim goes like this. the main idea is when contributor level submits the cells should be locked for this node until the approver rejects. but sometimes the lo...
by chesteronrada
Tue May 03, 2011 8:12 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Map excel data to dimension attribute
Replies: 7
Views: 4801

Re: Map excel data to dimension attribute

#Add this on your prolog v1 = 'Jan'; v2 = 'Feb'; v3 = 'Mar'; v4 = 'Apr'; v5 = 'May'; v6 = 'Jun'; v7 = 'Jul'; v8 = 'Aug'; v9 = 'Sep'; v10 = 'Oct'; v11 = 'Nov'; v12 = 'Dec'; #on your data tab x=1; WHILE(x <= 12); VarS = EXPAND ( '%v' | NUMBERTOSTRING(x) | '%' ); CELLPUTN(Value, CubeName, VarS | SUBST...
by chesteronrada
Tue May 03, 2011 3:31 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Map excel data to dimension attribute
Replies: 7
Views: 4801

Re: Map excel data to dimension attribute

Do you have months on your data or you want it to be distributed to all months?
If so just add 12 lines for Jan to Dec...
or use loop
by chesteronrada
Sat Oct 24, 2009 7:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete all consolidated elements
Replies: 2
Views: 4967

Re: Delete all consolidated elements

noted... :shock:
i am sure still is a newbie :D
thanks a lot!
by chesteronrada
Sat Oct 24, 2009 6:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Delete all consolidated elements
Replies: 2
Views: 4967

Delete all consolidated elements

Hi... need help with my TI... i have this code to delete all consolidated elements(elements with type 'C') from my Product Dimension. ####################### DimName = 'ProductDim'; eCnt = DIMSIZ(DimName); x=1; WHILE(x<=eCnt); ElName = DIMNM(DimName,x); IF(DTYPE(DimName,ElName)@='C'); DimensionEleme...