When designing a query, parameters will be automatically discovered by Anaplan XL and made available for editing. As with SQL queries using parameters, Anaplan XL will find the parameters when they are typed in the query.

Using Parameters

The parameter values can be supplied as a static value, pulled in from an Excel range, or driven by a SQL slicer. See Using SQL Parameters for more details.

Using Stored Procedures

>EXEC command to run the desired stored procedure.  To use stored procedures:

    • Enter the command in the query designer:

EXEC MyStoredProcedure @Param1, @Param2

    • The parameters appear in the parameters grid on the left of the form

There's a Stored Procedure toggle button in the toolbar. Turning this on informs Anaplan XL that the SQL statement is a stored procedure, which can affect the generated query. For example, the procedure will be called directly for SQL Server, not via sp_executesql.