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

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