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

List of all queries with tabular views

Hi

I need to fix all the queries that is in "Table View" in bw 3.5

Is there a standard report that i can run, will tellme all the queries in Tabular view.

Or is there a database table that willl give me all the queries in tabular view.

any ideas suggestions appreciated

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 Nov 06, 2009 at 05:24 PM

    Hi,

    Check this table RSRREPDIR

    Regards

    Md Zubair Sha

    Add a comment
    10|10000 characters needed characters exceeded

    • Dear Kartikey,

      In the table RSZELTPROP you can identify elements having field FLAT_LIST = 'X'. These are queries saved in Tabular (Flat) mode. The technical names of those queries you may get in the next step from the table RSZCOMPDIR (technical name of a query is in COMPID field).

      Hope this helps..!

      -Pradnya

  • author's profile photo Former Member
    Former Member
    Posted on Nov 06, 2009 at 03:59 PM

    Hi Kartikey,

    If I understand it right, you are looking for a list of all queries on your BW system. If so, you can get the list using RSA1 transaction. Do you have access to it?

    You open up the BW from SAP logon window and run the transaction RSA1. In there, pick the Metadata repository option from bottom left. Then it will show up all the objects on right side, click on Query and it will bring a complete list of queries. You can use ctrl + A to select all and then Copy and paste that data to Excel. It takes a while if you have lot of queries.

    Hope this helps!

    Archana.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Archana, that will just give me list of queries...

      out of all the complete list i want list of queries for which "Tabular view" is selected....

      it should be only subset from whole list of queries...

      i know i can open it in query designer, one by one but that will be long procedure...

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.