When working with OLAP and Tabular models, the following sections appear in the Properties panel:
- Context
- Format
- Execution
- Foreground Color
- Background Color
- Dynamic Captions
Tip: This page describes the Properties panel where OLAP and Tabular models are in use. If you are not using OLAP and Tabular models, see Formula Properties.
Formula Properties panel
Context
The Context section indicates where the custom member is saved. Each custom member has a designated parent dimension and hierarchy. This value is created in the first instance by Pyramid using heuristics to determine which attribute to place the formula on.
Changing the Context
You can override the default Context selection by selecting the Enable Manual Selection checkbox and choosing different Dimension and Hierarchy values from the drop-downs.
Recommended: You should make use of the Show Lineage or Open Related Items options on your formula's App Tabs menu (purple arrow below) to check whether your formula is already in use in an existing discovery or elsewhere. If the formula is already in use, you should either remove the relation or make sure you fix it once you have made this change.
Format
A format string can be applied to custom members that will determine how metrics for the custom element are formatted. Format string options include a variety of presets, like currency, percentage, and standard number masks like "#,#".
Calculated Expression
When working with OLAP and Tabular models, you can also create a calculated expression, which will be used to determine the format string in the query. Simply select the Calculated Expression checkbox and type your script in the Format String field.
Execution
Solve Order
A solve order can be applied to the custom element, determining the order in which the calculated member will be solved in cases where a calculated member references one other calculated member (that is, where calculated members intersect each other) in the query.
When working in Discover, click Model Formats from the Query ribbon to enable the solve orders that have been set in Formulate. For more information, see Query Options
Isolation Mode
Isolation Mode sets the scope isolation of the custom member. When an MDX script contains calculated members, by default the calculated members are resolved before any session-scoped calculations are resolved and before any query-defined calculations are resolved. The behavior allows client applications to work with cubes that contain complex calculations, without having to take into account the specific implementation of the calculations. However, in certain scenarios, you might want to execute session or query-scoped calculated members before certain calculations in the cube. To accomplish this, set the isolation mode property to "cube" .
Foreground Color and Background Color
The Foreground Color and Background Color properties allow you to format your calculated members so that they appear with colors in the grid. These MDX-driven formatting options can be used with complex logic to deliver cube defined conditional formatting amongst other things.
- Click here for more information.
Dynamic Captions
You can configure dynamic custom member captions that will appear in the visual instead of the custom member name.
- Click here to learn about this feature.