Skip to Content

Build a Standard Template for 1 or multiple Queries

Hi, I'm looking to develop a standard template that will support 1 or multiple queries/views. This I'm thinking I could implement through some kind of a drop down box.

I'm looking for a way to populate the drop down box with the necessary query or view names dynamically. Pass the infoproviders in the URL? The queries or views could be from multiple infoproviders.

Anyone have any creative ideas how to accomplish this?


Ken Murray

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on May 01, 2007 at 12:41 PM


    If you're hard set on using a dropdown box to select a report to run, that might be a little bit more effort than if you used standard functionality.

    As an alternative, you might want to consider leveraging authorizations and roles in NetWeaver. If you are using BW 3.5 or earlier, you can create a generic template with a Role Item, which is a menu of reports that a user is allowed to run. In 2004s, you can deploy reports in a more robust manner via SAP Portal. Both methods allow for report selection.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Kenneth Murray


      You can use ICPs, where you will have in-built drop down functionality. But this is old technology.

      But you can use new WAD, you can have one drop down item and one analysis item. In the drop down properties, under 'Data Binding' choose fixed list of options. When you click on that you enter the description and choose the command as' SET_DATA_PROVIDER_PROPERTIES'. For the fixed option 2, you give other description, but give the same data provider with different query.

      Hope this helps.

      Best Regards,


  • Posted on Aug 21, 2007 at 03:18 PM

    Will investigate further

    Add comment
    10|10000 characters needed characters exceeded