Data Scrubbing in Universe

DATA SCRUBBING CONCEPT IN UNIVERSE:

----àClick on Insert Menu

----àObject

----àName the Object [overall_cost]

----àData Type----Number

  Place the cursor in Select

----àBrowse

----àExpand shopfacts---Double click on amount_sold multiplied by Double click on quantity_sold [amount_sold * quantity_sold]

----à Click on Parse

If Parsing is Ok ----Click on Ok

CONDITION BASED DATA SCRUBBING:

----àClick on Insert Menu

----àObject

----àName the Object [discount]

----àData Type----Number

  Place the cursor in Select area

----àBrowse

----àExpand Character functions

----àDouble click on IIF (If and only If)

----àDouble click on quantity_sold and type >=10, place the cursor in true condition area----Double click on amount_sold multiplied by 0.12, place the cursor in false condition area ---Double click on amount_sold multiplied by 0.04

Finally the expression is

IIF (shop_facts.quantity_sold>=10, shop_facts.amount_sold*0.12, shop_facts.amount_sold*0.04)

----à Click on Parse

If Parsing is Ok ----Click on Ok