If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Feeders help

Started by Vijay2345, 21 Oct 2011 02:41:38 PM

Previous topic - Next topic

Vijay2345

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'];