Dynamic Planning How to Define Multiple Number Formats for Dimension Members in Views

This task is available for Designers and Administrators.

To define multiple number formats for dimension members in Views:

1. Specify the number format for each dimension member by doing the following:

   • Select the Model task and the Dimension subtask.

   • Select the model from the Model list box and the dimension that contains the members you want to define number formats for from the Dimension list box.

   • Select the Set Dimension Based Properties action. In the example below, the Numeric number format is selected for Expense members, Currency is selected for Income members, and Percent is selected for Ratio members.

     

   • Click Save after defining number formats for each dimension.

2. Update the properties at the View level so that the number formats defined at the dimension level are displayed as needed.

   • Select the Analyze task and the Design View subtask.

   • Select the View.

   • Click the Properties action.

   • Select the dimension from the Dimension based 'Number Format' field you applied number format to on the Model Dimension page.

     

   • Click Save.

   • Select Analyze, Data, to see the results of your changes.