TM1 Forum

Hi,

I have written rule and written feeders also but feeders is not feeding correct values,Can you please help what error Iam making.

SKIPCHECK;
# Like Port = SYD(Sydney),so CityPair(Combination of OriginDestination of AirCraft) which Is related to SYD Port.
Exa. - Port - SYD,CityPair - 'SYDMEL'

['No Aircraft_Type','Overseas Air Navigation','Numeric Value'] = N:
IF(!Port @= SUBST(!CityPair,1,3) % !Port @= SUBST(!CityPair,4,6),
DB('Route Nav Rates',!Company,!Year,!Period,!Air Authority,!Port,'No CityPair',!Currency,'No Aircraft_Type',!Version,'Overseas Air Navigation','Base'),
STET);

#Suppose User is put'ting values in Year-2016,By !AirAuthrity,By !Port,In 'NoCityPair,By !Curreny ,In No Aircraft_Type,In Version - 'Áctual'

FEEDERS;
['2016','Total Air Authority','All Ports','No CityPair','All Currencies','No Aircraft_Type','Actual','Overseas Air Navigation','Base'] =>
['All CityPair','No Aircraft_Type','Overseas Air Navigation','Numeric Value'];

dilip wrote:Hi,

I have written rule and written feeders also but feeders is not feeding correct values,Can you please help what error Iam making.

SKIPCHECK;
# Like Port = SYD(Sydney),so CityPair(Combination of OriginDestination of AirCraft) which Is related to SYD Port.
Exa. - Port - SYD,CityPair - 'SYDMEL'

['No Aircraft_Type','Overseas Air Navigation','Numeric Value'] = N:
IF(!Port @= SUBST(!CityPair,1,3) % !Port @= SUBST(!CityPair,4,6),
DB('Route Nav Rates',!Company,!Year,!Period,!Air Authority,!Port,'No CityPair',!Currency,'No Aircraft_Type',!Version,'Overseas Air Navigation','Base'),
STET);

#Suppose User is put'ting values in Year-2016,By !AirAuthrity,By !Port,In 'NoCityPair,By !Curreny ,In No Aircraft_Type,In Version - 'Áctual'

FEEDERS;
['2016','Total Air Authority','All Ports','No CityPair','All Currencies','No Aircraft_Type','Actual','Overseas Air Navigation','Base'] =>
['All CityPair','No Aircraft_Type','Overseas Air Navigation','Numeric Value'];

I guess it must be in the rules:
IF(!Port @= SUBST(!CityPair,1,3) % !Port @= SUBST(!CityPair,4,3),

For the feeders, use the built-in tools of the Cubeviewer: Check feeders and Trace feeders.
when debugging feeders problems, go to the lowest level (white cells) where feeders start.
Then continue from there and correct your feeders.

It seems that you have Port and CityPair in the same cube ? Is this correct ?

Why do you include the Total elements in the left-hand side of the feeder statement ?

Hi Dilip

A few observations. You have been using TM1 since 2011, and yet you are still writing rules with no indentation which makes them rather difficult to read.

In order for us to help you will need to explain what the rules are trying to do.

It looks as though you have the leg of a route coded as a pair of Airport three letter codes and you are checking to see if the Airport is at the start or end of that route code. However, when you do have a match, why do you select No City Pair? It would seem to me as though you do have at least one half of a pair.

If you have specified something on the left hand side of a rule there is no need to specify it on the right hand side.

There may be a reason but feeders that are specific to a single year and have lots of Total elements look suspect. At the very least you are going to require whomever comes after you to edit rules every year, and at the worst you are going to make TM1 do a lot more work than it needs to.

Regards

Paul Simon

In addition, Mr. Dilip, please review the below - 2.5 years old - topic about feeders not working. Basic N-level rules and feeders.
http://www.tm1forum.com/viewtopic.php?f=3&t=9390
That topic was created by yourself and apparently it helped you solve a feeders problem. Chances are that that topic will also solve your current feeders issue.

paulsimon wrote:A few observations. You have been using TM1 since 2011, and yet you are still writing rules with no indentation which makes them rather difficult to read.

In order for us to help you will need to explain what the rules are trying to do.

It looks as though you have the leg of a route coded as a pair of Airport three letter codes and you are checking to see if the Airport is at the start or end of that route code. However, when you do have a match, why do you select No City Pair? It would seem to me as though you do have at least one half of a pair.

If you have specified something on the left hand side of a rule there is no need to specify it on the right hand side.

There may be a reason but feeders that are specific to a single year and have lots of Total elements look suspect. At the very least you are going to require whomever comes after you to edit rules every year, and at the worst you are going to make TM1 do a lot more work than it needs to.

I strongly suspect that the reason is most likely budget airline has budget mentality and budget airline gets the quality that budget airline pays for.