Multiple Scenario Chart Control

Owned by Migration
Last updated: Apr 19, 2016 by Nadica Gaber (Unlicensed)
2 min read

Introduction

The Multiple Scenario Analysis Control is designed to give the maximum amount of information about one single account in a Chart format. For the selected account values are shown using multiple scenarios for the selected year in a series of Bars and Lines.

CONTENT

Settings

The report settings define the look & feel and behaviour of the control.

Content Settings

Setting

Description

Mandatory

Item Selector

A list of items that will be used as a Pick List in the report. Each item can be a combination of members from the dimensions associated with the list. Usually, the Account dimension is used. The pick luist defines which which account or other Dimension Member is analysed.

Yes

Default Selected Item

Indicates the /wiki/spaces/CXO64/pages/625869218 from the pick list that will be selected / highlighted upon opening of the report

No

Scenarios

The Scenarios list defines the series of the chart. For each Line, Bar or Area a list item is required. The following 5 paramaters refer to Items from this List. The list items that are not referred in the following 5 parameters will be automatically put in the reference catagory selector which determines the (orange) Area Chart (See 2. In the screenshot)

Yes

Until Current Period

Defines the light blue bars in the chart. The light blue bars are shown for the periods that equal or are before the current period. Normally this chart series is filled with actuals current year.

No

Beyond Current Period

Defines the dark blue bars in the chart. The light blue bars are shown for the future periods. Normally this chart series is filled with a forecast or budget category.

No

Line 1,2,3

Defines the chart series for the three lines in the chart. The lines can be used to show scenarios from the Scenarios list, selected for parameter number two. (ie. previous year, yearend forecast, rolling forecast, etc.)

No

Time Series

List of items that determines the X-axis of the chart; usually a Time-series associated with the Year and the Period dimension.

Yes

Labels, Formats and Colors settings

SettingDescriptionMandatory

Labels Intersect Action

Select the action that will be undertake to prevent overlapping X-axis labels (wrap, rotate...etc.)

Yes

Rotate Labels

When the Labels Intersect Action is set to None ( see above) then the orientation of labels can be chosen here from the options (clockwise, Countertclockwise,Horizontal)

Yes

Scale

Defines the scaling used in the report (Unchanged, Thousands, Millions, Billions, Percentage)

Yes

Precision

Defines the number of decimals used for presenting the number.

Yes

Other

SettingDescriptionMandatory

Legend Position

Defines the position of the chart legend (Bottom, Right, etc.)

Yes

Legend Size

Defines the legend size which is the percentage of the chart size. This setting will be ignored if the legend position is set to Do not show.

Yes