Open Hub services in BI 7.0

[Former Member]

Hi Experts,

I am working on BI 7.0 and have a requirement where i have to extract data from a standard sales cube(0SD_C03).I will be using open hub services,but i also need to send the master data attributes along with this into the application file server.

I did the following steps

1) created an openhub destinationa as a CSV file and selected the fields i needed.(Cube has 80+,but i selected only 10 fields for my file).

2) added an infoobject YINVGP which is an attribute of 0Material

3) The transformations were automatically created by the system.

4) Created a tranformation between 0MATERIAL and its Attribute YINVGP and selected the rule type as "Read Master Data".

5) When i click on transfer values to activate the changes,its giving me the following error.

Rule11(Target/BIC/YINVGP Group:01 Standard group) No master data characterstic selected.

Rule(Target Field:/BIC/YINVGP) No source assigned.

Can the experts confirmif i am missing anything?If so please suggest on how to get the master data using open hub services.

Is this possible with open hub services,if so i would really appreciate anybody can pass me screenshots or step by step procedure,as i have not worked on open hub earlier.

thanks in advance

[Former Member · Accepted solution]

Hi Vamsi,

I am not an expert but you can take a look into this - http://help.sap.com/saphelp_nw04s/helpdata/en/43/79f902dfb06fc9e10000000a1553f6/content.htm

Hope this helps,

Bye...

[Former Member · Accepted solution]

Hi Naga,

I have seen the link you have sent me.It doesnt really help me.But thanks anyways.I am able to create a CSV file,which is not a problem.But my question is can i get the attributes of 0Material to appear in the same file.SAP has provided an option to read master data in the transformation rules,and when i try to use the rule,its giving me an error saying source has not been assigned.

thanks