Difference between revisions of "Formula Reference"
(Added category Formula Reporting) |
(In-Cell Chart formulae) |
||
| Line 54: | Line 54: | ||
| [[XL3LastCubeUpdate]] | | [[XL3LastCubeUpdate]] | ||
| Returns the time at which the cube was last updated | | Returns the time at which the cube was last updated | ||
| + | |} | ||
| + | |||
| + | ==In-Cell Chart Formulae== | ||
| + | {| class="wikitable" | ||
| + | | width="200" | [[XL3SparkLine]] | ||
| + | | width="400" | Creates a line, point or area chart that is rendered in an Excel cell | ||
|} | |} | ||
Revision as of 16:17, 23 November 2010
Contents
[hide]OLAP Formulae
| XL3Lookup | Returns the value for a given cross section of the Cube |
| XL3LookupRW | Returns the value for a given cross section of the Cube, allowing a writeback to be performed on the cell |
| XL3Member | Returns the caption(s) for a member or members |
| XL3MemberLookup | Returns the caption for a member key or unique name (superseded by XL3Member) |
| XL3HierarchyLookup | Returns the Dimension name |
| XL3MemberChildLookup | Returns the specified child for a given member |
| XL3MemberLevelLookup | Returns the specified member for a given level |
| XL3PropertyLookup | Returns the Member Property text for a specified dimension member |
| XL3RankLookup | Returns the member at the specified position of a Ranking |
| XL3ValueRankLookup | Returns the Measure value at the specified position of a Ranking |
| XL3KpiLookup | Returns the value of a KPI for a given cross section of the cube |
| XL3KpiPropertyLookup | Returns a property for a given KPI |
| XL3DataSeries | Returns a set of cube cell values |
| XL3DataSeriesLookup | Returns a set of cube cell values |
| XL3MdxLookup | Returns the value from a specified MDX statement |
| XL3MdxMemberLookup | Returns a member from a specified MDX statement |
| XL3MdxDataSeries | Returns a set of cube cell values from an MDX statement |
| XL3LastCubeUpdate | Returns the time at which the cube was last updated |
In-Cell Chart Formulae
| XL3SparkLine | Creates a line, point or area chart that is rendered in an Excel cell |
Query Table Formulae
| XL3QueryTableGetConnectionString | Gets the connection string of a Query Table |
| XL3QueryTableSetConnectionString | Sets the connection string of a Query Table |
| XL3QueryTableSetParam | Sets the query parameter value of a Query Table |
| XL3QueryTableSetSQL | Sets the SQL statement of a Query Table |
Report Management Formulae
| XL3Link | Creates a hyperlink that opens a sheet and sets parameters |
| XL3RowVisible | Shows or hides a row |
| XL3ColumnVisible | Shows or hides a column |
Formula Wizards
The XLCubed Excel Add-in provides a menu-driven, graphical user interface to facilitate easy building of reports. The reports are built by combining XLCubed functions on a spreadsheet page. The following functions are supported by the GUI.
| Ribbon/Menu option | Function |
|---|---|
| Insert Members | XL3Member |
| Insert Value | XL3Lookup/XL3LookupRW |
| Insert Ranking | XL3RankLookup |
| Insert Member Property | XL3PropertyLookup |
| Insert Data Series | XL3DataSeriesLookup |
| Insert Link | XL3Link |
