Break Back Average

[gatorfe]

I have break back turned on to be an average for the unit price of a product listing for the 2009 budget year cube.  Some products have values in some months and others in no months at all.  When I add a value in the total year(eg 2.00) column it averages it by the same value if no data exist in any month column so I see 2.00 added to every month column so it averages to 2.00 for the total year.  If I add 2.00 to the total year where there are values already for certain months I then have to edit each month to come up with the average total value of 2.00.  It seems like a lot of work.  I know I can turn of the break back but it’s for the whole cube.  Is this how everyone deals with break back averages?  Thanks in advance for your response. 

[RickC]

If you want the same distribution for every month, then you want all the months to have the same value.  You are obviously accomplishing this when you have no data ... since all is 0.

The best way to handle the time periods that do have data is to put zero in the total year as this will change all months to 0.  Then, enter your real number into total year and you will have the same situation as above and all months will have the same value.  Thus, you only have to enter two numbers (the zero and the real number in Total Year) instead of individually changing each month.

Also, it should be noted to be careful using this method depending how the break back and calculations are set.  That is, you want to make sure when your average is changed to 0, it does not change your original numerator field to 0.