Object added through Flat file in multiprovider to display in query

[former_member360582]

Hi ) as

There is one object called top 5 customer which are having values as eg A,B,C ,D and E.

Now this object is not available from system (ECC system back end not coming through transactional data as logic is not aware yet .

so we want Material Plant wise that top 5 customer is either of a,b,c ,d or e.

now this we are uploading through flat file in BW.

we inserted this in both ways in Cube as well as DSO .

we added that DSO or cube in Multiprovider.

now when bex query is executed it was not giving output top 5

earlier I created with DSO and hence later on we created with cube and added keyfigure (dummy)

then those top 5 value was been displaying by dragging those key figure in bex query

but now issue we are getting two records where that a value is appearing for which other key figure is blank

for eg

Material Plant top 5 planned volume (Key figure dummy cube flat file )

10001 F101 A (blank) 100

10001 F101 # 900 (Blank)

so ideally this should be

10001 F101 A 900 100

why # not assigned is mapped to wrong value

Please assist

our system config is sap BW 7.5 it is

Sap ECC version 7

BW is on Hana .

[john_hawk]

Hi Gaurav

I believe you are using the wrong tool for the job. If you wish to join a list of values from master data or DSO to other InfoProviders, you need to use a Composite InfoProvider, not a MultiProvider. MultiProviders are used for unions, not joins.

John Hawk