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

Using Multiprovider in Open Hub

Hello Experts,

I want to create a Open Hub Destination with characteristics and keyfigures from two different cubes. Most of the data is coming from one cube but there are 3 keyfigures that i need to pull from a different cube. When I create the OHD the drop down box does not give an option for Multiprovider but I have read in SAP literature that a Multiprovider can be configured to be used as a template for OHD. Or we cannot use multiprovider as a template for OHD becasue it does not hold actual pysical data.

Do anyone of you have any knowledge on this subject and also can you recommend an alternative solution to what I am trying to accomplish.

I know I can create an open hub destination without using an infoprovider for a template and manually create the keyfields, but when I do that some of the keyfigures which are listed as navigation attributes in the cubes are not being recognized.

Any suggestions would be really appreciated, thanks in advance.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2011 at 03:29 PM

    hi sapbian,

    I really doubt if you could create OHD with MP and also not because MP is not holding data that you can't use for OHD but you can't create transformation from MP. We can create OHD from Infosource or Datasource, both don't physically hold data but you can create transformation from them, that is why it is possible to create OHD from those objects.

    Two options here...

    1. Either send them two files.. one from each cube in the MP.

    2. create anther transformation from the souce cubes to another cube or DSO and use that one from OHD structure.

    I would recommend the latest option.

    thanks.

    Wond

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2011 at 04:53 PM

    I have a realted question

    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.