Hi Guys,
For my Sales Budgeting I have the following Scenarios
The user wants to do
Sales by Month
Sales by Customer Class
Sales Market by Customer Class
Sales Product by Market
Sales Item by Product.
My Sales cube has the following dimensions.
1.Function
2.Facility
3.Year
4.Months
5.Scenario
6.Market Segment(Customer Class)
7.Product line.
8.Market.
9.Item Sales Group
10.Sales Measures.
My Feeders are not working properly. Can someone figure out what is going wrong with my feeders, here is the code.
SKIPCHECK;
#stet for month.
['All Cust Class','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']=STET;
#stet for customer class.
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']=STET;
['All Cust Class','All Months','All Product Line','All Market','All Item Sales Group','Budgeted']=STET;
# stet for market by cust class
['All Months','All Product Line','All Item Sales Group','Budgeted','Amount %']=STET;
# stet for product line by market.
['All Months','All Cust Class','Budget Amount % for Product','All Item Sales Group','Budgeted']=STET;
#,'Budgeted Amount %']
# stet for item sales by product line
['All Months','All Cust Class','Budget Amount % for Item Sales Group','All Market','Budgeted']=STET;
# calculating customer class values....
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']=N:
['All Cust Class','Total Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']*
(['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']\100);
# calculating market by cust class values....
['All Months','All Product Line','All Item Sales Group','Budgeted','Amount']=N:
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']
*(['All Months','All Product Line','All Item Sales Group','Budgeted','Amount %']\100);
# calculating Product by market values....
['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount']=N: ['All Months','Total Market Segment','All Item Sales Group','Budgeted','Amount','All Product Line']
*
(['All Months','All Cust Class','Budget Amount % for Product','All Item Sales Group','Budgeted','Amount %']\100);
['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount %']=(['All Months','All Cust Class','Budget Amount % for Product','All Item Sales Group','Budgeted','Amount %']);
#calculating item by product line..
['All Months','All Cust Class','All Market','Budgeted','Amount']=N:
['All Months','All Cust Class','Total Market','All Item Sales Group','Budgeted','Amount']*
(['All Months','All Cust Class','Budget Amount % for Item Sales Group','All Market','Budgeted','Amount %']\100);
['All Months','All Cust Class','All Market','Budgeted','Amount %']=['All Months','All Cust Class','Budget Amount % for Item Sales Group','All Market','Budgeted','Amount %'];
['All Months']=STET;
['All Cust Class']=STET;
['All Product Line']=STET;
['All Market']=STET;
['All Item Sales Group']=STET;
# calculating the entire cube.
['Budgeted','Amount']=
#GET aMOUNT sALES BY mONTH
N:['All Cust Class','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']
*
#GET a sALES BY CUST CLASS
(['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']\100)
*
#GET % MARKET BY CUST CLASS
(['All Months','All Product Line','All Item Sales Group','Budgeted','Amount %']\100)
*
#GET % PRODUCT LINE BY MARKET
(['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount %']\100)
#GET % ITEM BY PRODUCT LINE
* (['All Months','All Cust Class','All Market','Budgeted','Amount %']\100);
Feeders;
# feeders for calculating customer class values....
['All Cust Class','Total Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']=>['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount'];
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']=>['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount'];
# feeders for market by customer class..
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']=>['All Months','All Product Line','All Item Sales Group','Budgeted','Amount'];
['All Months','All Product Line','All Item Sales Group','Budgeted','Amount %'] =>['All Months','All Product Line','All Item Sales Group','Budgeted','Amount'];
# feeders Product by market values....
['All Months','Total Market Segment','All Item Sales Group','Budgeted','Amount','All Product Line']=>['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount'];
['All Months','All Cust Class','Budget Amount % for Product','All Item Sales Group','Budgeted','Amount %']=>['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount'];
# feeders Product by market values %....
['All Months','All Cust Class','Budget Amount % for Product','All Item Sales Group','Budgeted','Amount %']=>['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount %'];
#feeders item by product line..
['All Months','All Cust Class','Total Market','All Item Sales Group','Budgeted','Amount']=>['All Months','All Cust Class','All Market','Budgeted','Amount'];
['All Months','All Cust Class','Budget Amount % for Item Sales Group','All Market','Budgeted','Amount %']=>['All Months','All Cust Class','All Market','Budgeted','Amount'];
#feeders item by product line % calculation..
['All Months','All Cust Class','Budget Amount % for Item Sales Group','All Market','Budgeted','Amount %']=>['All Months','All Cust Class','All Market','Budgeted','Amount %'];
# feeders to calculating the entire cube.
['All Cust Class','All Product Line','All Market','All Item Sales Group','Budgeted','Amount']=> ['Budgeted','Amount'];
['All Months','All Product Line','All Market','All Item Sales Group','Budgeted','Amount %']=> ['Budgeted','Amount'];
['All Months','All Product Line','All Item Sales Group','Budgeted','Amount %'] => ['Budgeted','Amount'];
['All Months','All Cust Class','All Item Sales Group','Budgeted','Amount %']=> ['Budgeted','Amount'];
['All Months','All Cust Class','All Market','Budgeted','Amount %']=> ['Budgeted','Amount'];