Skip to Content
0
Former Member
Dec 01, 2006 at 07:09 PM

Cannot solve modeling problem

26 Views

Hi experts,

We are trying to model a new infoprovider to solve a report problem but we can’t figure out how to model it, nor if it’s 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