Difference between revisions of "Formula Reference"
(Created page with '==OLAP Formulae== {| | width="200" | XL3Lookup | width="400" | Returns the value for a given cross section of the Cube |- | XL3LookupRW | Returns the value for a given c…') |
|||
| Line 1: | Line 1: | ||
==OLAP Formulae== | ==OLAP Formulae== | ||
| − | {| | + | {| class="wikitable" |
| width="200" | [[XL3Lookup]] | | width="200" | [[XL3Lookup]] | ||
| width="400" | Returns the value for a given cross section of the Cube | | width="400" | Returns the value for a given cross section of the Cube | ||
| Line 57: | Line 57: | ||
==Query Table Formulae== | ==Query Table Formulae== | ||
| − | {| | + | {| class="wikitable" |
| width="200" | [[XL3QueryTableGetConnectionString]] | | width="200" | [[XL3QueryTableGetConnectionString]] | ||
| width="400" | Gets the connection string of a Query Table | | width="400" | Gets the connection string of a Query Table | ||
| Line 72: | Line 72: | ||
==General Formulae== | ==General Formulae== | ||
| − | {| | + | {| class="wikitable" |
| width="200" | [[XL3Link]] | | width="200" | [[XL3Link]] | ||
| width="400" | Creates a hyperlink that opens a sheet and sets parameters | | width="400" | Creates a hyperlink that opens a sheet and sets parameters | ||
| Line 85: | Line 85: | ||
==Formula Wizards== | ==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. | 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. | ||
| − | {| | + | {| class="wikitable" |
! scope="col" width="200" | Ribbon/Menu option | ! scope="col" width="200" | Ribbon/Menu option | ||
! scope="col" width="200" | Function | ! scope="col" width="200" | Function | ||
Revision as of 10:09, 1 October 2010
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 (superceded 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 |
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 |
General 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 |
