on 2020 Feb 13 7:42 AM
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 .
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
11 | |
10 | |
10 | |
10 | |
8 | |
7 | |
7 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.