Chart and graphs can be created on a Form. To create a chart, you should first have a Form that renders data. Highlight a region of cells on the Form and select the CHART & GRAPH button.
The Generate Chart dialog box will be open.
By default, a column chart is generated using the selected cells as data source. You can change the settings on the right panel and preview the changes on the left.
Define Data Source
To use the whole form as the source, change the Type of Data Source to Dynamic.
Custom type will allow you to specify your own MDX as the source. If this option is selected, click Definition at the top right of the chart to enter the MDX definition.
The following options are available to configure the data source.
Filter: Filter property determines whether to apply the current filter selection on the form to the charting data. When checked, filters on the form will be applied.
Flip Axis: Flip axis will reverse the current order of the axis definition within the MDX by placing row definition to column, and column definition to row. This feature is useful when choosing the pie chart that takes in only one axis. When axis is flipped, you can display from the other axis.
Hide Empty: When checked, only members with data will be available on the chart.
Note: You have to decide the Data Source Type when creating the chart. It cannot be changed later.
Chart Display Settings
Chart display is configurable. You can define the chart type, display color palette, and property. You can also configure the title and its size, data type of the axis, chart margin, and the like.
In Column chart or Line chart, there are two additional options available on the chart itself by right clicking over a bar or a line.
Convert to Lines (Columns): Convert the selected column/line to a line/column.
Toggle Axis: Add the Y2 axis to the right end of the chart for the selected line/column. Use this option to create advanced charts with two Y-Axis.
Click OK and you will see the chart.
You can create multiple charts on the Form by clicking on the Form View button on the bottom-right to return back to Form mode and repeating the previous process.
Editing a Chart - To edit a chart, select the chart in the explorer panel and click on the EDIT button.
Add More Charts - You can create multiple charts on the Form by clicking on the Form View button to return back to Form mode and repeating the previous process.
Order Charts - You can also reorder the charts by using the UP and DOWN buttons to organize the charts.
Remove Charts - To remove a chart from a Form, you can select the chart to remove and click on the REMOVE button.
All Forms saved to the Model will contain a history of its previous definitions. These historic Form definitions can be restored to the current version by clicking on the Restore action under the Historic column.
The Restore window allows you to choose a version of the Form to restore from. By clicking on Restore, the Form will be opened in the MODELER in EDIT mode. After reviewing the Form, you can choose to save the Form by clicking on the SAVE button for the Modeler.