Sunday, September 11, 2011

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

No comments:

Post a Comment