Info-Explorer Cube Samples

To use: Go to Properties > Cubes > SQL Query and replace 'ORCIN2' with your Company 2 database ID. There are 4 parts to the query, linked by UNION ALL.  The first two uses the cube connection details, the last two need the 2nd database name in the query. 

This cube requires Info Explorer Full or Writeback licence.

To use: Go to Properties > Cubes > SQL Query and replace 'ORCIN2' with your Company 2 database ID. There are 2 parts to the query, linked by UNION ALL.  The first one uses the cube connection details, the second needs the 2nd database name. 

This cube requires Info Explorer Full or Writeback licence.

AP Payment by Vendor, including payment codes

Cube shows all Accounts Payable transactions, grouped by GL Account number, transaction type and distribution code. Also includes AP Vendor Group and Vendor Account Set. Drill down to Vendor Activity screen. 

Writeback enabled GL Budget cube

Includes Multiple years and budget sets.

Inserts and updates Budget details

Stock Turnover cube, including stock without sales in prior periods (requires Info-Explorer Full or Writeback licence). 

IC Stock Aging cube, including detail by transaction. (Requires Info-Explorer Full or Writeback licence - Installation of an SQL Stored Procedure. Sage 300 partners can refer to the KnowledgeBase article.)

AP Outstanding balances cube, by vendor and year, including ranks. 

AR Outstanding transactions cube, by customer, sales person, including ageing. 

Cube to display all Bin Transfers by status (not ready for pick/put away, ready for pick/put away, in progress and complete).

Includes the Source Document Type and Number, Bin Transfer Number, Item Number, Status, Description and Comments from the Bin Transfer and Pick and Put Away quantities.

Drill through to the Bin Transfer Document (via BT Number dimension) and Item screen (via Item Number dimension).

Review all unposted batches in General Ledger and sub-ledgers and drill through to the underlying Sage 300 transaction screen with this cube

Cube displays all Open Bin Transfers by status (not ready for pick/put away, ready for pick/put away and in progress).

Includes the Source Document Type and Number, Bin Transfer Number, Item Number, Status, Description and Comments from the Bin Transfer and Pick and Put Away quantities.

Drill through to the Bin Transfer Document (via BT Number dimension) and Item screen (via Item Number dimension).

RMA cube compared to OE Sales history details. (with date parameters).

Works with Orchid Return Material Authorizations module activated. 

PJC Revenue and Costs, actual vs budget. (Cube includes source and functional currencies for revenue figures.)

Sample Info Explorer cube on the VILOG table (logon, batch status, View field changes). Use in conjunction with Extender Sample script to log Batch creation and updates and Extender Log events. 

Technisoft Service Manager Sales by Customer and Item/Service cube

Orchid RMA analysis by workflow stage, RMA Status and fault code. Cube includes drill down to Sage 300 RMA screen. 

Project and Job Costing Transactions cube

Project and Job Costing Summary cube

Purchase Order Analysis cube, by Expected Arrival Date, by Vendor, by Location. 

Drill through to the A/P Vendor Activity and Purchase order screen is enabled. 

US Payroll Check Register cube

Canadian Payroll Cheque Register cube - Now includes analysis by Employee Earnings Category

Sales Analysis cube based on Order Entry Invoice and Credit note tables. Includes items and miscellaneous charges. 

Transactions are grouped by Customer, Customer Group, Customer State, Items and Item categories. Includes customers and items ranked by Sales revenue and Credit note value. 

Order Entry Back Order Action cube includes outstanding orders by Customer and items. Also includes Orders on  hold, orders by item location and by Ship via. 

Orders can be aged by expected shipment date and by order date.   

Shows OE Net Sales History by Customer and Item from an entered parameter for the Start Year.

Totals are grouped together by Customer, Customer Group, Item, Item Category, Item Account Set and Sales Person.  Can drill through to Item (via Item Number dimension) and Customer Inquiry (via Customer dimension).  Sales Rank, Margin % and Percent of Total Column calculated by the cube.

Cube for IC Quantity on hand, on PO, on SO with calculated re-order quantities

Cube for IC Quantity on hand, on PO, on SO by expected shipment/arrival date

Writeback-enabled Item Projected Sales cube

Writeback-enabled GL Budget cube

Writeback-enabled Customer and Item Budget cube

To use: Go to Properties > Cubes > SQL Query and replace 'SAMLTD' with your Company 1 database ID and 'ORCLTD' with your Company 2 database ID. There are 4 parts to the queries, linked by UNION ALL

Note: The cube now includes the Opening balance from GLAFS. You can't add multiple years on the Consolidated balance sheet view. 

This cube requires Info Explorer Full or Writeback licence.

GL Accounts Detailed analysis for a single Fiscal year (as per cube parameter). 

Includes Trial Balance, Income Statement and Balance Sheet. Transactions are grouped by G/L Segments and Source Codes. Also includes Journal Description and reference

Drill through to the G/L Batch entry is enabled. 

GL Actual vs Budget Account Analysis cube, including traffic light reporting on actual vs budget variance and year on year comparison. 

Auto Simply Manufacturing Orders History cube

Auto Simply Manufacturing Orders Detail cube

Cube shows all open Accounts Receivables transactions, grouped by future due date for cashflow analysis based on the Invoice Due Date and the entered parameter for “Age as of date”. 

Transactions are grouped by Customer and Customer Group.  Can drill through to document entry (via Document Number dimension) and Customer Activity via (Customer dimension)

A/R Transactions by A/R Items and G/L Accounts cube. Includes Margin by Items, Customer Groups and Documents. 

Shows all AR Transactions by GL Account from an entered parameter for the Start Year.

Transactions are grouped together by Customer, Customer Group, Customer Account Set and GL Account.  Can drill through to document entry (via Document Number dimension) and Customer Inquiry (via Customer dimension).  Revenue Rank and Percentage of column calculated by the cube.

Cube shows all open Accounts Payable transactions, groups the transactions by Due Date period based on the Invoice Due Date and the entered parameter for “Age as of date”. 

Transactions are grouped by Vendor and Vendor Group.  Can drill through to document entry (via Document Number dimension) and Vendor Activity (via Vendor dimension). 

Cube shows all Accounts Payable transactions in the date range.  Transactions are grouped by  GL Account number, Transaction Type and Distribution code of the invoice detail lines.  Drill down to Vendor Activity (via Vendor dimension) and AP Document (via Invoice No dimension).