Updating Relationships in a Worksheet

You may also edit the relationships right in the worksheet.

 

Sign in as a user with at least the Metadata Editing capability object role assignment for the MyCompany Business Rules custom model and for the Data Lake imported model.

Go to WORKSHEETS > File > Files to produce a worksheet and click on Columns to add the column for the reference Measures. Then add a text filter of “vendor customer”.

 

 

Select all five rows and right-click the selected rows and select Edit.

 

 

 

Click on the Value column for Measures and specify the business rule as below:

 

 

Click OK. And again.

 

 

The business rule is now related to all four imported objects.