The Anaplan XL Reporting Excel Add-in makes it easy for you to build reports. Build reports by combining Anaplan XL functions on a spreadsheet page.
OLAP formulas
| Function | Description |
| XL3Lookup | Returns the value for a given cross section of the cube. |
| XL3DataSeries | Returns a set of cube cell values. |
| XL3DataSeriesLookup | Returns a set of cube cell values. |
| XL3DoWriteback | Optionally writes a value to a specific cube cross-section. |
| XL3HierarchyLookup | Returns the dimension name. |
| XL3HierarchyRoleLookup | Returns the hierarchy name for a given role. |
| XL3KpiLookup | Returns the value of a KPI for a given cross section of the cube. |
| XL3KpiPropertyLookup | Returns a property for a given KPI. |
| XL3LookupRW | Returns the value for a given cross section of the cube, allowing a writeback to be performed on the cell. |
| 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. |
| XL3Member | Returns the captions for members. |
| XL3MemberAlias | Allows you to alias a member lookup to return a more readable name. |
| XL3MemberChildLookup | Returns the specified child for a given member. |
| XL3MemberLevelLookup | Returns the specified member for a given level. |
| XL3MemberLookup | Returns the caption for a member key or unique name (superseded by XL3Member). |
| XL3MemberNavigate | Returns a member from its relationship to another. For example, parents, children, siblings. |
| XL3MemberFromLookup | Returns a member using a text cell value. |
| XL3PropertyLookup | Returns the member property text for a specified dimension member. |
| XL3RankLookup | Returns the member at the specified position of a ranking. |
| XL3SetProperty | Allows the updating of object types properties. |
| XL3ValueRankLookup | Returns the measure value at the specified position of a ranking. |
| XL3LastCubeUpdate | Returns the time at which the cube was last updated. |
| XL3UserName | Returns the user ID of the logged in user. |
| XL3GridMember | Returns the member unique name for the specified grid cell. |
| XL3GridArrayLookup | Returns an array containing the result of a query. |
Tabular formulas
| Function | Description |
| XL3LookupTabular | Returns the value of a measure for a given filter. |
In-cell chart formulas
| Functions | Description |
| XL3SparkLine | Creates a line, point or area chart that is rendered in an Excel cell. |
| XL3SparkLineM | Creates a monochrome line or point chart that is rendered in the Excel cell. |
| XL3SparkColumns | Creates a column chart that is rendered in an Excel cell. |
| XL3SparkColumnsM | Creates a monochrome column chart that is rendered in the Excel cell. |
| XL3SparkWinLose | Creates a win/loss chart that is rendered in an Excel cell. |
| XL3SparkWinLoseM | Creates a monochrome win/loss chart that is rendered in the Excel cell. |
| XL3SparkBar | Creates a bar chart that is rendered in an Excel cell. |
| XL3SparkBarM | Creates a monochrome bar chart that is rendered in the Excel cell. |
| XL3SparkBullet | Creates a bullet chart that is rendered in an Excel cell. |
| XL3SparkHorizon | Creates a horizon chart that is rendered in an Excel cell. |
| XL3SparkIcon | Creates an indicator icon that is rendered in an Excel cell. |
| XL3SparkHeatMap | Creates a set of colored icons suitable for use as a heat map. |
| XL3SparkPie | Creates a pie chart that is rendered in an Excel cell. |
| XL3SparkBox | Creates a box plot chart that is rendered in an Excel cell. |
| XL3SparkDotPlot | Creates a dot plot chart that is rendered in an Excel cell. |
| XL3SparkLolliplot | Creates a lollipop chart that is rendered in an Excel cell. |
| XL3SparkHeatMap | Creates a heat map section that is rendered in an Excel cell. |
| XL3SparkCompare | Creates a comparison chart that is rendered in an Excel cell. |
Relational formulas
| Functions | Description |
| 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. |
| XL3RunSQL | Runs the specified SQL. |
| XL3RunSQLProc | Runs the specified stored procedure. |
| XL3SqlArea | Creates and updates table range based on the results of a SQL query. |
| XL3TableArrayLookup | Returns an array containing the result of a query. |
Report management formulas
| Functions | Description |
| XL3Link | Creates a link that opens a sheet and sets parameters. |
| XL3RowVisible | Shows or hides a row. |
| XL3ColumnVisible | Shows or hides a column. |
| XL3SheetVisible | Shows or hides a sheet. |
| XL3DynamicPicture | Updates a picture based on a URL (web address). |
| XL3RefreshObjects | Refreshes objects in the report based on type. |
| XL3RefreshSheetObjects | Refreshes objects in the report based on type. |
| XL3RefreshObjectsNamed | Refreshes objects in the report based on name. |
| XL3RefreshConnections | Refreshes objects connected to a connection. |
| XL3WebReportLink | Creates a link that opens an Anaplan XL Web report and optionally sets Web parameters. |
| XL3IsWeb | Returns True if report is running in Anaplan XL Web and False if the report is running in Excel. |
| XL3ResourceLookup | Returns the text for the specified resource for the current culture (Web only) |
| XL3ReportInfo | Returns information about the published report, for example, ReportName, PublishedBy. (Web only) |
Comment formulas
| Functions | Description |
| XL3CubeComment | Get the comments for a particular cube cell. |
| XL3GridComment | Get the comments for a grid. |
Formula wizards
| 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 |
Excel formulas
Review Supported Excel formulas for a full list.
