Revenue Reporting.rules

#Region System
FEEDSTRINGS;
SKIPCHECK;
UNDEFVALS;
#EndRegion

#REGION Set Explanation as String
['Explanation'] = S: STET;
#ENDREGION

#Region Rate and Volume Variances
['Gross Revenue','Volume Variance']= N:(DB('Revenue', !organization, !Channel, !product, !Month, !Year, DB('Calendar', 'Compare Against', 'String'), 'Units Sold') -
	DB('Revenue', !organization, !Channel, !product, !Month, !Year, DB('Calendar', 'Current Version', 'String'), 'Units Sold'))*
	DB('Revenue Assumptions', !product, !Channel, !Month, !Year, DB('Calendar', 'Current Version', 'String'), 'Unit Price');
['Gross Revenue','Rate Variance']= N:(DB('Revenue Assumptions', !product, !Channel, !Month, !Year, DB('Calendar', 'Compare Against', 'String'), 'Unit Price') -
	DB('Revenue Assumptions', !product, !Channel, !Month, !Year, DB('Calendar', 'Current Version', 'String'), 'Unit Price')) *
	DB('Revenue', !organization, !Channel, !product, !Month, !Year, DB('Calendar', 'Compare Against', 'String'), 'Units Sold');
#EndRegion

#Region Link rule: RevenueReporting:Revenue - Numeric
#Source cube: Revenue
#Target cube: Revenue Reporting
[] =DB('Revenue', !organization, !Channel, !product, !Month, !Year, !Version, !Revenue);
#ENDRegion

#Region C-Calculation rules: Dimension:Revenue
#Autogenerated CALC CONSOLIDATED 526576656E7565
   #Region Dimension:Revenue, Member:Unit Cost
   #Autogenerated MEMBERCALC CONSOLIDATED 5B526576656E75655D2E5B556E697420436F73745D
   #@AutoGenerated
   ['Revenue':{'Unit Cost'}]=C:IF(DTYPE('Month', !Month)@='C', 
   ConsolidateChildren('Month')\ELCOMPN('Month', !Month), 
   CONTINUE);
   #EndRegion
#EndRegion

FEEDERS;