Switch modes
Last updated
Was this helpful?
Last updated
Was this helpful?
Use the Modes menu in the toolbar to switch between the . Each mode is a pre-defined view of data that displays particular columns in the grid, as outlined below. The Other modes option takes you the Analytics modes.
Flexible Variance mode shows variance data and is useful for making comparisons over time.
Although it has a similar purpose to the variance modes in Analytics, as the name implies, it's much more flexible. You can determine what's driving the variance by selecting two different periods; you're not restricted to comparing a Current and Previous period. You can also view the breakdown of a particular period in detail, so in effect, you can view data for three different periods in the one grid.
Period 1 and Period 2: These menus allow you to compare any two periods to analyze various scenarios.
Period (breakdown): This additional period menu allows you to view a breakdown of the data across a particular timeframe. You can look closely at what’s happening and see if the data is trending in the right direction. The breakdown period can be the same one you selected for Period 1 or Period 2, or another period.
This mode does not have a Summary view of the grid, only a dimension view. By default, the first dimension is selected. The grid contains the following columns and column groups:
Code and Name: These property columns display the code and name of the entities in the selected dimension. You can add other properties as required using the Properties menu. For example, if you select the Customer dimension, you might want to add the Country and Region properties to see more details about each customer.
Comparison group: This column group displays data for the periods selected in the Period 1 and Period 2 menus (from the selected stream and measure). This data comes from your ERP. From this data, the variance is calculated:
Variance (Period 1 - Period 2): This is a calculation column showing the results of the variance calculation.
% Variance ((Period 1 - Period 2) / Previous)*100: This is a calculation column showing the results of the variance percentage calculation.
Breakdown group: This column group contains:
A Total column showing the total of the data in the breakdown period columns. It also shows sparklines giving you a quick, visual summary of the data across the breakdown period.
Repeated columns which have the same structure (same stream, measure, and period) for the period selected in the Period (breakdown) menu. For example, if you select the Last three months, you’ll see a column for each of the three preceding months.
Flexible Period mode is similar to Period mode in Analytics, however, as the name implies, it lets you do more flexible period-based analysis.
This mode as two grid views: Summary and Dimension.
In Summary view, the grid gives you an overview of your data across the selected period. There are seven columns, starting with the Period column that displays the relevant time unit (day/month/year) for the selected period. For example, if the period is Last 3 Months, those three months display. The other columns are: Current (period), Current Cumulative, Previous (period), Previous Cumulative, % Variance and % Variance Cumulative.
When you select a dimension, the grid displays columns for the active properties (such as Code and Name) for that dimension, a Total column, and a column for each time unit in the period. This new layout gives you a month-by-month or day-by-day view of your data, for example. If more than one measure is selected, more columns will display.
Flexible Total mode is similar to Total mode in Analytics, however, as the name implies, it lets you do more flexible analysis of the Total values in the dataset. This is the simplest mode available, giving you the most basic view of the data. It's particularly useful when you have multiple measures selected.
This mode as two grid views: Summary and Dimension.
In Summary view, the grid displays the relevant time unit (day/month/year) within the current period, plus a Total column. If more than one measure is selected, more columns will display.
When you select a dimension, the grid displays columns for the active properties (such as Code and Name) for that dimension, plus the Total column and columns for any additional measures.
Along with the , three Period menus offer a versatile exploration of variances in your data:
This mode has the .
This mode has the .
