Skip to Content
author's profile photo Former Member
Former Member

MultiProvider

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2008 at 01:22 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      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?

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2008 at 03:03 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 11, 2008 at 03:34 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 23, 2008 at 07:40 AM

    good info

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.