Multiple Scenario Chart Control
- Migration (Unlicensed)
- Nadica Gaber (Unlicensed)
- Andy Heller (Deactivated)
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/CXO/pages/2806776443 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
| Setting | Description | Mandatory |
|---|---|---|
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
| Setting | Description | Mandatory |
|---|---|---|
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 |