Skip to Content
0
Former Member
Jul 14, 2008 at 05:26 PM

Query Creation: Material-Brand-Assignment

30 Views

Dear experts,

I've got problems with building the following report

Number of Brands__________Number of assigned Materials

1#-____________________________________1500000

2##_____________________________________750000

3_______________________________________500000

4________________________________________30000

Total___________________________________2780000

Table: Materials assigned to a particular number of brands

'#' Material is only assigned to 1 brand for example to ABC.

'##' Material is assigned to 2 different brands e.g. ABC and XYZ.

with created DSOs (in an InfoSet):

1. Brand Franchise Code Assignment with following char key fields

___Franchise Code ID

___Brand

2. Material Franchise Assignment with following char key fields

___0Material

___0Soursystem

___Franchise Code ID

In the InfoSet, Franchise Code ID are the linked (join) fields.

Do you have any suggestion for the setup of the query?

Thanks for your help in advance!