Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Flag object to differentiate the Cust IDs coming from 2 different data providers

Go down

Flag object to differentiate the Cust IDs coming from 2 different data providers Empty Flag object to differentiate the Cust IDs coming from 2 different data providers

Post  LUCY.ONLINE Thu Feb 14, 2013 11:24 am

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

LUCY.ONLINE

Posts : 4
Join date : 2012-06-01

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum