Using Multiprovider in Open Hub

[Former Member]

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.

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

Hi Wond,

Thanks for the answer, makes a lot of sense. Also appreciate your explanation as to why we cannot use mp for ohd.

points awarded.

[Former Member · Accepted solution]

Hi Wond,

I have another question with respect to creating an open hub with data from different cubes. what i had done earlier was that i had created an open hub without using an infoprovier for template. Then when I clicked on the KeyFields tab to define the key fields there I used the InfoObjects as a template and this allowed the data to be pulled in from whereever that infoobject was located. So all the keyfigures and most of the infoobjects got created that way. However, there are some fields that are navigation attributes and when i enter the technical name for the navigation attribute in the "InfoObject Template" column I get an error such as "InfoObject 0SOLD_TO__0COUNTRY is not available in version A". Is this becasue this is a navigation attribute and therefore cannot be used a template to create the key field. So how would I include this navigation attribute in my OHD. i tried entering the information manually, without using any templates but that did not work either. I entered the navigation attribute technical name in the field name, like so: Field = 0SOLD_TO__0COUNTRY, Description= Sold-To party Country, InfoOject Template= left this blank, Type = "CHAR" Length = "3"

When i hit enter I get an error saying that "you may not use 0SOLD_TO__0COUNTRY as a field name".

Any suggesstions or recomendations would be appreciated, Thanks in Advance.

[Former Member · Accepted solution]

If you want to get the attribute of master data object, then you just write a small logic to read from 0sold-to, in the transformation there is no way can populate attribute of master data object.

thanks.

Wond

[Former Member · Accepted solution]

Hi Wond,

Thanks for the answer. for testing purpose I created the open hub by using infoobjects as templates from the source cubes, i did not use thenav attributes. However, when I created the transformation, the screen where you have to identify the source and the target objects for the transformation, you can only enter information about on ecube only. So my open hub detsination conatins key fields from 3 different cubes but when it is time to do the transformation I can only name on eube in the source field. Now when i execue the transformation the chanracteristics and keyfigures that are present in teh source cube are identified but for other fields there is no transformation. So will I have to create another transformation, using the second ube this and then the third time to do a transfromation beteen the third cube and the open hub.

Thanks,

sapbian

[Former Member · Accepted solution]

Yes, you could do it that way, the only problem with that is you will be getting three different data sets. Let's assume you will be executing the first transformation, the data will go and sit in the OHD, the second time you execute the second transformation, the first file will be overwritten by the second one, I don't think you would want that. A solution for that is once you execute the first time, take the file and rename it. Either way, you will end up having three different file for the business users.

Another solution to that would be you can write a program to merge all the three files before you send the file to the business users, but that would require coding.

If three files is not acceptable by the business users, then I would recommed you get everything in one data provider and do only one tranformation.

Hope I am clear.

thanks.

Wond

[Former Member · Accepted solution]

Yes I think doing the transformations between source cubes and a new cube and then creating the open hub based on the new cube is probably the best solution. I was just brain storming and thowing out ideas to see if there are other ways to tackle this problem. You are right the business user would not like having to manipulate 3 files, plus adding a program to merge the three files i dont think will work out the best if you think in terms of maintenance and scalability, etc. The last idea that was dancing around in my head was that, if you need information from a multiprovider, then probably an open hub is not the best solution, what if I create a BEx report that can be downloaded into Analyzer by the business user and then they can manipulate/analyze the data in excel as they want. What do you think.

Thanks In Advance!

[Former Member · Accepted solution]

Okay the first issue was resolved. I do have another question, when the DTP for the OHD is executed. 2 files are created one file contains all the data and the other file with a "S_" prefix contains the meta data basically it has the column headings for the first file. My question is related to the second file i.e the file with the column headings, the issue is that the Field Name for standard BW objects is user friendly, for instance 0MATERIAL is listed as MATERIAL. However for customized objects the Field Name is not user friendly for instance "Orig.Sales Org" is listed as "/BIC/ZSALESORG". It gets even worse with Keyfigures for instance "Freight Revenue" is listed as "/BIC/ZVV810" and there is no other additoinal description. Is there a way I can bring in the field description in my open hub file so that it is more legible and not cryptic like this. Also when I use the infocube as a template any fields that are identified as navigation attributes in the cube do not come over in the open hub field definition tab. So basically the nav.attributes cannot be included in ohd.

Any suggestions would be appreciated. TIA

[Former Member · Accepted solution]

I think you can do it with APD, you can create a report on multiprovider the feed the data to a file if they want to, or you can put the data to transactional dso. I didn't know you have rooms to play with the model, that is why I was focusing only in OHD.

thanks.

Wond

[Former Member · Accepted solution]

would you please open another trade for this? I have a good solution for this.

thanks.

Wond

[Former Member]

I have a realted question