cancel
Showing results for 
Search instead for 
Did you mean: 

Change the layout of a query items in BEx analyzer

Former Member
0 Kudos

Hi,

I had developed a query, so when it is viewed in BEx analyzer the items(Char and Keyfigures) that i had used in rows and columns are displayed in analyzer.

Apart from this in report i can see the items i had used,

in top corner.

So i need to change the layout of these items in top corner ie. 1. all charac

2. all keyfigures

or combination of both in priority wise, is it possible.

Pl post.

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi

Thank you for ur concern. But my ques is, after display of report we will see the char in the top left i.e only the items will be displayed.

I need to change or nodisplay this layout is it possible.

former_member188325
Active Contributor
0 Kudos

Hi,

You can delete them from Query output and Save it as workBook.Then Open the workbook.You will not see them again whenever you open your workbook.

Right click on result area of output>properties>interaction tab-->enable 'Refresh Query when opening workbook' and save the work book so that whenever workbook is opened,you will get selection screen.

Pl dont forget to reward points if it helps.

Former Member
0 Kudos

Hi Thank u

Refresh query is ok.

But sol. for my ques doesnot work.

Former Member
0 Kudos

You can try Layout -> Move result Area and point it to the first column and first row.

Refresh the query and select the 3rd option (insert row option).YOu can find the result from first column first row.

Save the Workbook.

This solution works only with workbooks.

Regs

Gopi.

Assign points if it helps ..

former_member188325
Active Contributor
0 Kudos

Hi,

You can try it with Text Elements option.

You can find it in Bex tool bar after displaying the Query result. i.e 4th icon from right .

Layout-->display text elements --> you can choose one of 'all', 'general', 'Variables', and 'Filters'.

Hope this helps.

Former Member
0 Kudos

Hi,

I have not understood your question correctly

"So i need to change the layout of these items in top corner ie. 1. all charac

2. all keyfigures

or combination of both in priority wise, is it possible."

If you are trying to change the layout of the query then you can do it using the local view in the report.