Cube running very slow.
Posted: Tue Oct 18, 2011 7:46 pm
Hi Guys,
For my Sales Budgeting I have around 5 cubes which are broken to there own respective calculation and then I am using the % values of each these cubes for my Main Cube.
My Problem is my Main cube is not responding when i select all consolidations items in it. I am not able to figure out what is going wrong with the feeders or if I am overfeeding the Main cube. Request some one to help me on this as I am a newbie as far as feeders & overfeeding goes.
I have read the topics on this forum for overfeeding but I am not able to figure out what is going wrong in my rules.
It would be a great help if some one can throw light to this.
For my Sales Budgeting I have around 5 cubes which are broken to there own respective calculation and then I am using the % values of each these cubes for my Main Cube.
My Problem is my Main cube is not responding when i select all consolidations items in it. I am not able to figure out what is going wrong with the feeders or if I am overfeeding the Main cube. Request some one to help me on this as I am a newbie as far as feeders & overfeeding goes.
I have read the topics on this forum for overfeeding but I am not able to figure out what is going wrong in my rules.
It would be a great help if some one can throw light to this.
Code: Select all
1. Sales by Month
Year
Months
Facility.
Function
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %)
Rules:
SKIPCHECK;
FEEDERS;
['Budgeted Amount']=>DB('Sales by Customer Class',!Function,!Facility,!Year,'Total Markets','Budgeted Amount');
['Sales and selling expenses','Budgeted Amount %']=>DB('Sales',!Year,!Months,'Budgeted Amount');
2.Sales by Customer Class
Year
Cust Class
Facility.
Function
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %)
Rules:
SKIPCHECK;
['Budgeted Amount']=N:DB('Sales by Month',!Function,!Facility,!Year,'Total Months','Budgeted Amount')*(['Budgeted Amount %']/100);
FEEDERS;
['Budgeted Amount %']=>['Budgeted Amount'] ;
['Budgeted Amount']=>DB('Sales Market by Cust Class',!Function,!Facility,!Year,!Market Segment,'Total Market','Budgeted Amount');
['Sales and selling expenses','Budgeted Amount %']=>DB('Sales',!Facility,!Year,'Total Months',!Market Segment,'Total Product Line','Total Market','Total Item Sales Group','Budgeted','Budgeted Amount');
3.Sales Market by Cust Class
Year
Cust Class
Market
Facility.
Function
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %,Actual Avg Price,Actual Pieces,Budgted Avg Price)
RUles:
SKIPCHECK;
['Budgeted Amount']=N:DB('Sales by Customer Class',!Function,!Facility,!Year,!Market Segment,'Budgeted Amount')*(['Budgeted Amount %']\100);
FEEDERS;
['Budgeted Amount %']=>['Budgeted Amount'];
['Budgeted Amount']=>DB('Sales Product Line by Market',!Function,!Facility,!Year,'Total Product Line',!Market,'Budgeted Amount');
['Sales and selling expenses','Budgeted Amount %']=>DB('Sales',!Facility,!Year,'Total Months',!Market Segment,'Total Product Line',!Market,'Total Item Sales Group','Budgeted','Budgeted Amount');
4.Sales Product Line by Market
Year
Product Line
Market
Facility.
Function
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %)
Rules:
SKIPCHECK;
['Budget Amount % for Product']=STET;
['Budgeted Amount']=N:DB('Sales Market by Cust Class',!Function,!Facility,!Year,'Total Market Segment',!Market,'Budgeted Amount') * (['Budget Amount % for Product','Budgeted Amount %']\100);
['Budgeted Amount %']=['Budget Amount % for Product','Budgeted Amount %'];
FeEDERS;
['Budget Amount % for Product','Budgeted Amount %']=>['Budgeted Amount'];
['Budget Amount % for Product','Budgeted Amount %']=>['Budgeted Amount %'];
['Budgeted Amount']=>DB('Sales Item Sales By Product Line',!Function,!Facility,!Year,'Total Item Sales Group',!Product Line,'Budgeted Amount');
['Sales and selling expenses','Budgeted Amount %']=>DB('Sales',!Facility,!Year,'Total Months','Total Market Segment',!Product Line,!Market,'Total Item Sales Group','Budgeted','Budgeted Amount');
5Sales Item Sales by Product Line
Year
Product Line
Item Sales Group
Facility.
Function
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %)
Rules:
SKIPCHECK;
['Budget Amount % for Item Sales Group','Budgeted Amount %']=STET;
['Budgeted Amount']=N:DB('Sales Product Line by Market',!Function,!Facility,!Year,!Product Line,'Total Market','Budgeted Amount')*(['Budget Amount % for Item Sales Group','Budgeted Amount %']\100);
['Budgeted Amount %']=['Budget Amount % for Item Sales Group','Budgeted Amount %'];
FEEDERS;
['Budget Amount % for Item Sales Group','Budgeted Amount %']=>['Budgeted Amount'];
['Budget Amount % for Item Sales Group','Budgeted Amount %']=>['Budgeted Amount %'];
['Sales and selling expenses','Budgeted Amount %']=>DB('Sales',!Facility,!Year,'Total Months','Total Market Segment',!Product Line,'Total Market',!Item Sales Group,'Budgeted','Budgeted Amount');
6. Sales Cube(This is the main cube)
Year
Months
Facility
Cust Class
Market
Product Line
Scenario (actual vs Budgeted)
Item Sales Group
Sales Measures:(Actual Amount PY,Actual Amount % , Budgeted Amount, Budgeted %,Actual Avg Price,Actual Pieces,Budgted Avg Price)
Rules:
SKIPCHECK;
['Budgeted Amount','Budgeted']=N:DB('Sales by Month','Sales and selling expenses',!Facility,!Year,!Months,'Budgeted Amount')*
(DB('Sales by Customer Class','Sales and selling expenses',!Facility,!Year,!Market Segment,'Budgeted Amount %')\100)
*(DB('Sales Market by Cust Class','Sales and selling expenses',!Facility,!Year,!Market Segment,!Market,'Budgeted Amount %')\100)*
(DB('Sales Product Line by Market','Sales and selling expenses',!Facility,!Year,!Product Line,!Market,'Budgeted Amount %')\100)
*(DB('Sales Item Sales By Product Line','Sales and selling expenses',!Facility,!Year,!Item Sales Group,!Product Line,'Budgeted Amount %')\100);
, to work it out. Good luck with it.
