Skip to Content
avatar image
Former Member

WAD: Showing technical details of your web report

In the Web Application Designer we have made reports that use several data sources (queries and views) and at the bottom a 'Text Element' web item that shows information about the report.

To speed up debugging of reports we would like to see more information than what is displayed in the Text Element web item. These include:

1. All the technical names of the data sources (views)

2. All queries connected to the web template (not only the query that is used on the data source that provides data to the Text Element box)

3. The technical name of the web template.

Is there a way to display this information easily, either using an enhanced Text Element box or displaying them directly in an other way?

Best Regards

Jon Christopher Knudsen

Norway

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Jul 20, 2004 at 03:26 PM

    Jon,

    To display the technical name of the web template being used, you can call a JavaScript function to get the value. The example below shows this and pops up the name in an alert box.

    <SCRIPT language="JavaScript">

    var text=SAPBWGetProperty("TEMPLATE_ID");

    alert(text);

    </SCRIPT>

    I'm not sure if I understand your report setup to advise on the other things you were asking about. If you are saying that your template contains multiple table reports (each with different queries), then I would think you could do multiple Text Element items and point them to each of your different data providers to get the INFOCUBE and REPTNAME values.

    Jody

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 21, 2004 at 07:44 AM

    The report name script worked fine.

    What I was looking for in addition was a small script to read off the the data provider names.

    Example:

    The object might look something like this:

    <object>

    <param name="OWNER" value="SAP_BW">

    <param name="CMD" value="SET_DATA_PROVIDER">

    <param name="NAME" value="DATAPROVIDER_1">

    <param name="DATA_PROVIDER_ID" value="ZVO_ORGC_BYC_G1">

    DATA_PROVIDER: DATAPROVIDER_1

    </object>

    And I want to read off the value "ZVO_ORGC_BYC_G1" and print it in my report.

    Is there a way to read this value and print it in my report?

    Best Regards

    Jon Christopher Knudsen

    Oslo, Norway

    Add comment
    10|10000 characters needed characters exceeded