Versions Compared

Old Version 8

changes.mady.by.user Helen Gosper

Saved on

compared with

New Version Current

changes.mady.by.user Denise McGettigan

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

 

 

Period stream mode allows you to compare two streams of data side by side, e.g., sales vs. budget,  for selected periods. It is like regular stream mode, but with the additional  This mode is not always enabled, but if it has been enabled for your site it will become available once you select a dimension.  

Table of Contents
maxLevel2
minLevel2

note ...how this appears in cusotm mode. need snippet here and on cusomte rmode page

  two streams of data side by side, e.g., sales vs. budget, or sales vs. orders  'like regular stream mode'

'... like a mini stream mode for every month in your period'

 

Info
iconfalse
titleRelated articles

How the grid appears in this mode

The grid displays a column for all active properties in the current dimension, plus a column for current period and previous period. Variance and percentage variance columns are also displayed. 

Insert excerptVariance modeVariance modenopaneltrue

Example

In this example we want to compare sales with budget for the last 3 Select 
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 and percentage variance columns.

Example - Use Period Stream mode

The following example uses Period Stream mode in the Sales database to compare sales with orders for the last three months, for a selection of customers.

  • From the 'Sales' database select 'Ship to' dimension and select customer (in this example, we have selected 10 customers. Focus.

    1. 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.

    2. Click Period > Last 3 months. 

    Select 

    1. Click Mode > Period

    stream, as shown below. An additional button will now appear to

    1. Stream. The Variance Stream menu becomes available on the right of the

    standard Sales stream button. Select Budget from this button.

    Image Removed

    The grid will update, as shown below, and you can compare sales with budget

    1. Stream menu.

    2. Click Variance Stream > Orders. The grid updates to display the sales and orders data, both as total and for each of the

    3 months, as well as the totals.

     

    Image Removed

     

     

     

    1. last three months. It also displays the variance between them (as an amount and percentage).

      Image Added

    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.

    Image Added

    How these columns display in the grid:

    Image Added

    On this page

    Table of Contents
    minLevel1
    maxLevel2

    Related pages