Filtering on Endpoint Name Using Deliver Instance Variables

Note: This article is intended for database administrators. Ensure the following tasks are completed by someone with the appropriate database administration privileges.

Use the Deliver instance endpoint name variable, combined with data selection rules, to apply different data filters for different endpoints within the same Deliver instance. This allows each department or team to have their own endpoint containing only the data relevant to them, improving load performance, report performance, and cost management by keeping individual models smaller — without the overhead of maintaining separate Deliver instances.

Set up data selection rules for specific endpoints

1. Create a Deliver instance with multiple endpoints.

   

2. Close all open instances in Jet Analytics Data Integration, then reopen the Deliver instance. Go to Tools > Instance Variables. Click Add and add an instance variable with the following settings:
   • Type: Destination Scope
   • Value Filter: Endpoint
   • Value: Name
   Click OK and close the dialog.

   

3. Right-click the table on which you want to create a filter and select Add Data Selection Rule. In the right-hand Data Selection Rule pane, click the table name, ensure Custom is selected as the operator, and click Add.

   

4. Configure the data selection rule. Add one custom rule per endpoint — for example, if the Deliver instance has three endpoints (DEV, QA, and PROD), add three separate rules, one for each endpoint.

   

5. For each rule, drag the column to filter on from the right-hand pane into the rule. Enter the filter value for that column. Then drag the Endpoint Name instance variable into the rule and enter the name of the endpoint this rule should apply to.

   

6. Repeat steps 4 and 5 for each additional endpoint.

   

7. Deploy and execute the Deliver instance.

Result

The result is one Deliver instance with multiple endpoints — for example, three SSAS Tabular models — each containing only the subset of data configured for that endpoint.