Creating or Editing an Enrichment Function
An Enrichment function is a Project function without Input / Output parameters that is used to insert, update, or delete an LU Table's data after it has already been populated from a source object. It is defined as a specific category of Fabric Regular functions.
How Can I Create or Edit an Enrichment Function?
The steps for creating an Enrichment function in Fabric Studio are the same as those for a creating a Regular function.
The steps which are unique for Enrichment functions are as follows:
- In the Function Properties tab, set the Function Type to Regular Function.
- Do not define Input / Output parameters.
- It is recommended to set the Category to Enrichment.
Click for more information about How to Create a Project Function.
How Do I Attach or Remove an Enrichment Function?
An Enrichment function must be attached to one or more LU tables in the LU schema to be executed during the LUI sync.
Do the following:
- Go to Project Tree > Implementation > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
- Click the side arrow icon
to open the Table Properties window. - Open the Enrichments tab.
- Click the
icon in the Enrichments tab to add an existing Enrichment function from the list. - If needed, add additional Enrichment functions and use the arrows to set the correct execution order.
- To remove an Enrichment function, click
icon next to the Enrichment function definition in the Table Properties. - Save the LU Table (File > Save or CTRL-S).
Note that the Enrichments tab is hidden by default. To show it in the Studio, open the Settings and click the Show Enrichments List option.
How Do I Attach an Enrichment Function to an LU Table?
An Enrichment function must be attached to one or more LU tables in the LU schema to be executed during the LUI sync.
Do the following:
Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
To attach the Enrichment function using the LU Table Properties tab, click the three dots next to the Enrichment Functions option to open the Enrichment Item Collection Editor.
Click Add and then click the area next to Name to display the list of Enrichment functions. Note that only the functions without Input and Output parameters are displayed.
Select the function from the list.
(Optional) To add more Enrichment functions to the same LU table, click Add again and select the additional functions. Define the Enrichment functions execution order using the arrows next to the function names in the Editor.
Click OK to close the Editor.
Save the table.
Open the LU Schema > Enrichment Order tab to verify that the enrichment order of all the Enrichment functions in the LU is correct. Note that you can edit the enrichment order on the LU schema level.
How Do I Remove an Enrichment Function from an LU Table?
To remove an Enrichment function from the LU table, do the following:
Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
In the Table Properties tab, click the three dots next to the Enrichment Functions option to open the Enrichment Item Collection Editor.
Select the function and click Remove.
Click OK to close the Editor.
Save the table.
Creating or Editing an Enrichment Function
An Enrichment function is a Project function without Input / Output parameters that is used to insert, update, or delete an LU Table's data after it has already been populated from a source object. It is defined as a specific category of Fabric Regular functions.
How Can I Create or Edit an Enrichment Function?
The steps for creating an Enrichment function in Fabric Studio are the same as those for a creating a Regular function.
The steps which are unique for Enrichment functions are as follows:
- In the Function Properties tab, set the Function Type to Regular Function.
- Do not define Input / Output parameters.
- It is recommended to set the Category to Enrichment.
Click for more information about How to Create a Project Function.
How Do I Attach or Remove an Enrichment Function?
An Enrichment function must be attached to one or more LU tables in the LU schema to be executed during the LUI sync.
Do the following:
- Go to Project Tree > Implementation > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
- Click the side arrow icon to open the Table Properties window.
- Open the Enrichments tab.
- Click the icon in the Enrichments tab to add an existing Enrichment function from the list.
- If needed, add additional Enrichment functions and use the arrows to set the correct execution order.
- To remove an Enrichment function, click icon next to the Enrichment function definition in the Table Properties.
- Save the LU Table (File > Save or CTRL-S).
Note that the Enrichments tab is hidden by default. To show it in the Studio, open the Settings and click the Show Enrichments List option.
How Do I Attach an Enrichment Function to an LU Table?
An Enrichment function must be attached to one or more LU tables in the LU schema to be executed during the LUI sync.
Do the following:
Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
To attach the Enrichment function using the LU Table Properties tab, click the three dots next to the Enrichment Functions option to open the Enrichment Item Collection Editor.
Click Add and then click the area next to Name to display the list of Enrichment functions. Note that only the functions without Input and Output parameters are displayed.
Select the function from the list.
(Optional) To add more Enrichment functions to the same LU table, click Add again and select the additional functions. Define the Enrichment functions execution order using the arrows next to the function names in the Editor.
Click OK to close the Editor.
Save the table.
Open the LU Schema > Enrichment Order tab to verify that the enrichment order of all the Enrichment functions in the LU is correct. Note that you can edit the enrichment order on the LU schema level.
How Do I Remove an Enrichment Function from an LU Table?
To remove an Enrichment function from the LU table, do the following:
Go to Project Tree > Logical Units > [LU Name] > Tables > [Table Name] to display the Table Schema window.
In the Table Properties tab, click the three dots next to the Enrichment Functions option to open the Enrichment Item Collection Editor.
Select the function and click Remove.
Click OK to close the Editor.
Save the table.
