Skip to main content

Notifications

Announcements

No record found.

Reporting on AA budgets in MR

If you’ve ever had a problem with the AA budget amounts not showing correctly in MR, it could be caused by the way the report is formatted. Let’s start with our AA budget in GP. The budget tree is made up of the Airline and Flight dimensions

1016.1.png

 

Airline owns flight.

3173.2.png

 

In this budget, the top level has $3,000.

5148.3.png

 

The Airline level (Dakota Wind, NLS, Prairie Wings) each have 1,000.

The Flight (Mnpl to Fargo, NY to London) have 500 each. The other Flights (Redmond to Fargo, Orlando to GF) have 1000 each.

8863.4.png1030.5.png

 

In the row definition, the full account number is added.

4643.6.png

 

When the account only is used, MR reads all dimensions. This causes the budget to be doubled since it reads both the Airline and Flight dimensions.  Our budget shows $6,000 when it should be $3,000.

6710.7.png

If we drill down, we can see that the budget amount from the Airline and the Flight are both being pulled in.

 8a.PNG

 

When the Flight dimension is added to the account, only the child level is read. If we drill down on that row, we can see only the Flight dimension.

6153.9.png

 

10a.PNG

 

If we include both dimensions, then we get the correct amount.

2844.11.png

 

If we drill down on that row, we get this:

13.PNG

 

 


 

 

 

Comments

*This post is locked for comments