| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "XLCubed Business Rules"
| Line 1: | Line 1: | ||
| + | |||
XLCubed Dynamic Charts formatting can be modified from the XLCubedFormats and XLCubedBusinessRules sheets. | XLCubed Dynamic Charts formatting can be modified from the XLCubedFormats and XLCubedBusinessRules sheets. | ||
| Line 13: | Line 14: | ||
which corresponds to the following XLCubedFormats:- | which corresponds to the following XLCubedFormats:- | ||
[[File:Formats.png|600px|center|XLCubedFormats]] | [[File:Formats.png|600px|center|XLCubedFormats]] | ||
| − | We can see that the Budget dimension is mapped on to the '''Plan''' type. | + | We can see that the Budget dimension is mapped on to the '''Plan''' type. The 'Item Name' column is left blank which means that the formatting will apply to all dynamic charts once they have been refreshed. |
| + | === Mapping of calculated members === | ||
The following example is of a Business Scenario chart which uses a calculated member for the Actual member. | The following example is of a Business Scenario chart which uses a calculated member for the Actual member. | ||
| − | The mapping for the calculated member is defined as follows:- | + | The mapping for the calculated member 'my actual' is defined as follows on the XLCubedBusinessRules sheet:- |
[[File:MyactualMapping.png|600px|center|Mapping of the 'my actual' calculated member]] | [[File:MyactualMapping.png|600px|center|Mapping of the 'my actual' calculated member]] | ||
| − | + | ---------------- | |
[[File:2ChartsSide ModRight.png|600px|center|Format by chart name]] | [[File:2ChartsSide ModRight.png|600px|center|Format by chart name]] | ||
| − | + | ----------- | |
[[File:2ChartsSide.png|600px|center|Formatting by chart name]] | [[File:2ChartsSide.png|600px|center|Formatting by chart name]] | ||
Revision as of 06:34, 8 July 2021
XLCubed Dynamic Charts formatting can be modified from the XLCubedFormats and XLCubedBusinessRules sheets.
The XLCubedBusinessRules sheet is included in the workbook automatically when (xxxxxxxxxxxxxxxxxxxx) The XLCubedBusinessRules sheet serves to map the predefined business rule types on to the hierarchy members where they are applied to.
It is possible to configure the XLCubedFormats sheet to apply custom formatting to the dynamic charts based on the mappings defined in the XLCubedBusinessRules sheet.
The formatting is mapped in the XLCubedBusinessRules sheet as follows:-
which corresponds to the following XLCubedFormats:-
We can see that the Budget dimension is mapped on to the Plan type. The 'Item Name' column is left blank which means that the formatting will apply to all dynamic charts once they have been refreshed.
Mapping of calculated members
The following example is of a Business Scenario chart which uses a calculated member for the Actual member.
The mapping for the calculated member 'my actual' is defined as follows on the XLCubedBusinessRules sheet:-
