Period stream mode allows you to compare two streams of data side by side, e.g., sales vs. budget, for selected date ranges (like a combination of Period mode and Stream mode)
Info
Period Stream mode is only available when streams exist for the database and dimension you have selected. Period Stream mode is not always enabled. It can enabled by an advanced administrator with permission.
Info
You must select a dimension to activate this mode; it is not available in Summary view.
Period Stream mode allows you to compare two streams of data (datasets) side-by-side, such as your sales vs. budget, for selected date ranges. It is like a combination of Period mode and Stream mode. It displays selected current and 'previous; results, along with Variance with Variance and percentage variance columns.
Period stream mode is not always enabled, but if it has been enabled for your site you'll see it in the modes menu once you select a dimension.
The following example uses Period Stream mode in the Sales database to compare sales with orders for the last
3 Select
three months, for a selection of customers.
From the 'Sales' database select 'Ship to' dimension and select customers.
Click the Customer dimension, select the customers, then click the Focus button. 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 current period.
Click Period > Last 3 months.
Select
Click Mode >Period
stream, as shown below. An additional button will now appear to
Stream. The Variance Stream menu becomes available on the right of the
standard 'sales' stream button. In this example the additional stream 'orders' has been selected. Image Removed As shown below, the grid will display results for sales and orders
Stream menu.
Click Variance Stream > Orders. The grid updates to display the sales and orders data, both as total and for each
month. Variance is also displayed,
of the last three months. It also displays the variance between them (as an amount and
as a
percentage).
Image Modified
Insert excerpt
Variance mode
Variance mode
nopanel
true
Info
Only one measure can be used in Period Stream mode
Note about Custom mode columns in Period Stream mode
When you are in Period Stream mode, the column headings in the Custom Mode window show the 'grouping' title first, followed by the individual column title, separated by a 'pipe' character (such as 'Total|Sales' in the image below). If you are changing the title for the grouping, you need to change it for all the columns that are in that group.