Flag object to differentiate the Cust IDs coming from 2 different data providers
Page 1 of 1
Flag object to differentiate the Cust IDs coming from 2 different data providers
I need help with.
I've 2 data providers, the Cust IDs in each are as following
All Cust -- Safety Cust
C01 -- C01
C02 -- C02
C03 -- C03
C04
C05
C06
But, these two are coming from different tables in the database, one is the permanent Cust table and the Other is a User Upload Cust table.
Now in the report, I merged on Cust ID........I need to create a Flag for Satefy Cust (C01, C02, C03) and the rest will be All Others.
I need this flag to get different measures like.....Sales Amt for Safety Cust , Sales Amt for All Other Cust etc
I've 2 data providers, the Cust IDs in each are as following
All Cust -- Safety Cust
C01 -- C01
C02 -- C02
C03 -- C03
C04
C05
C06
But, these two are coming from different tables in the database, one is the permanent Cust table and the Other is a User Upload Cust table.
Now in the report, I merged on Cust ID........I need to create a Flag for Satefy Cust (C01, C02, C03) and the rest will be All Others.
I need this flag to get different measures like.....Sales Amt for Safety Cust , Sales Amt for All Other Cust etc
LUCY.ONLINE- Posts : 4
Join date : 2012-06-01
Similar topics
» 3 objects in the query that is causing the measure object to multiple. By 2
» Would you include additional Data Integration and ETL solutions to this list of Top providers?
» Source Fact data coming in at different levels of a conformed dimension
» date object.
» SCD object in SSIS
» Would you include additional Data Integration and ETL solutions to this list of Top providers?
» Source Fact data coming in at different levels of a conformed dimension
» date object.
» SCD object in SSIS
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum