Difference between revisions of "Business Charts"

Line 1: Line 1:
<span id="Variance" />
+
<span id="Variance"><span/>
 
== Absolute Variance ==
 
== Absolute Variance ==
  
Line 7: Line 7:
 
|}
 
|}
  
<span id="VariancePercentLolliplot" />
+
<span id="VariancePercentLolliplot"><span/>
 
== Relative Variance (%) ==
 
== Relative Variance (%) ==
  
Line 15: Line 15:
 
|}
 
|}
  
<span id="ValuesWithVarianceOffsetBar" />
+
<span id="ValuesWithVarianceOffsetBar"><span/>
 
== Integrated Variance ==
 
== Integrated Variance ==
  
Line 23: Line 23:
 
|}
 
|}
  
<span id="ValuesWithVarianceArrow" />
+
<span id="ValuesWithVarianceArrow"><span/>
  
 
== Indicator Comparison ==
 
== Indicator Comparison ==
Line 32: Line 32:
 
|}
 
|}
  
<span id="ValuesCompare" />
+
<span id="ValuesCompare"><span/>
  
 
== Offset Comparison ==
 
== Offset Comparison ==
Line 41: Line 41:
 
|}
 
|}
  
<span id="ValuesWithForecastTwoColumns" />
+
<span id="ValuesWithForecastTwoColumns"><span/>
  
 
== Business Scenario ==
 
== Business Scenario ==
Line 50: Line 50:
 
|}
 
|}
  
<span id="Waterfall" />
+
<span id="Waterfall"><span/>
  
 
== Waterfall ==
 
== Waterfall ==
Line 59: Line 59:
 
|}
 
|}
  
<span id="WaterfallPeriodComparison" />
+
<span id="WaterfallPeriodComparison"><span/>
  
 
== Variance Waterfall ==
 
== Variance Waterfall ==
Line 68: Line 68:
 
|}
 
|}
  
<span id="ValuesCompareLines" />
+
<span id="ValuesCompareLines"><span/>
  
 
== Trend Comparison ==
 
== Trend Comparison ==
Line 77: Line 77:
 
|}
 
|}
  
<span id="ValuesCompareLinesCumulative" />
+
<span id="ValuesCompareLinesCumulative"><span/>
  
 
== Trend Comparison (Cumulative) ==
 
== Trend Comparison (Cumulative) ==

Revision as of 14:42, 6 July 2020

Absolute Variance

MC Variance.png
Displays the variance between two values, often between the budget and actual values.

Relative Variance (%)

Displays the relative variance between two values.
MC VariancePercentLolliplot.png

Integrated Variance

MC ValuesWithVarianceOffsetBar.png
Shows the actual and variance in the same chart with colour indicating the direction of the variance.

Indicator Comparison

Shows actual and target values in one chart. The arrow position and colour indicate the target value and direction of the variance.
MC ValuesWithVarianceArrow.png

Offset Comparison

MC ValuesCompare.png
Shows actual and target values in one chart. The actuals are prominent while the target values can still be referred to.

Business Scenario

Shows actual and forecats values in one series. By default the actual values are used where available otherwise the forecast is show, however you can specify the first forecast member to override this behaviour.
MC ValuesWithForecastTwoColumns.png

Waterfall

MC Waterfall.png
Show the structural breakdown of business attributes. Totals and sub-totals can be specified either on individual elements (right-click) or using member properties if available in the cube.

Variance Waterfall

Specialised waterfall chart to show the breakdown of a change by a business attribute. Select the time periods to analyse and then the attribute to show detail by.

Outputting cells If you have split by a different category hierarchy and want to output the category to excel then you can pick a range of two cells to put the values in. The first will contain the date member, the second the split-by member.
MC WaterfallPeriodComparison.png

Trend Comparison

MC ValuesCompareLines.png
Shows two time series and their variance, colours indicate direction of the variance.

Trend Comparison (Cumulative)

Shows two time lines as cumulative totals, and indicates the total variance over time.
MC ValuesCompareLinesCumulative.png

See also

Dynamic Chart Ribbon

Dynamic chart formatting pane