Currently, our budget is built at the lowest level of expense, revenue, or contra account and then roles up to reports on a campus or department level.  The Finance cube has accounts some accounts that are fed from other cubes and others are entered directly.  

Next year, a decision was made to add an additional layer to reporting and budgeting by an additional layer of School for revenue. My question specifically relates to revenue since enrollment will be school specific for each of the campuses.    

This chart is an example of how enrollment is broken down now:

New York	→	Adult	→	Certificate
			→	Undergraduate
			→	Graduate
	→	High School	→	Certificate
			→	Undergraduate
			→	Graduate

This chart is how it will be next year:

New York	→	Business School	→	Adult	→	Certificate
					→	Undergraduate
					→	Graduate
			→	High School	→	Certificate
					→	Undergraduate
					→	Graduate

My question is this: is there a best practice for writing rules that preserve the old rules for feeding revenue from our existing Revenue cube to the Finance cube but also allow for a new calculation from a new Revenue cube?

------------------------------
Theresa Omelczuk
------------------------------

#PlanningAnalyticswithWatson

Theresa,

Is the level of detail that your are planning the finance cube changing or is it remaining the same?  I.e with the changes to the budgeting cubes are you still going to pull over a consolidate New York number or are you also looking to have more granular detail in the Finance cube?

If you are using the same level of detail and feeding from NY (C Level Budget Cube) => NY ( N Level Finance cube) your rules and feeders may not need to be changed.  If you were feeding from Audit to the finance cube you may need to have a audit roll up with all the Audit elements across schools to get the right totals into finance.

Regards,
Tim


------------------------------
Timothy Corrigan
------------------------------