How to Create Dashboards for MyPlan

How to Create Dashboards for MyPlan

Just like other areas related to MyPlan, if is a best practice to create MyPlan Only dashboards. Once again, the dashboards should be specific and have meaningful information for casual business users. What’s important to know is when you create a MyPlan Only dashboard, the entire dashboard is what will be seen in MyPlan. Currently, you do not have ability to select certain charts or graphs to be included in MyPlan, so the entire dashboard is brought over and displayed. MyPlan currently allows up to three charts or graphs (this will change in future releases). From a security perspective, MyPlan will use the reporting and dimension security currently setup within the application. If you are unfamiliar with working with Dashboards, please see the Dashboards Admin Guide located on the help for detailed information. The two screenshots below provide examples of how we configured our demo application. We created a dashboard with three charts in the Dashboard section of the application.

How the dashboards are displayed in MyPlan:

Certain criteria needs to be considered when designing a dashboard for use in MyPlan. Future releases will allow additional functionality and flexibility, so please beware of the following topics related to best practice setup.

Shared Mode

Number of Charts and Chart Size Limitation per Dashboard

Chart Settings/Properties

Shared Mode

Once your Dashboard has been created, it must be shared with “Everyone ” in order for the charts associated within the dashboards to be displayed in MyPlan.

To share a dashboard, complete the follow steps:

Step 1: In the Planning application, access Dashboards.

Step 2: Click the 3 dots on the dashboard you want to share and select Share.

Step 3: The Share Selected page appears. Select the Contributor or MyPlan Only users to share the dashboard with.

For detailed information on dashboard sharing, see the Dashboards Admin Guide and the Dashboards End-User Guide.

Number of Charts and Chart Size Limitation per Dashboard

When you create a dashboard for MyPlan consumption, it is a best practice to create up to 3 charts, because only up to 3 charts can be displayed in MyPlan at a time (as shown above). If you add more than 3 charts, only the first 3 will be displayed in MyPlan. If you need additional charts displayed you can easily create a MyPlan configuration and configure two sections to display chart data. Because there is a limitation of space in each MyPlan section, when you create a dashboard for MyPlan, keep the size in mind by displaying only one or two dimensions per chart axis. Additionally, if you create a chart with 50 columns and rows, for example, it will not display properly in MyPlan. It is best practice to test the look and feel of the Dashboard charts before rolling it out to users.

Chart Settings/Properties

When creating charts, you can select from several Settings / Properties options.

Step 1: Select a chart to display the Settings tab and click Properties as shown below.

Step 2: It is recommended that you turn Data Labels off as they take up additional chart space.

Step 3: Additionally, scale the Axis Min and Max while keeping chart space in mind. It is a best practice to use the bar chart type for most data. The Gauge chart type can be used to display data nicely as well. Other chart types may not display data well due to limited spacing, but please feel free to test them out based on your data needs.