Search found 128 matches
- Sun Dec 17, 2017 5:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Count in rules
- Replies: 19
- Views: 12265
Re: Count in rules
Any help is appreciated . ['Average TurnAround Time' ] =>DB('Dispute Data', 'All Regions', 'All Currencies', !Months, 'All Cases', 'All Status', !Dispute Person Responsible,'All Processors' , 'All Reason', 'All Root Cause Code', 'TurnAround Time') ; the above feeder is still gone while zero supressi...
- Fri Dec 15, 2017 4:35 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Count in rules
- Replies: 19
- Views: 12265
Re: Count in rules
Hi I am still getting the AverageTurnaround time removed on zero suppression . Skipcheck; ['Cases with TurnAround' ] =N: IF( ['TurnAround Time' ] > 0,1,0); ['Average TurnAround Time' ] = C: DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Disp...
- Thu Dec 14, 2017 10:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Count in rules
- Replies: 19
- Views: 12265
Re: Count in rules
Hi , Thanks for the suggestion . I have the below code SkipCheck; ['NewCount' ] =N: IF( ['Average Turn Around Time Count' ] > 0,1,0); ['Hold' ] = C: DB('Dispute Data', 'All Regions', 'All Currencies', !Months, !Dispute Case ID , 'All Status', !Dispute Person Responsible, 'All Processors', 'All Reaso...
- Thu Dec 14, 2017 4:42 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Count in rules
- Replies: 19
- Views: 12265
Count in rules
Hi I have the following data PersonResponsible Processor Month CaseID AverageTimeCOunt ABC C1 Aug 2017 C1234 30days ABC C2 Aug 2017 C1235 56 days ABC C3 Aug 2017 C3456 0 ABC C4 Aug 2017 C4567 24 days ABC C2 Aug 2017 C5685 0 Each column is a dimension and all data is loaded to the cube n level . The ...
- Mon Dec 11, 2017 1:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: carry forward a dimension elements to another dimension
- Replies: 5
- Views: 3413
Re: carry forward a dimension elements to another dimension
hi, I am adding to dimension A , but I am just appending dimension b to dimension A. But dimension B can change any time and that needs to be reflected on DImension A on daily basis. So I have to unwind Dim B elements in Dim A daily and then readd dim B elements to dim A . so to append Dim B to Dim ...
- Sat Dec 09, 2017 2:54 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: converting to date for comparing dates
- Replies: 3
- Views: 2835
Re: converting to date for comparing dates
i know scan will help to get the '/ 'position, but is there a way to get the first and second slash position too.
Yes i know we can come up with logic, but you dont think its too much calculation , if length is 10 then the date otherwise , check if length is 8 or length is 9 .
Yes i know we can come up with logic, but you dont think its too much calculation , if length is 10 then the date otherwise , check if length is 8 or length is 9 .
- Sat Dec 09, 2017 2:13 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: converting to date for comparing dates
- Replies: 3
- Views: 2835
converting to date for comparing dates
hi , i have in my source file values like for date
6/10/2015
Is there a specific code to append 0 before 6 or a code to say if the length of month or day is 1 then append 0 in front of it .
Thanks,
6/10/2015
Is there a specific code to append 0 before 6 or a code to say if the length of month or day is 1 then append 0 in front of it .
Thanks,
- Wed Dec 06, 2017 6:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unwinding certain elements issue
- Replies: 10
- Views: 7131
Re: unwinding certain elements issue
Moh, I was out of town , here you go . DIMENSIONSORTORDER(vDim,'','','ByHierarchy','ASCENDING'); vMax = SubsetGetSize(vDim,vSubsetName); vCount = 1; WHILE (vCount <= vMax); vElem = SubsetGetElementName(vDim,vSubsetName,vCount); vMaxParents = ELPARN(vDim, vElem); WHILE (vMaxParents>0); vParent = ELPA...
- Wed Dec 06, 2017 1:40 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: carry forward a dimension elements to another dimension
- Replies: 5
- Views: 3413
Re: carry forward a dimension elements to another dimension
Its not an exact copy , its like appending dimension B to dimension A. DImension B might change some times , so the append process to unwind dimension b elements added to dimension A and readd them daily .
- Wed Dec 06, 2017 1:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: carry forward a dimension elements to another dimension
- Replies: 5
- Views: 3413
carry forward a dimension elements to another dimension
Hi, I have a dimension say A having certain elements with unbalanced hierarchy. Now I have a dimension b similar to A with unbalanced hierarchy. Now my requirement is to iterate all elements with in dimension B and add them below dimension A . SO bascically i will have to take elements in dimnesion ...
- Fri Dec 01, 2017 6:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unwinding certain elements issue
- Replies: 10
- Views: 7131
Re: unwinding certain elements issue
I got to work used subsetsize and get element name and used the same process on it .
Thanks,
Thanks,
- Fri Dec 01, 2017 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unwinding certain elements issue
- Replies: 10
- Views: 7131
Re: unwinding certain elements issue
can anyone share a code snippet for unwinding using mdx . Say assume I have a dimension where i unwind only below code Americas->V00,V01 All elements under this 2 regions V00 and V01 . I have a mdx like below {TM1FILTERBYLEVEL( {TM1DRILLDOWNMEMBER({[Customers SoldTo].[Region - V00],[Customers SoldTo...
- Fri Dec 01, 2017 2:04 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: unwinding certain elements issue
- Replies: 10
- Views: 7131
unwinding certain elements issue
Hi , I have a dimension with hierarchy like below . All customers America EMEA ASIA Under each country i have 5 levels. unwinding is done because customers might swap between one parent to other at same level. I want to do unwinding only for customer under America and one region under asia where swa...
- Thu Nov 02, 2017 12:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: static subsets saved disappears
- Replies: 6
- Views: 3526
Re: static subsets saved disappears
dim update customers first unwinding code : DIMENSIONSORTORDER(vDim,'','','ByHierarchy','ASCENDING'); vMax = DIMSIZ(vDim); vCount = 1; WHILE (vCount <= vMax); vElem = DIMNM(vDim, vCount); vMaxParents = ELPARN(vDim, vElem); WHILE (vMaxParents>0); vParent = ELPAR(vDim, vElem, vMaxParents); DimensionEl...
- Thu Nov 02, 2017 12:25 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: static subsets saved disappears
- Replies: 6
- Views: 3526
Re: static subsets saved disappears
yes elements with in subsets are disappearing . we are not deleting the element any where .
- Wed Nov 01, 2017 5:27 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: static subsets saved disappears
- Replies: 6
- Views: 3526
static subsets saved disappears
Hi , We have static subsets disappearing in few dimension . we are not deleting any elements , while the dimension is updated we just unwind the dimension elements and re add the elements. Also I could see the subset data in the data folder but opening up the editor showing blank for subsets. Is thi...
- Wed Nov 01, 2017 12:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 process in chore starts with 2 min delay
- Replies: 2
- Views: 1830
TM1 process in chore starts with 2 min delay
Hi ,
we are in 10.1.1 and our process defined in chore starts 2 mins later than the scheduled time . IS there a setting that is controlled or a bug . It happens only recently .
Thanks
we are in 10.1.1 and our process defined in chore starts 2 mins later than the scheduled time . IS there a setting that is controlled or a bug . It happens only recently .
Thanks
- Tue Oct 31, 2017 3:31 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Unwinding specific elements in GLobal Customer diension
- Replies: 1
- Views: 1411
Unwinding specific elements in GLobal Customer diension
Hi , I have a customer dimension with customers from US, Germany and Asia . The Us customers might swap over the hierachy and other two customers are loaded in run time . In the first process I am unwinding all the elements and adding only us elements and Germany and Asia parent nodes . All -Custome...
- Fri Oct 20, 2017 8:45 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Adding a subset to a dbrw
- Replies: 7
- Views: 4984
Re: Adding a subset to a dbrw
Yeah i have done it , but not sure it will cause performance issues .
- Fri Oct 20, 2017 7:22 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Count the number of Accounts for each agency
- Replies: 2
- Views: 2387
Count the number of Accounts for each agency
Hi ,
I have a hierrachy like Region, Agency,Subregion, Rep and accounts .
The user wants the count of number of accounts under each agency .
Is there a TI function I can use which will take the agency as input and give me the count of accounts under that agency .
Thanks,
I have a hierrachy like Region, Agency,Subregion, Rep and accounts .
The user wants the count of number of accounts under each agency .
Is there a TI function I can use which will take the agency as input and give me the count of accounts under that agency .
Thanks,