Build a Standard Template for 1 or multiple Queries

[sap_cohort]

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?

Thanks!

Ken Murray

[Former Member · Accepted solution]

Kenneth,

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.

[sap_cohort · Accepted solution]

We are on 2004s and are aware of using the Portal for report selection.

We would like to just develop 1 template with 1 Analysis Item and a drop down box. The Dropdown or combo box would list the available reports. This template would need to be our default template for groups of reports. Just as we have 0ANALYSIS_PATTERN for all single queries.

Example: I have a group of reports for Sales Mgrs and a different group of reports for Division Mgrs. I would need the same template to be able to provide reports to both groups. So the Sales Mgrs would have a dropdown listing of their reports and the Division mgrs would have a dropdown listing of their reports. Just 1 template should be able to accomplish this.

I just don't know how I could dynamically provide which infoproviders a call to the template should use.

Any Ideas?

Thanks,

Ken Murray

[Former Member · Accepted solution]

Hi,

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,

Rajani

[sap_cohort]

Will investigate further