Including InfoObject to MultiProvider

[philipp_vavron]

Hello Experts,

looking for this in previous postings, but found nothing similar.

I have a MultiProvider with two InfoCubes of 0FIAR-Area. In both of this cubes InfoObject 0DEBITOR is included as customer. Now I need some sales related customer attribues, which are part of InfoObject 0CUST_SALES, which is not included in the InfoCubes? Is it necessary to modify one of the cubes when I need only the attributes of an InfoObject?

My first try would be to modify 0CUST_SALES to create a InfoProvider and include this InfoProvider into the MultiProvider definition. Does this make sense?

Thank you for answering.

Phil

[Former Member · Accepted solution]

Hi,

if i underastnad your question properly , the customer directly available in infocube right .if you require customer just drag and drop customer infoobject in rows.

Regards

sivaraju

[philipp_vavron · Accepted solution]

sivaraju, thanks for answering.

I've included the InfoProvider in MultiProvider-Definition an allocated key & the needed attriutes.

But in RSRT the query for the MultiProvider shows no data ('#'), even if I report only 0CUST_SALES-data. Master data for 0CUST_SALES is loaded and no filters are active in query. Did I missed something?

[Former Member · Accepted solution]

Hi,

It seems like this infoobject data is not available in one of infoprovider.

Regards

sivaraju

[philipp_vavron · Accepted solution]

because of this I've made 0CUST_SALES to a InfoProvider itself. My expectation was, it would behave like one of the cubes itself. seems to be a fail.

[former_member223480 · Accepted solution]

Hi Phil

FiAR doesn't have sales information. In this case i don't know if it is possible to add the cust_sales infoobject.

0debitor depends on customer. 0cust_sales is compound with sales organization. In case the you have more than one sales organizations you may not be able to match the records.

If you can find a pattern then you also need to fill for each record sales organization infoobject.

regards

Yiannis

[philipp_vavron · Accepted solution]

Hi Yiannis,

thanks for the answer.

My intention was to filter salesorg, distribution channel and so on in the query based on the multiprovider (in this case there's only one of each). I expected something you would call a cross join in sql: all possible master data records of 0CUST_SALES for each entry in 0FIAR. But not even one dataset of sales data? I have no explanation for that ...

regards

-Phil

[former_member223480 · Accepted solution]

Hi Phil

I don't think what you want can be achieved with the multiprovider. You want to match rows from FIAR with master data of 0cust_sales. Your connection is the customer code.

But if you will do a filter, to match the sales org, then you are loosing this join.

Go for an infoset in your case.

Regards

Yiannis

[philipp_vavron · Accepted solution]

Hi Yiannis,

thanks for the hint, i will take a look at InfoSets.

Do i have to rebuild the query then, right?

-Phil

[former_member223480 · Accepted solution]

You can copy the query with RSZC transaction.

[philipp_vavron · Accepted solution]

That should be all I need to solve the problem.

Thank you!

-Phil