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

R/3 Query in BI

Dear all,

Can anyone tell me how to adopt the R/3 query created in SQ01 be adopted in BI as datasource and for further modelling.

Regards,

M.M

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2007 at 09:52 AM

    Hi,

    well normally just goto rso2 in your r/3, select Sap-Query as extraction method and enter the name of your query. Make sure your query is defined globally and ready for transport. Generate your datasource.

    regards

    Siggi

    PS: check out: http://help.sap.com/saphelp_nw70/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm

    and open Data Warehousing->Data Acquisition->Data Extraction from SAP Source Systems...

    Message was edited by:

    Siegfried Szameitat

    Message was edited by:

    Siegfried Szameitat

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 23, 2007 at 09:04 AM

    Dear Siegfried Szameitat,

    Thank you for your input. Your answer was helpful - i do have some basic doubts which i think you can clear.

    I tried to create datasource using RSO2 which wanted the infoset and finally the request was rejected by the system for the want of access key. Should i have abaper authorisation for creating through this.

    If yes - is this the only way or can i create it through some other method - i am not an abaper and i do not have abaper authorisation.

    Further - the link mentioned by you also doesn't give full step by step process of what has to be done for this - can you kindly explain?

    Regards,

    M.M

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Magesh,

      I think u do not have a authorisation for that infoset query which u r trying to use as a extractor in datasource.The authorisation regarding that query should be added to ur role to access that.So u contact ur security team to give authorisation for that query.

      Hope this helps

      Sunil Reddy

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 05:17 AM

    Dear Sunil Reddy ,

    Sorry for the late reply. I checked as per your information and found that there are no missing authorisation. When i create a datasource in RSO2 using the infoset of a specified query - while saving, the system prompts for access key.

    What should be done for this.

    Regards,

    M.M

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      You need to have the developer access key.This would be generated by the basis folks.

      Developer Access is a 16 digit id which should entered the first time when you are creating an object in the system. Get in touch with Basis folks & request them for this key.

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.