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

quries from the cube

How can I find out all quries created from one info providor like cube, ods and multi provider. any idea

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 07:34 PM

    login to ur system

    use Transaction code RSA1-> hit okey

    select the last option -> METADATA REPOSITORY

    go to tab ACTIVATED OBJECTS IN SYSTEM PROD.

    select where u wish to see the queries like ODS,INFOCUBE,MULTIPROVIDER etc.

    select it and hit OK

    now select ur cube say xx

    select it and hit okey

    NOW scroll to the bottom u will see the list of all queries for ur cube that is activated.

    u can also try other options such as

    LOCAL OBJECTS

    OBJECTS FROM ALL SYSTEMS

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 04:28 PM

    In the Admin Wkbench, go to the MetaData Repository, choose InfoCube, choose your cube - then you should scroll to near the bottom to find all teh queries for that cube.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 09, 2008 at 08:00 PM

    You can use Table - RSRREPDIR - If that gets you the list faster. ( COMPID )

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2008 at 04:30 AM

    Hi Mat,

    You can just go to RSRT t-code and then in the query name press F4 and give the infoprovider name and can see all queries underneath tat.

    Also u can see the right hand side Infoareas and select the one in which ur infoprovider is present n just click that one(maybe DSO,CUBE,MULTIPROVIDER OR INFOSET) and doudle click tat u can see all the qureiesdefined for that info provider

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 10, 2008 at 04:58 AM

    Try table RSRREPDIR, this will be very helpful.

    Khaja

    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.