Search found 88 matches

by Analytics123
Sun Dec 17, 2017 5:51 pm
Forum: Cognos TM1
Topic: Count in rules
Replies: 7
Views: 279

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...
by Analytics123
Fri Dec 15, 2017 4:35 pm
Forum: Cognos TM1
Topic: Count in rules
Replies: 7
Views: 279

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...
by Analytics123
Thu Dec 14, 2017 10:05 pm
Forum: Cognos TM1
Topic: Count in rules
Replies: 7
Views: 279

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...
by Analytics123
Thu Dec 14, 2017 4:42 pm
Forum: Cognos TM1
Topic: Count in rules
Replies: 7
Views: 279

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 ...
by Analytics123
Mon Dec 11, 2017 1:58 am
Forum: Cognos TM1
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 274

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 ...
by Analytics123
Sat Dec 09, 2017 2:54 am
Forum: Cognos TM1
Topic: converting to date for comparing dates
Replies: 3
Views: 225

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 .
by Analytics123
Sat Dec 09, 2017 2:13 am
Forum: Cognos TM1
Topic: converting to date for comparing dates
Replies: 3
Views: 225

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,
by Analytics123
Wed Dec 06, 2017 6:20 pm
Forum: Cognos TM1
Topic: unwinding certain elements issue
Replies: 10
Views: 400

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...
by Analytics123
Wed Dec 06, 2017 1:40 pm
Forum: Cognos TM1
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 274

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 .
by Analytics123
Wed Dec 06, 2017 1:21 am
Forum: Cognos TM1
Topic: carry forward a dimension elements to another dimension
Replies: 5
Views: 274

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 ...
by Analytics123
Fri Dec 01, 2017 6:56 pm
Forum: Cognos TM1
Topic: unwinding certain elements issue
Replies: 10
Views: 400

Re: unwinding certain elements issue

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

Thanks,
by Analytics123
Fri Dec 01, 2017 3:03 pm
Forum: Cognos TM1
Topic: unwinding certain elements issue
Replies: 10
Views: 400

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...
by Analytics123
Fri Dec 01, 2017 2:04 am
Forum: Cognos TM1
Topic: unwinding certain elements issue
Replies: 10
Views: 400

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...
by Analytics123
Thu Nov 02, 2017 12:27 pm
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 315

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...
by Analytics123
Thu Nov 02, 2017 12:25 pm
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 315

Re: static subsets saved disappears

yes elements with in subsets are disappearing . we are not deleting the element any where .
by Analytics123
Wed Nov 01, 2017 5:27 pm
Forum: Cognos TM1
Topic: static subsets saved disappears
Replies: 6
Views: 315

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...
by Analytics123
Wed Nov 01, 2017 12:38 pm
Forum: Cognos TM1
Topic: TM1 process in chore starts with 2 min delay
Replies: 2
Views: 134

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
by Analytics123
Tue Oct 31, 2017 3:31 pm
Forum: Cognos TM1
Topic: Unwinding specific elements in GLobal Customer diension
Replies: 1
Views: 112

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...
by Analytics123
Fri Oct 20, 2017 8:45 pm
Forum: Cognos TM1
Topic: Adding a subset to a dbrw
Replies: 7
Views: 425

Re: Adding a subset to a dbrw

Yeah i have done it , but not sure it will cause performance issues .
by Analytics123
Fri Oct 20, 2017 7:22 pm
Forum: Cognos TM1
Topic: Count the number of Accounts for each agency
Replies: 2
Views: 327

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,