Skip to Content
author's profile photo
Former Member

BI Bex Excel output Question

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • author's profile photo
    Former Member
    Posted on Sep 21, 2007 at 06:52 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Sep 21, 2007 at 09:02 AM

    Ram

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

    Srikant

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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?