7861 El Dorado Street Fontana, California 92336 Phone: (909) 376-2905 or service@netaccounting-ds.com ERP Software / Business Intelligence / Programming

These are "Microsoft Analysis Services OLAP Cubes" Using Q4bis (Presentation Layer), All Views drill-down to the lowest level of detail.  Views shown are at the top level for presentation.

This view shows YTD Sales, Previous Year Sales and  Forecasted Sales.

Quadrant (1) "Top Left" shows Sales Actual and Forecasted:

• Column (1) Business Cost Center
• Column (2) Sales 2003 "Year-End"
• Column (3) Sales 2004 "Year-To-Date"
• Column (4) Forecast Sales 2004 "Year-End"

Quadrant (2) "Top Right" shows The Sales and Forecasted Sales in Graph Form:

• Columns (2-4) from above in graph form

Quadrant (3) "Bottom Center" shows The Item Category Distribution of Sales and Forecasted Sales:

• Columns Shows the Detail

This is another view which is outlining Sales Based on Commission Distribution

Quadrant (1) "Top Left" shows The Sales Representatives:

• Column (1) Sales Representatives 
• Column (2) Sales For May 2004
• Column (3) Commission Distribution for May 2004
• Column (4) is the Percent of Sales

Quadrant (2) "Top Right" shows The Geographic Distribution of Sales:

• Column (1) Geographic Location for the Commission Sales Distribution 
• Column (2) Sales in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004 
• Column (3) Commission Distribution in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004
• Column (4) is the percent of commission sales 

Quadrant (3) "Bottom Left" shows The Item Category Distribution of Sales:

• Column (1) Item Category Type 
• Column (2) Sales by Item Category in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004 
• Column (3) Commission Distribution by the Item Category in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004
• Column (4) is the percent of commission sales 

Quadrant (4) "Bottom Right" shows The Commission Dollar Distribution:

• Column (1) Item Category Type 
• Column (2) Sales by Item Category in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004 
• Column (3) Commission Distribution by the Item Category in "California and Nevada" for Sales Rep KBRW (NC) for the Month of May 2004
• Column (4) is the percent of commission sales 

This view outlines Accounts Payable Due on a Weekly Buckets

Quadrant (1) "Top Left" shows The Accounts Payable based on Weekly Buckets:

• Column (1) Week A/P Allocation 
• Column (2) A/P Open Amount

Quadrant (2) "Top Right" shows The A/P Vendor Type:

• Column (1) Vendor Type which can be expanded to show the next level etc. 
• Column (2) Amount Open For this Vendor Type as of Week 32  

Quadrant (3) "Bottom Left" shows The A/P Vendor:

• Column (1) Vendor Number and Name 
• Column (2) Amount Open for Week 32

Quadrant (4) "Bottom Right" shows The Commission Dollar Distribution:

• Column (1) Items being measured "Open and Gross"
• Column (2) Open and Gross Values

This view Displays an Income Statement "This particular Cube is in Real-Time"

Quadrant (1) "Top Left" shows Income Statement (can be switched to Balance Sheet with a click of a button):

• Column (1) Income Statement Section 
• Column (2) Respective Values for 2004
• Column (3) Respective Values for 2003
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (2) "Top Right" shows The Income Statement Graph:

• Graphs 2004 and 2003 ending values

Quadrant (3) "Bottom Left" shows The Cost Center Distribution:

• Column (1) Cost Center 
• Column (2) Income by Cost Center Current Year
• Column (3) Income by Cost Center Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (4) "Bottom Right" shows The Financial Dollar Distribution:

• Column (1) Financial Item
• Column (2) Financial Item Current Year
• Column (3) Financial Item Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

This view Displays Inventory Movement for the Last 5 Years

Quadrant (1) "Top Left" shows Month COG Distribution:

• Column (1) Month 
• Column (2) Thru Column (4) are the Yearly Buckets
• Column (3) Respective Values for 2003
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (2) "Top Right" shows The COG Distribution in Graph Form:

• Graphs Yearly Buckets ending values

Quadrant (3) "Bottom Left" shows The Cost Center Distribution:

• Column (1) Cost Center 
• Column (2) Thru Column (6) are the Yearly COG Buckets
• Column (3) Income by Cost Center Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (4) "Bottom Right" shows The Financial Dollar Distribution:

• Column (1) Financial Item
• Column (2) Financial Item Current Year
• Column (3) Financial Item Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

This view Displays Sales for the Last 5 Years

Quadrant (1) "Top Left" shows Balance Sheet (can be switched to Income Statement with a click of a button):

• Column (1) Balance Sheet Section 
• Column (2) Respective Values for 2004
• Column (3) Respective Values for 2003
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (2) "Top Right" shows The Income Statement Graph:

• Graphs 2004 and 2003 ending values

Quadrant (3) "Bottom Left" shows The Cost Center Distribution:

• Column (1) Cost Center 
• Column (2) Income by Cost Center Current Year
• Column (3) Income by Cost Center Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Quadrant (4) "Bottom Right" shows The Financial Dollar Distribution:

• Column (1) Financial Item
• Column (2) Financial Item Current Year
• Column (3) Financial Item Prior Year
• Column (4) Respective Dollar Variance
• Column (5) Respective Percent Variance

Want to see more Please contact us at: info@netaccounting-ds.com