Search found 104 matches

by Analytics123
Thu Jan 18, 2018 8:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: add part of dimension to a new dimension
Replies: 4
Views: 197

Re: add part of dimension to a new dimension

this code doesn't work if I have more than 1 child .

Example

Car-> camry->level1 ->s4

iterate all n level , we get s4 ,

now only s4 and its parent level 1 is copied to the new dimension . I still wanted camry and car .
by Analytics123
Thu Jan 18, 2018 1:58 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: add part of dimension to a new dimension
Replies: 4
Views: 197

add part of dimension to a new dimension

Hi, I have a dimension say car which has elements with parent ,child relation with different levels. car-> Toyota->SE,LE,XE Hundai->Model1->XSE now I need to copy all these elements to another dimension say 4 wheelers with a parent child relation in car I will create a subset of all N level in car d...
by Analytics123
Mon Jan 15, 2018 3:42 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

Okay its working now . Thanks for your help on this and putting so much time to explain . I am still confused with logic and will take simple example . Only tow days of sale Sale CumSale 1 100 100 2 50 50 1 MTD - 1 and 2 MTD - 2 ,1 So rule [CumSale]= DB ('Trend',!Day|'MTD', 'Sale'); so for feeder he...
by Analytics123
Mon Jan 15, 2018 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

so for day 3 my rule was based on 3, 2MTD and 1MTD . And we created a consolidation called days!|'MTD' which included 3,2 and 1 . Now for the same day 3 which days are my feeder dependent and how should the consolidation here be . Can you please tell me how my consolidation for feeder should be and ...
by Analytics123
Fri Jan 12, 2018 7:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

Okay please ignore me if I am being very basic . so assume I have days 1 to 31 and I have sales only for days till day 5 . I have my view with days 1 to 5 and columns with Daily H) and MTD H0 . so the rule says , ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, ...
by Analytics123
Fri Jan 12, 2018 7:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

can you tell me the syntax in this case to consider Day trends for feeder . I think I am not understanding clearly , but by looking at the feeder I should be able to relate it. I tried something like this , but didnot work . ['Daily H0 - Accumulated' ] =>DB('Daily Sales Trend', !Customer Regions, !D...
by Analytics123
Fri Jan 12, 2018 5:15 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

I think I will make it simple I have cube with days like Sales MTD H0 RPD 1 100 100 100 2 222 322 111 3 222 544 181.3 4 100 644 161 5 600 1244 248.8 Now MTD H0 is a rule and it uses the below rule and feeders . ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !P...
by Analytics123
Fri Jan 12, 2018 1:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Re: Feeders Not Fed

No this is not working .Still the same ,

Guys any help on this .
by Analytics123
Thu Jan 11, 2018 10:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders Not Fed
Replies: 11
Views: 332

Feeders Not Fed

SkipCheck; ['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !Product Lines, 'Daily H0 - Accumulated'); ['RPD' ] =['MTD H0' ] /ATTRN('Days Trending',!Days Trending,'DayNo'); ['PTQ']= ['MTD H0'] /DB('Daily Sales Trend', !Customer Regions, '1', !Months, !Product Li...
by Analytics123
Wed Jan 10, 2018 10:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cumulative balance in TI or Rule
Replies: 3
Views: 196

Re: Cumulative balance in TI or Rule

I was able to do the consolidated element in the dimension itself . How do I calculate it in the TI process when you load the data in the first place, probably best for performance ? Should I do a while lopp or if loop for each day and sum the values and then store it , consolidation on dimension lo...
by Analytics123
Wed Jan 10, 2018 2:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cumulative balance in TI or Rule
Replies: 3
Views: 196

Cumulative balance in TI or Rule

Hi , I have the below scenario and would like to calculate a new measure which will do the cumulative total . Region 1 Days Daily H0 Cumulative H0 1 120 120 2 100 220 3 150 370 4 200 570 5 33 603 6 50 653 I am expecting the calculation for Cumulative H0 based on my daily h0 based on days . Can you t...
by Analytics123
Wed Dec 20, 2017 2:19 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

Re: Count in rules

Hi , Deleting the rules and restarting the server and recreating the rules fixed the issue . Thanks so much for all help . Now I have a another question related . With same example , ['Average TurnAround Time' ] = ['TurnAround Time']\ ['Cases with TurnAround']; ['TurnAround Time'] =>['Average TurnAr...
by Analytics123
Wed Dec 20, 2017 3:33 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

Re: Count in rules

TThanks for taking time to give the sample code . But Can you tell me whats wrong in my other post . I had done it after reading about feeders tutorial and would like to know why feeding is not happened . I have posted the rule tracer and check feeders screen as well . . Instead of doing case count ...
by Analytics123
Tue Dec 19, 2017 4:49 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Feeders - not fed
Replies: 2
Views: 211

Feeders - not fed

Hi , I have read the IBM proven practices on feeders on recommendation of a forum member and half way through and they explain the basics clearly . I have an issue now with my feeder not being fed and disappears on zero suppression . I have a measure which gives the turn around time and other measur...
by Analytics123
Mon Dec 18, 2017 3:22 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

Re: Count in rules

Is there a syntax ,if I reverse it showing up syntax error . DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Case Status, !Dispute Person Responsible, !Dispute Processor, !Dispute Reason, !Dispute Root Cause Code, 'TurnAround Time') => ['Average TurnAround...
by Analytics123
Mon Dec 18, 2017 2:56 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

Re: Count in rules

Hi, Okay this is what I got and I want some advise on how this works . Working Rule and Feeders : Skipcheck; ['Cases with TurnAround' ] =N: IF( ['TurnAround Time' ] > 0,1,0); ['Average TurnAround Time' ] = DB('Dispute Data', !Customers SoldTo Only, !Currencies, !Months, !Dispute Case ID, !Dispute Ca...
by Analytics123
Sun Dec 17, 2017 5:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

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: IBM TM1, Planning Analytics, PAx and PAW
Topic: Count in rules
Replies: 19
Views: 800

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