Semantic Model Snippets

Add DAX, Qlik, and Tableau snippets, and use them in Semantic model custom fields, custom measures, and calculation group items. These types of snippets are small pieces of code that can be used and reused throughout Semantic Model instances to speed up development. For information on SQL snippets in Data Warehouse instances, see:

Add a DAX, Qlik, and Tableau Snippet

1. Under Tools, select Snippets
2. Click Add and select the type of Snippet you would like to use in your Semantic Model
3. Provide a Name, Description and Formula for the snippet. Highlight the parameter in the formula and click Add Parameter

   

4. Under Parameters, change the Type to match what the parameter represents. You have the following options:
   • Semantic Table
   • Semantic Field
   • Semantic Measure
   • Semantic Calculation Group
   • Semantic Calculation Group Column
   • Value
5. Click OK

Using a DAX, Qlik, and Tableau Snippet

1. To use the Snippet in a Custom Field or Custom Measure click Add Snippet
2. Select the Snippet you would like to add and click OK

   

3. Map the available fields to the parameters in the snippet. Drag the field(s) from the list on the right and drop the field on the Object Name/Value column for the relevant variable. The Object Name/Value column and Variant column will populate automatically

   

4. Click OK

Edit or Delete a Snippet

 Under Tools, select Snippets. Select the snippet and click Edit or Delete

Show Snippet Usage

Under Tools, select Snippets. Select the snippet and click Show Usage

Updating a Snippet

When updating a snippet, edit the objects where the snippet is being used. Remove and re-add the snippet for the objects, for the changes to take effect