PERFORMANCE CANVAS

The Best Practice in Financial Control - EPM, CPM, Budgets, Reports, Plans, Dashboards, KPI Management, Scorecards & Consolidation

User Tools

Site Tools


pe:configurewebpart:selecttype

Select Web Part Type

Available choices in this step are different depending on if you enter the wizard from the desktop or from the tool pane in the web part page. Image below shows how it looks if you have started the wizard from the desktop. Instead of starting the wizard from the desktop, we recommend browsing to the page, where you want to add the web part and then add and configure your web part there. See How to add web part.

To create a SharePoint 2003 web part select SharePoint Services in the Select Web Part Group drop down list and then select the type of web part you want to create in the Select Web Part Type list. If you select the Chart type you also select with type of chart in the Select Web Part Sub Type. Click Next to start configure your web part.

Available Web Part types

- Chart Web Part (Column, Column Line, Gauge, Line, Pie, Stacked Area, Stacked Column)
- Table Web Part
- Trend Web Part
- Z Graph Web Part
- Filter Web Part


Chart

In this step you select which type of chart to use for the web part. You can choose between Column, Column Line, Gauge, Line, Pie, Stacked Area or Stacked Column.

  • Select the type you want to create in the Select Web Part Sub Type list, then click Next.
  • If the web part already have a data source configured, the Change Connection Settings will be enabled. Select the check box to change the connection, then click Next to select or configure a new data source for the web part.

Chart Examples

  • Chart - Column - displays measure Actual with Quarters as categories and Product as series.
  • Chart - Column/Line - displays measure Actual, Actual LY and Budget as series. Time (Year - month no) as categories and it is filtered on Food and Canada.
  • Chart - Gauge - displays a measure Rate filtered on USA, All Product and 2004.
  • Chart - Line - displays measure Actual and Budget as series and Month as categories. It is filtered on Drink and All Warehouse.
  • Chart - Pie - displays Actual sales per Product for All Warehouses.
  • Chart - Stacked Area - displays Actual Sales over Time (Month) per Product filtered on Mexico.
  • Chart - Stacked Column - displays Actual Sales over Time (Month) per Product filtered on Mexico.


Table/Trend/Z Graph/Filter(Selector)

  1. There is no sub type, so just select Next to go to next step.
  2. If the web part already has a data source configured, the Clear Connecting Setting will be enabled. Select the check box to clear the connection and then click “Next” to select or configure a new data source for the web part.
  • Table
  • Trend
  • Z Graph
  • Filter(Selector)

Table/Trend/Z Graph/Filter(Selector) Examples

  • Table - Actual, Budget and Variance on columns and Product on rows filtered on 2004. Variance is a calculated measure in the cube and has its ForeColor property set to be red on values below 0. See example of how to use cell format properties.
  • Trend - having Quarter as time line and filtered on state CA.
  • Z Graph - compares Actual to Budget per Month, Year to date and Rolling 12.
  • Filter (Selector)

    The Filter (Selector) is used to provide filter values to connected web parts.
pe/configurewebpart/selecttype.txt · Last modified: 2014/02/28 01:33 by pcevli