Select a dimension
Step 2. Select a dimension. The selected dimension button will turn blue and the data displayed in the grid will change accordingly. In the image above, the 'Products' dimension has been selected and the grid displays product data.
- 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.
Combine dimensions
You can easily slice and dice data in Phocas by combining dimensions.
Step 1. Select and focus on a dimension. Selecting without focusing results in the same information; however, focusing removes other data from view.
Step 2. Select a second dimension. The resulting records displayed will depend 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:
- Select 'Sales Rep' dimension and choose 'Alan'. Focus.
- Select 'Vendor' dimension and choose any vendor. Focus.
- Select 'Region' dimension and choose South East. Focus.
- Select 'Customer' dimension to view the results of your analysis.
You will see a list of customers in the grid, as shown below. These are the 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 displayed will reflect the default settings for dimensions in that database. The row number is always the first column. The other columns are based on default settings, sorted by total in ascending order.
Sales database defaults
In a sales database, which is one of the most common databases in Phocas, the default columns are:
Period: Default
Mode: Period
Properties: Code, Name
Stream: Default
Filter: Sales value
Measure: Sales value
Format: Actual
The columns displayed will change as you select different periods, modes, properties and so on.
Adding or changing dimensions
Dimensions can be added or changed by an administrator.