Skip to Content
Author's profile photo Ankit Bansal

Creating Rule and Binding to table in SAP IS

Hi Users,

Below are some simple steps to create a rule and bind it to table in SAP IS.

For example I’m using Check of NULL and Blanks into a column.

Step 1: Go to the rule tab and click on New to create new rule

/wp-content/uploads/2013/05/0_223545.png

Step 2: This will show you below Rule Editor window

/wp-content/uploads/2013/05/1_223546.png

Step 3. Give a rule name as required, Quality Dimension as Completeness and Create a parameter to pass column value to the rule.

Creat a rule in Advace Editor as belwo given image tha will create auto code as below:

BEGIN RETURN

$Completeness IS NOT NULL

AND $Completeness != ”;

END

/wp-content/uploads/2013/05/2_223559.png

Rule created as above will check for null and blanks in the column.

After creating save and close it.

Step 4. It will show you that rule in below table under Completeness tab.

/wp-content/uploads/2013/05/3_223560.png

Step 5: Now to bind rule to columns Select the particular rule and click on ‘Bind’ button which will open a Rule Binding Editor for that particular rule

/wp-content/uploads/2013/05/4_223561.png

In Rule Binding Editor bind the columns one by one using Save button, then at last click save and close to come out from this editor. You can set threshold also for each column separately.

Hope this information will help in your development work.

Thanks,

Ankit Bansal.


Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Ankit Bansal



      I tried install Information Steward and my database is oracle

      When tried happened same error


      N1.png

      I cried the database, the test ok, but  my repository did not create


      Do you help me?

      Author's profile photo Former Member
      Former Member

      Hi Alberto,

      Look at this KBA and follow the directions.

      1773657 - Invalid Information Steward repository connection
      information

      Author's profile photo Former Member
      Former Member

      Hi,

      I am new to IS (4.2). I am trying to bind my rule against a source. But I dont see any source in the drop down.  I have connections present in BI CMC (4.1). I have also gone to CMC and under Information Steward created new connection. I am missing something, please help.

      Thanks,