cancel
Showing results for 
Search instead for 
Did you mean: 

MultiProvider

Former Member
0 Kudos

Gurus,

I have 2 data target:

InfoObject Master Data 0WBS_ELEMT. This Master Data has the following:

Cost Center

Company code

Controlling area

Responsible Person

Fiscal year

Business area

Plant

InfoCube WBS Budget, have the following fields:

Budget Amount

WBS Element

Plan Version

Fiscal year/period

Controlling area

Now, I would like to build the multiProvider on top of this two datatarget. My requirement is the Plant will be used as part of the selection criteria on the screen. Question is, I dont have the Plant field in InfoCube WBS Budget, am I still able to use

the Plant as the selection criteria on the screen?

Please advice, thanks.

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

good info

Former Member
0 Kudos

OK, let me make it more clear. Since Infoset uses Join, All the objects are available to you for selection, even Plant. Plant is there in the master data...so if you give plant 100 in selection, it will reffer to some WBS element, and based on this wbs elemt, data will be picked up from the cube(join property). The same holds for others characteristics also.

Thanks...

Shambhu

Former Member
0 Kudos

I dont think so..because MP will have Union...since plant is not there in the cube, it wont pick up any records from the cube. ( would be better if you try this and see).

But I am sure that Infoset will bring the data in this case.

Thanks...

Shambhu

Former Member
0 Kudos

Hi Shambhu,

Let me try and get back to you then.

On your suggestion, using InfoSet to join the WBS between the InfoCube and InfoObject, then the WBS will be my selection criteria.

However, there are other like Resposible Person, Business Area and Company Code will be my selection selection criteria also

on the report. All these field avaiable only in the InfoObject, not in the Cube.

How should I goes about this?

Please advice, thanks.

Edited by: PM on Sep 11, 2008 5:32 AM

Former Member
0 Kudos

you can not outer join infocube in an infoset.Only inner join is possible.only common records in both cubes will be disaplyed.but you can get plant infoobject .

Former Member
0 Kudos

As far modelling is concern, you can have a selection on PLANT in the report. But the problem is, since you dont have plant in the cube, it will not pick up any records.(I hope it will behave like this). In your case, I feel infoset will be a good option as it joins the data. In that case, you will have the value based on common fields.(wbs_elemnt).

Thanks...

Shambhu

Former Member
0 Kudos

What if I just turn on the navigation attribute for the Plant in the InfoObject, then turn-on the navigation attribute again in the InfoCube for this?

(although in the datasource for the InfoCbue, I dont have this Plant field so no data is updated into this field in the Cube.)

Will this help to achieve what I want?