|
Insert Stored Procedure |
|
|
Insert Stored Procedure |
|
Overview: The Insert Stored Procedure dialog allows inserting stored procedure calls from the available list of connections.
Accessing: This dialog can be accessed by selecting the Stored Procedure button, located in the Database group, under the Home tab.
| • | Choose Connection - the drop-down list associated to this field allows selecting the connection from where the data source will be retrieved. |
| • | Enable Caching - when this option is enabled, the data will be cached between repeated runs that retrieve the same output, if no modification is made to the .dax document. If the document is modified, the data will not be cached between runs. |
| • | Stored Procedure - this section presents a list of the available procedures, together with their parameters and their return values. |
After selecting the OK button, the element will be added in Design View and displayed as follows:
