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.
Along with the standard toolbar items, three Period menus offer a versatile exploration of variances in your data:
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.
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.
Coming soon
Coming soon
