TM1 Forum

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 Lines, 'Quota');
Feeders;
['Daily H0 - Accumulated' ] =>['MTD H0' ];
[{'MTD H0','Daily H0'}] =>['RPD'];
[{'MTD H0','Daily H0'}] =>['PTQ'];

Hi To calculate MTDH0 which is a cumulated value I use the below rule and it works fine .

Then I calulate RevenuePerDay and Percentage to Quota as a rule .

But while doing zero supression both columns pTQ and RPD disappears.

I have attached the image of my view with lowest level data and check feeders calculation .

I dont see any issue with my feeder but not sure if the feeder is fired .

Revenue per day = Mtd Revenue /Day No
PTQ = MTD / Quota

MTD H0 is calculated if there is a value for Daily H0 - Accumulated Column and that works perfectly when zero suppressed , the issue is only with RPD and PTQ which depends on the rule calulcated cell MTD H0

Any help is appreciated .

Thanks,

Try this
['Daily H0 - Accumulated' ] =>[{'MTD H0','RPD','PTQ'}];

No this is not working .Still the same ,

Guys any help on this .

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, !Product Lines,'Sales'');

['Sales' ] =>['MTD H0'];

And I have consolidation created on Days dimension so as to include 2MTD as day 2 and day 1 .



Now I am bringing in 1 more calculation called RPD , which is nothing but MTDH0 divided by the day no .

['RPD'] =['MTD H0' ] /ATTRN('Days Trending',!Days,'DayNo');
[{'MTD H0','Sales' }] =>['RPD'];


But my RPD values disappear when I do zero suprresion , also when I try to create an view and extract rpd alone, it return zero , but when I unckeck to include zero values in view it exports the value .

Check feeders says not fed and it shows only the below line
Daily Sales Trend(AgencyName,2,Jan2018 ,10 , RPD)

So basically RPD is not fed and I am not sure what mistake I am making here.

Thanks,

I know what the answer so I'm going to give you some clues.

If you think about this in a logical manner it should be straight forward to understand.

Work backwards through your feeder logic for Day 7.
RPD is not fed, my feeder says it is fed by MTD H0 or Daily HO.
Therefore both MTD HO or Daily HO must either be zero or not fed.
I can see that Daily HO is zero and so won't trigger the feeder this is expected.
MTD HO is ruled and non-zero and so should be triggering the feeder.
I know it is not triggering the feeder, therefore this value can not be itself fed.
So my feeder for MTD HO is wrong.

My rule for MTD HO is
['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !Product Lines, 'Daily H0 - Accumulated');

and my feeder is

['Daily H0 - Accumulated' ] =>['MTD H0' ];

I can see that I have correctly dealt with the switch in measure from MTD HO to Daily HO but I have taken no action in my feeder statement around the transformation of the !Days Trending reference.
The ruled value is dependant on days 1 to 7, however I am only feeding from day 7, since Day 7 is zero, MTD HO is not fed.

=> I need to change my feeder so it correctly reflects the dependencies that exist in my rule statement.

Feeders are not that hard but you did need to take some time out to think about the logic of what you are trying to do and think through why they may not be working. It is as simple as a=B and B=>a but you need to make sure you understand what a and B are and the shapes they occupy in the cube.

HTH!

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, !Days Trending|'MTD', !Months, !Product Lines, 'MTD H0');

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, !Product Lines, 'Daily H0 - Accumulated');

for whatever days selected go take its corresponding consolidated day and its value and assign it to MTD H0,
so if only day 3 is in my view , it goes and take 3MTD which is 3,2,1 . and assign its value to MTD H0 .

Rule is fine .


Now for feeders ,

['Daily H0 - Accumulated' ] => ['MTD H0']

I just had this , Meaning to calculate MTD HO use Daily H0 Accumulated or depend on this column and if this column is zero dont feed.

so for now day 3 since Daily H0 has value , should it not feed MTD H0 ? will it feed only day 3 value here instead of 3MTD?

This is where I am not sure how to say feed based on Day selected .

Thanks,

Your rule is dependant on the prior days in the period and you have built a consolidation for this and put it in your rule.
Given that feeders and rules are opposites.
Your feeder should trigger the future days, therefore you need to build a consolidation for this and put it in your feeder.

In general, whatever objects and structures you build for your rule you need to build the opposite of them for your feeders.

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 how would i relate them in feeder like e did in rule.

Rule :
['MTD H0' ] =DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !Product Lines, 'Daily H0 - Accumulated');

Current consolidation :

3MTD->
3 , 2MTD ->
2,1MTD ->
1.
Thanks,

Think about it like this.

Day 1 feeds Days 1 to 31
Day 2 feeds Days 2 to 31

=> I need to create a consolidation structure that is the "Rest of Month" (RoM), the opposite of MTD.

['MTD H0' ] =N: DB('Daily Sales Trend', !Customer Regions, !Days Trending|'MTD', !Months, !Product Lines, 'Daily HO');
['Daily H0' ] => DB('Daily Sales Trend', !Customer Regions, !Days Trending|'RoM', !Months, !Product Lines, 'MTD HO');

Simples....

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 here
take an example of day 2 only .

to feed day 2 for CumSale , I need to check if Day 1 Sale and Day2 sale are not zero , why do I have to check future days .
I have to check only the past and current day right ?


Thanks,

I'm not convinced you have the basic concept of feeders correct.

A rule points at a source. A feeder points at the ruled area.

Your rule for Day 2 is dependant on the input values for Day 1 and 2.

Your feeder for Day 2 has to flag the day 2 cumulative value from the dependant values, but you can not write it in this manner it has to start from the input value.

So the input value for day 1 could trigger the cum value for Day 1, Day 2 all the way up to Day 31, which is written

[Day 1, Input]=> [ Day 1 RoM, Cum]; where Day 1 RoM is a consolidation of Days 1 to 31, which then generalises to

[Input= => DB ( .........!Day | 'RoM', 'Cum'....);