TM1 Forum

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...

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...

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...

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 ...

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 ...

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 .

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,

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...

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 .

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 ...

I got to work used subsetsize and get element name and used the same process on it .

Thanks,

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...

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...

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...

yes elements with in subsets are disappearing . we are not deleting the element any where .

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...

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

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...

Yeah i have done it , but not sure it will cause performance issues .

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,