XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/

Difference between revisions of "XLCubed Business Rules"

Line 14: Line 14:
 
[[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.
 +
[[File:2ChartsSide.png|600px|center|Formatting by chart name]]

Revision as of 05: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.

Column Charts

The formatting is mapped in the XLCubedBusinessRules sheet as follows:-

Business Rules

which corresponds to the following XLCubedFormats:-

XLCubedFormats

We can see that the Budget dimension is mapped on to the Plan type.

Formatting by chart name