BI Bex Excel output Question

[Former Member]

I am using a default workbook setings for running my Bex queries in BI new Analyzer. I see that it comes with 3 tabs (or shall I call buttons) Graph/ Filter/ Information. Now I want to add a similar tab/button that will display all the static filters/ variables used and I am not sure how to proceed.

What I am trying to achieve is create a new button and when I click on it should expand to show me all the variables and statis filters used...and when I click back on it should close. Can soomeone give the procedure for this..

[Former Member]

Ram

Send me your mail Id. I have a document that might be of help to you.

Srikant

[Former Member]

Srikanth my id is ram.gowda@gmail.com, thanks.

[Former Member]

Hi Joke I have tried to add the statis filters under the filter tab but it gets a little ugly because the number of variables and statis filter I got are about 10 of them and so what happens is when I expand it, it overlaps with the actuals data (Analysis Grid). I dont know how to auto format it to adjust the rows based on the static filter. is there something easier that I am missing here?

Srikanth, my id is ram.gowda@gmail.com, please send me the doc you said you have got for this, thank you.

[Former Member]

I am using the SAP Standard template which has got 3 VB buttons in the Bex output Excel 1. Chart 2. Filter & 3.Information. Now what I am trying to do is to add the Variables (Display Static Filters) as another Text element in the Information tab...so that when they click on the information tab it will show all the variable used...What is happening is that when I add the static filters it is overlapping with the Table (Analysis Grid). Seems like I will have to write a VB Code to auto adjust the rows so that they dont overlap and I am having difficuty in achieving this. Can someone share the code needed to get this done. I went into the Tools -> Macro-> Visual Basic Editor and saw that the module1 is where we make the adjustments but not quiet sure where to exactly change the code......Can someone share their code or what to adjust please?

[Former Member]

Hi,

there is a document that explains how to add the same kind of buttons via VB.

You can also add the static filters just under the filters and if you then click on the button 'filter' the 2 filters will be displayed...

Ciao

Joke