find the ACTIVE contract count, cancelled contrat count

[ravindraa]

HI all

  we have one requirement in that requirement we have 2 database.

  1 database have custmer,contract,status,...etc fields

   2 database have custmer,contract,status....etc fields

in the requirement 1 database

one customer have many contracts.(1:M Relation)

but 2 database one customer have many contracts  as well as one contract have many customer (M:M Relation)

status field contains Active,

                               cancelled

                                 Enrolled

In this case we need to display contracts count difference from 2 database  and if we select difference value we need to display the difference contract list.

In that list we need to display the how many Active contracts

                                                 how many cancelled contracts

                                                     how many Enrolled contracts.

so far we did in edit script like below

database1:                                          

LOAD

Customer,

Contract& Business&Customer as CON_BUS_CUSkey,

Bussiness,

-

-

-

from database1;

database2:

load

Customer AS SAP_Customer,

Contract& Business&Customer as CON_BUS_CUSkey,

contract,

Bussiness

.

.

.

from database2;

It is very urgent if any one knows any idea please give to me suggestions.

give me any suggestion how to get above requirement.

[#2]

Maybe you should concatenate those two tables adding some discriminator field and then using it in set analysis..I suppose that you may have many common dimensions in both sources.

regards

Darek

[ravindraa]

Hi Dariusz Mielczarek,

   thanks for given suggession that is not working, if you have any idea give to me.

if any one  have any idea give to me

[#4]

Please share application where you tryed my suggestion. I will have a

look on it

Regards

Darek