LogoLogo
  • CHARTS USER GUIDE
    • Introduction
    • Angular Gauge Chart
    • Bar/Column Chart
    • Bubble Chart
    • Bullet Chart
    • Calendar Heatmap Chart
    • Column Range Chart
    • Combination Chart
    • Dumbbell Chart
    • Filter Chart
    • Funnel Chart
    • Grid Chart
    • Table heatmap
    • Histogram Chart
    • KPI Animation Chart
    • KPI Ring Chart
    • Line/Area line Chart
    • Mekko Chart
    • Packed Bubble Chart
    • Pie Chart
    • Polar Charts
    • Sankey Chart
    • Simple KPI Chart
    • Slope Chart
    • Sparkline Chart
    • Stacked Column/Bar
    • Text Node
    • Tornado Chart
    • Trellis Chart
    • Variwide Chart
    • Waffle Chart
    • Waterfall Chart
    • Wordcloud Chart
    • Workstation
    • Allow/Block URLs
    • Animation Duration
    • Attribute Forms
    • Auto Scroll
    • Axes
    • Background Images
    • Backward Compatibility
    • Bar/Column Width
    • Color Picker with Opacity
    • Connect Null Points
    • Custom Markers
    • Custom SVG Markers
    • Data Markers
    • Data label customization
    • Dossiers/Documents differences
    • Drilling
    • Error Bars
    • Export to PDF
      • Export engine local resource set up
    • Formatting metric data
    • Gradient Threshold
    • Legend
    • Negative Sign
    • Pattern Fill
    • Play Animation
    • Plot lines/Reference lines
    • Reset color property
    • Reset font properties
    • Right Click Menu
    • Right-to-left Support
    • Series using Attribute
    • Small Multiples
    • Smooth Line
    • Tooltip Customization
    • Tooltip Links
  • GRID/MICROCHART GUIDE
    • Appearance
    • Auto Size
    • Column Totals
    • Context Menu
    • Creating a micro chart
    • Custom markers
    • Custom Editor
    • Filter Data
    • Format/Clear Format
    • Grand Total
    • Pivoting and Row Grouping
    • Horizontal Bars/Pins
    • Embed Images
    • Manage Scaling Grouping
    • Manage Column Grouping
    • Manage Metric Grouping
    • Pin Column
    • Reorder columns
    • Reset Columns
    • Show/Hide Column
    • Sorting
    • Subtotals
    • Thresholds
    • Tooltip
    • Transparency
    • Trend Lines
    • Value Aggregation
    • Variance
  • MAPS USER GUIDE
    • Creating New Maps
    • Custom Layouts
    • Customization of the Map chart
    • Default Maps
    • Formatting Options
    • Generic Merge tool
    • US map using counties data
    • US Map using ZIP Codes
  • IBCS USER GUIDE
    • IBCS
      • Why IBCS
      • Mapping IBCS Scenarios
      • Negative Metrics
      • Scaling Multiple Charts
    • CERTIFIED CHARTS
      • Multi-tier Bar chart
      • Multi-tier Column chart
      • Small Multiples
      • Vertical Waterfall
  • CUSTOMIZATION GUIDE
    • Introduction
    • Custom CSS
    • Custom CSS Samples
    • Custom Color Palette
    • Custom Fonts
    • Condensed Metric Format
    • Disable Edit button
    • Grid Custom CSS
    • Localization
  • FAQ
    • Contact Us
    • FAQS
  • INSTALL DOCS
    • Installing on MicroStrategy Web
    • Installing on MicroStrategy Desktop/Workstation
    • Installing on MicroStrategy Library
    • Installing on MicroStrategy Mobile
    • Release Notes
    • Release Notes Maps
Powered by GitBook
On this page

Was this helpful?

  1. IBCS USER GUIDE
  2. IBCS

Mapping IBCS Scenarios

Support for Planned, Actual, Previous and Forecast

According to IBCS, VitaraCharts supports the following scenarios.

  • Actual

  • Forecast

  • Previous

  • Planned

The primary scenarios are Actual and Forecast. The secondary possibilities are Planned and Previous. For the charts to function properly, at least one element (metric or attribute) of the primary scenario must exist in the mapping. At least one element of the primary scenario and one element of the secondary scenario must be mapped in order for the absolute and relative variances (deltas) to be displayed on the chart.

Actual data is always given first attention in all of the charts. If actual data for a particular category is not available, we look at forecast data for that same category. You can compare scenarios by comparing

  • Actual/Forecast vs Previous

  • Actual/Forecast vs Planned

In each of the comparisons above, representing deltas and delta percentages becomes possible.

Mapping data to the scenarios

Automatic detection

Based on the name, Vitara Charts can automatically determine which measurements or attributes fit within a given situation. In the global.txt file, you can specify what the name pattern should be. The default settings for the file, which can be found in the Vitara Charts custom folder, are as follows:

#Data Types as per IBCS standard data classification
#usage: DT.<dataType> = metricTitle1, metricTitle2 (can be both metric titles and attribute values)
#defaults included below add/change values with comma seperated
DT.AC= AC, Actual
DT.FC= FC, Forecast
DT.PL= PL, Planned
DT.PY= PY, Previous Year

The lines beginning with the # symbol are comments that describe the types of data that can be entered here. You can configure the right side of the set of lines to contain every possible way of the metrics or attribute names that fit into each of the scenarios. Regular expressions are also acceptable. Strings containing regular expressions must be enclosed in [] brackets.

Examples

As an example, if you’d like to add _AC as a suffix for all metrics that fall in the Actual scenario we can add that as follows

#Data Types as per IBCS standard data classification
#usage: DT.<dataType> = metricTitle1, metricTitle2 (can be both metric titles and attribute values)
#defaults included below add/change values with comma seperated
DT.AC= AC, Actual, [.*_AC]
DT.FC= FC, Forecast
DT.PL= PL, Planned
DT.PY= PY, Previous Year

Here’s another sample that adds different strings and patterns to each of the scenarios

#Data Types as per IBCS standard data classification
#usage: DT.<dataType> = metricTitle1, metricTitle2 (can be both metric titles and attribute values)
#defaults included below add/change values with comma seperated
DT.AC= AC, Actual, Current, TY, [.*_AC]
DT.FC= FC, Forecast, [.*_FC]
DT.PL= PL, Planned, [.*_PL]
DT.PY= PY, Previous Year, Previous, [.*_PY]

Once this mapping is done, in all of the charts, whenever this pattern is recognized, the metrics and attributes are automatically placed in each of these scenarios.

Note : The names of the scenarios in this file should not be modified (i.e. the left side that mentions DT.AC, DT.FC, and so on). While PY appears to signify ‘Previous Year,’ this scenario can reflect anything from the past (previous quarter, previous day, etc.).

Manual mapping in the properties editor

In addition to the ability to configure scenarios globally, you can also reconfigure measurements into scenarios in each particular graphic. This is done in the specific chart’s properties editor. For example, here’s a multi-tier bar chart with scenario mapping that may be altered.

PreviousWhy IBCSNextNegative Metrics

Last updated 7 months ago

Was this helpful?