Difference between revisions of "Calculations Overview"
(Added categories) |
m (Text replacement - "XLCubed" to "FluenceXL") |
||
| (One intermediate revision by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | FluenceXL features a few ways to define your own calculations. | |
==Grid Calculation Columns and Rows== | ==Grid Calculation Columns and Rows== | ||
| Line 17: | Line 17: | ||
More details can be found [[MDX Calculations|here]]. | More details can be found [[MDX Calculations|here]]. | ||
| − | == | + | ==FluenceXL OLAP Formulae== |
| − | + | FluenceXL offers several formulas that allow you to bring Cube data into Excel. This allows you to create complex workbooks interacting in all the sophisticated ways that Excel allows. | |
| − | A more detailed description can be found [[Formula Reporting Overview|here]], and an | + | A more detailed description can be found [[Formula Reporting Overview|here]], and an FluenceXL formula reference [[Formula Reference|here]]. |
| + | |||
| + | ==MDX: and MDXSet: members== | ||
| + | |||
| + | Grids and formulae can both refer to an MDX: calculation defined in an Excel cell. In addition, Grids can use MDXSet: in an Excel cell to define a named set. Information can be found here: | ||
| + | * [[Mdx:|MDX: and MDXSet: in Grids]] | ||
| + | * [[XL3Member#XL3Member using MDX|MDX: in XL3Member formulae]] | ||
[[Category:Formula Reporting]] | [[Category:Formula Reporting]] | ||
[[Category:Grid Reporting]] | [[Category:Grid Reporting]] | ||
[[Category:OLAP Operations]] | [[Category:OLAP Operations]] | ||
Latest revision as of 15:56, 3 July 2023
FluenceXL features a few ways to define your own calculations.
Contents
[hide]Grid Calculation Columns and Rows
Used only in Grid-based reports, Grid Calculations allow you to define your own dynamic calculations within a Grid report.
They allow Excel formulas to be used within the Grid, based either on the visible data or on other elements on the worksheet.
More details can be found here.
MDX Calculated Members
MDX Calculations are a simple but powerful means to manage calculated members, sets and custom MDX commands that live in the session, and are executed on connection.
They are more involved to implement than Grid Calculations, but enable more complex and flexible calculations.
More details can be found here.
FluenceXL OLAP Formulae
FluenceXL offers several formulas that allow you to bring Cube data into Excel. This allows you to create complex workbooks interacting in all the sophisticated ways that Excel allows.
A more detailed description can be found here, and an FluenceXL formula reference here.
MDX: and MDXSet: members
Grids and formulae can both refer to an MDX: calculation defined in an Excel cell. In addition, Grids can use MDXSet: in an Excel cell to define a named set. Information can be found here:
