PANTHEON™ Help

 Toc
 PANTHEON Help - Welcome
[Collapse]PANTHEON
 [Collapse]Guides for PANTHEON
  [Collapse]Guide for PANTHEON
   [Expand]Settings
   [Expand]Orders
   [Collapse]Goods
    [Expand]Mass Printing
     Integration PANTHEON with WebShops
    [Expand]Issue
    [Expand]Receiving
    [Expand]Single Administrative Document (SAD)
    [Expand]Transfer
    [Expand]Price change
    [Expand]Inventory count
    [Expand]Recurrent Invoicing
     Create Consignment Report
    [Expand]Prepare cash discount
    [Expand]Custom warehouses
    [Expand]Stock
    [Expand]Trošarinska skladišča
    [Expand]Material Movements
    [Expand]Income/Expense Comparison
    [Collapse]Invoices Issued Report
     [Expand]Invoices Issued/Profit Margin Report
      Special Payment Orders
     [Expand]Browse DDV-VP Forms
     [Expand]Commercial Records
     [Expand]Reports on Packaging and Packaging Waste
     [Collapse]ZEUS Sales
      [Expand]OLAP Sales cube dimensions
      [Expand]Reports
       OLAP Sales cube measures
      Kako uporabimo predlogo
     [Expand]Processing Center
    [Expand]Invoices Received Report
    [Expand]Value-Added Tax
    [Expand]Overview of Material Movement
    [Expand]Summary Reports
    [Expand]Refresh Stock
   [Expand]Manufacturing
   [Expand]POS
   [Expand]Service
   [Expand]Financials
   [Expand]Personnel
   [Expand]Analytics
   [Expand]Desktop
   [Expand]Help
   [Expand]Messages and Warnings
   [Expand]Additional programs
   [Expand]Old products
  [Expand]Guide for PANTHEON Retail
  [Expand]Guide for PANTHEON Vet
  [Expand]Guide for PANTHEON Farming
 [Collapse]User Manuals for PANTHEON
  [Expand]User Manual for PANTHEON
  [Expand]User Manual for PANTHEON Retail
  [Expand]User manual for PANTHEON Vet
  [Expand]User Manual for PANTHEON Farming
[Collapse]PANTHEON Web
 [Collapse]Guides for PANTHEON Web
  [Expand]Guide for PANTHEON Web Light
  [Expand]Guide for PANTHEON Web Terminal
  [Expand]Guide for PANTHEON Web Legal
  [Expand]Old products Archive
 [Collapse]User Manuals for PANTHEON Web
  [Expand]Getting started PANTHEON Web
  [Expand]User Manual for PANTHEON Web Light
  [Expand]User Manual for PANTHEON Web Terminal
  [Expand]User Manual for PANTHEON Web Legal
  [Expand]Old products Archive
[Collapse]PANTHEON Granules
 [Collapse]Guides for PANTHEON Granules
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]Dashboard Granule
  [Expand]B2B Orders Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
 [Collapse]User Manuals for PANTHEON Granules
  [Expand]Getting started
  [Expand]Personnel Granule
  [Expand]Travel Orders Granule
  [Expand]Documents and Tasks Granule
  [Expand]B2B Orders Granule
  [Expand]Dashboard Granule
  [Expand]Field Service Granule
  [Expand]Fixed Assets Inventory Granule
  [Expand]Warehouse Inventory Granule
  [Expand]Archive
[Expand]User Site

Load Time: 1015.607 ms
"
   5361 | 6092 | 340320 | Updated
Label

OLAP Sales cube measures

Metrics

010382.gif010383.gif

 

OLAP sales cube contains the following measures (the table below contains detailed description of individual measure):

 

LABEL UNIT MEANING FORMULA EXAMPLE OF USE
Quantity Item unit of measurement quantity   How many items from category x were sold in described period.
Packages Item unit of measurement Quantity of packages   How many packages of item x were sold in described period.
Value Currency Value   What was the value of sold items.
Price Currency Price Value / Quantity What is the average price of sold items.
Purchase Price Currency Purchase price Purchase Value / Quantity What is the average purchase price of sold.
Gross profit (GP) Currency Difference in value Price difference x quantity sold Which sold items achieved the largest gross profit  in described period.
Gross margin (GM) Currency Difference in price Sale price - purchase price** What was the gross margin of sold items.
Gross profit/value (GP/value) % difference in value per value as percentage (difference in value / value) * 100 How did the per unit gross profit (%) on the value of the sale of item x fluctuate over the last 5 years?
Purchase Value currency purchase value   What was the purchase value of sold items.
Gross profit/cost (GP/cost) % difference in value per purchase value as percentage (difference in value / purchase value) * 100 How did the per unit gross profit (%) on the purchase value of the sale of item x fluctuate over the last 5 years?
Number of purchases   number of customer's (or consignee's***) purchases Number of positions on invoices How many purchases of sold item were made?
Average number of items/invoice   Average number of items in invoices   What was the average number of sold items on invoices?
Average number of categories/invoice   average number of categories in invoices    What was the average number of categories on invoices?
Average amount/invoice Currency  the average amount of a customer's (or consignee's***) purchases  Value / number of invoices Which customers purchase the greatest amountof goods at once?
Change in quantity Unit of meaurement     Quantity of item stock after all the purchases and sales on seleted period.
Change in value Value      Value of item stock after all the purchases and sales on seleted period

* - sale value

** - purchase value plus costs; own price

*** - depends on option selected in the By box in preferences and tools.

 

000001.gif Gross profit (GP) is calculated as an average value not as a summary.

 

 

Instructions for Use

Related Topics:

 


 

Rate this topic
Was this topic usefull?
Comments
Comment will also bo visible in forum!