Hi experts,
We are trying to model a new infoprovider to solve a report problem but we cant figure out how to model it, nor if its gonna be a Infocube or Datastore Object. Using the excel to draw a template, we designed what could have been a solution using an infocube and a DataStore Object but neither solve the problem.
This new infoprovider has the following DataStore Objects as datasources:
DataStore Object "Bid Invitations"
Bid Invitation ID (key) External ID Description 70000001 11111111 Bid Invitation A
DataStore Object "Invited Bidders"
Bid Invitation ID (key) Bidder (key)
70000001 bidder1
70000001 bidder2
70000001 bidder3
DataStore Object "Bidders"
Bidder (key) Bidder Phone Bidder Address Bidder E-mail bidder1 2222-2222 Address A bidder1@email bidder2 3333-3333 Address B bidder2@email bidder3 4444-4444 Address C bidder3@email
We designed the following solutions...
Using Infocube or Datastore Object
[Bid Invitation ID (key in ODS)] [External ID] [Description] [Bidder (key in ODS)] [Bidder Phone] [Bidder Address] [Bidder E-mail]
70000001 11111111 Bid Invitation A # # #
#
70000001 # # bidder1 # #
#
70000001 # # bidder2 # #
#
70000001 # # bidder3 # #
#
# # # bidder1 2222-2222 Address A bidder1@email
# # # bidder2 3333-3333 Address B bidder2@email
# # # bidder3 4444-4444 Address C bidder3@email
...and we want the following:
Goal (DataStore Object or Infocube)
Bid Invitation ID External ID Description Bidder Bidder Phone Bidder Address Bidder E-mail 70000001 11111111 Bid Invitation A bidder1 2222-2222 Address A bidder1@email 70000001 11111111 Bid Invitation A bidder2 3333-3333 Address B bidder2@email 70000001 11111111 Bid Invitation A bidder3 4444-4444 Address C bidder3@email
We want this because we are going to filter this new infoprovider using the infoobjects Bid Invitation ID, External ID and Description. So, every line in the infoprovider must present a value for those infoobjects. Does anyone know how to solve that problem?
Thanks.
Thiago Braga