Phocas has a new user documentation site. This site will be retired soon.

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 21 Next »

Dimensions are data sets that appear as buttons down the left of the screen. The dimensions displayed depend on the database you are in, e.g., in a sales database you might see customers, products, sales reps, regions, vendors, etc, while in an inventory database you might see supplier, warehouse, country, etc. 

Related articles

Selecting a dimension

When you select a dimension it turns blue and the data displayed in the grid changes accordingly. In the image below, the 'Products' dimension has been selected and the grid displays product data.

 What is displayed 

  • Columns are sorted by total in ascending order.
  • Negative figures are shown in red.
  • Cells that do not contain data are shaded green.
  • If the data in the Code column is blue it indicates a link is available.
  • Dimensions that have selections will be indicated by numbers in brackets. 

Sub groups

Some dimensions have a subset (group) of dimensions. E.g., in the image below 'Product group' and 'Category' are grouped under 'Products'.  

Dimension properties 

Properties (dimension metadata such as name, code, customer address, etc) are displayed as columns. By default, Phocas displays code and name. To display more properties simply tick as required from the Properties menu, or create your own custom property. 

Learn more about properties 

Clearing selections from a dimension

Once you select a row, or rows, a 'clear' option (shown with an 'X') appears to the right of the relevant dimension, as shown below. You do not need to have the relevant dimension active in order to clear.  

Select multiple dimensions  

You can easily slice and dice data in Phocas by selecting multiple dimensions - in effect, combining dimensions. 

Step 1. Select a dimension and focus on some data. Selecting without focusing gives you the same information; however, focusing removes other data from view and retains the selection when you move to the next dimension. 

Step 2. Select a second dimension. What you see now depends on your previous selections, e.g. if you select and focus on sales reps 'Fred' and 'Daisy', and then move to the 'Customer' dimension, only customers who have purchased from 'Fred' and 'Daisy' will appear. 

 

Example 

'Which customers are buying items supplied by a particular vendor from sales rep Alan in the South East region?' This question can be answered by following the steps below: 

  1. Select 'Sales Rep' dimension and choose 'Alan'. Focus. 
  2. Select 'Vendor' dimension and choose any vendor. Focus.
  3. Select 'Region' dimension and choose South East. Focus.  
  4. Select 'Customer' dimension to view the results of your analysis. 

    You will see a list of customers in the South East who are buying items from 'Alan' that came from your chosen vendor. Dimensions that have selections are indicated by numbers in brackets next to the dimension name.     
     

Default settings for dimensions 

When you first select a dimension the data shown depends on the default settings for the database. 

Sales database defaults

In a sales database, which is one of the most common databases in Phocas, the default columns are:

The columns displayed will change as you select different periods, modes, properties and so on.

 


  • No labels