Difference between revisions of "Formula Reporting Overview"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| (3 intermediate revisions by 3 users not shown) | |||
| Line 1: | Line 1: | ||
When using formulae to retrieve information and data from the OLAP cube, each cell contains a formula rather than the data itself (unlike [[Grid Reporting Overview|Grid reports]]). It is therefore possible to put any value in any cell, and to have fully disjoint reports. | When using formulae to retrieve information and data from the OLAP cube, each cell contains a formula rather than the data itself (unlike [[Grid Reporting Overview|Grid reports]]). It is therefore possible to put any value in any cell, and to have fully disjoint reports. | ||
| − | Most formula reports are built primarily using just two | + | Most formula reports are built primarily using just two FluenceXL formulae: |
| − | ; XL3Lookup | + | ; ''XL3Lookup'' |
: retrieves the cube value from a specified slice, and will normally reference one or more XL3Member formulae | : retrieves the cube value from a specified slice, and will normally reference one or more XL3Member formulae | ||
| − | ; XL3Member | + | ; ''XL3Member'' |
: returns the caption for a specified member | : returns the caption for a specified member | ||
| Line 15: | Line 15: | ||
* [[XL3Member|XL3Member formula]] | * [[XL3Member|XL3Member formula]] | ||
* [[Grid vs. Formula-based Reporting Key Differences]] | * [[Grid vs. Formula-based Reporting Key Differences]] | ||
| + | * [[Flex Reporting]] | ||
[[Category:Formula Reporting]] | [[Category:Formula Reporting]] | ||
[[Category:Getting Started]] | [[Category:Getting Started]] | ||
Latest revision as of 09:30, 4 July 2023
When using formulae to retrieve information and data from the OLAP cube, each cell contains a formula rather than the data itself (unlike Grid reports). It is therefore possible to put any value in any cell, and to have fully disjoint reports.
Most formula reports are built primarily using just two FluenceXL formulae:
- XL3Lookup
- retrieves the cube value from a specified slice, and will normally reference one or more XL3Member formulae
- XL3Member
- returns the caption for a specified member
Formula reports will often be preferred where the required formatting is complex, or where existing 'static' financial reports are being replaced.
