List of all queries with tabular views

[Former Member]

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

[Former Member · Accepted solution]

Hi,

Check this table RSRREPDIR

Regards

Md Zubair Sha

[Former Member · Accepted solution]

Any suggestions ????

[Former Member · Accepted solution]

Hi,

i dont think you can see all queries in a Tabular view , but yes you can see in a singal Query

You can use Report Designer to display a query in a tabular view. Characteristics and key figures are displayed in the columns in the tabular display.

In Report Designer, you can align characteristics, key figures and attributes in the columns exactly how you want. For example, you can put a key figure column between two characteristic columns. The column display is determined when the query is designed and cannot be altered.

Step1

Insert a report section into your report. This report section must be based on a query with a structure as a data provider.

Step2

Expand all group levels In the query by dragging all group level characteristic fields (attributes) from group level G1 to the row pattern in the detail area.

(To drag the characteristic fields to the detail area, click the relevant row, click the field and then drag it to the detail area.)

Step3

Delete all empty rows that result from moving the characteristic fields. To do this, select the row and delete it using the context menu.

Step4

To change the position of a column, select the entire column and enter the required position in the Properties screen area under the Properties tab.

Note that the Hide Repeated Key Valuesfunction from Query Designer is currently not supported in Report Designer.

Santosh

[Former Member · Accepted solution]

no my question remains unanswered

i want list of all queries for which Tabular Display is selected in Query designer.

is there a way to find list of all queries with Tabular display

[former_member213877 · Accepted solution]

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

[Former Member]

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.

[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...