Modeling problem

[Former Member]

Hi experts,

I am confronted with a BW modeling problem, that's why I request your help.

The business scenario consists to analyze the turn-oven by item (0material) and by brand.

A fist datasource gives the turnover realized by item.

A second datasource give the association between items and brands. An item can have 0, 1 or many brands. A brand can contain many items.

DS 1 :

Item	Turn-over
A	10€
B	5€
C	15€

DS 2 :

Item	Brand
A	Value1
A	Value2
B	Value1
B	Value3
C	Value4

The purpose is to give the possibility to cross in a query the sales data by item and/or by brand :

Brand	Item	Turn-over
Value1	A	10€
	B	5€
	Result	15€
Value2	A	10€
	Result	10€
Value3	B	5€
	Result	5€
Value4	C	15€
	Result	15€

Or :

Item	Brand	Turn-over
A	Value1	10€
	Value2	10€
	Result	10€
B	Value1	5€
	Value3	5€
	Result	5€
C	Value4	15€
	Result	15€
Result		30€

Or :

Item	Turn-over
A	10€
B	5€
C	15€
Result	30€

Or :

Brand	Turn-over
Value1	15€
Value2	10€
Value3	5€
Value4	15€

The brand is a kind of attribute of the masterdata 0material, with the particularity that a brand can take many values for 1 item --> I am not able to use brand as a navigational attribute of 0material.

I try to create a provider that contains Item and Turn-over, a second provider which contains the link Item - Brand, and a multiprovider which contains the 2 providers linked by Item. Problem : when I create a query on this multiprovider, the query can't assigned the turn-over linked to the brands...

Could you please give me some advice to help me to solve the problem ?

Thanks a lot,

Carl

[former_member182470 · Accepted solution]

You can achieve your requirement by using Infoset on DSO(Item and Turnover) and DSO(Item and Brand). You can put inner join by item field. Finally you will get a valid combination of Item, Brand and Turnover records. Mutliprovider should not be used.