BEx WAD - replace Table Interface Class

[former_member206621]

In BEx WAD 3.5 you could make use of the Table Interface Class to add your own logic to your report.  This functionality disappeared in BEx WAD 7.0.  We now want to upgrade all our reports from version 3.5 to version 7.0 but we have the following issue:

we use the method CHARACTERISTIC_CELL to transform the data from SAP BW from text to hyperlink.  How can we now achieve the same in BEx WAD 7.0?

An example: the data in SAP BW looks like R=<fiscal year>, <company code>, <invoice number>

In the method CHARACTERISTIC_CELL we transform this to http://<URL>, R=<fiscal year>, <company code>, <invoice number>, HASHKEY

This hashkey (MD5 hash) is calculated based on fiscal year, company code, invoice number and a secret password.

The result of this method is a secured link to the PDF version of the invoice.

How can we now achieve the same in BEx WAD 7.0?

(or if this would be easier: how can we implement this in other reporting tools such as: BO Advanced Analysis OLAP edition, BO WebI, ... - the only reporting tool where we already implemented the logic is in BO Advanced Analysis MS Office edition where we could make use of VBA).

Kind regards,

Lieselot

PS: we do not want to create the URL in SAP BW because we then loose the flexibility to change a part of the URL or the password

[yasemin_kilinc · Accepted solution]

Hi Lieselot,

In WAD 7.0 Table Interface class is replaced with modification modules. On analysis item properties you will see the option modification in internal display properties. You may find some mor information on:

http://help.sap.com/saphelp_nw70/helpdata/EN/29/4d15422ecce02ce10000000a1550b0/frameset.htm

hope it helps

Yasemin...

[former_member206621 · Accepted solution]

I know we can use modification modules but how can we call our own javascript module with the required field of the ANALYSIS_ITEM as input parameter?

Has anyone a working example of this?

The only examples I can find are examples where standard SAP modules are used but we want to call our own javascript module.

I now get the error message that it cannot load the module I tried to implement.

[former_member206621 · Accepted solution]

In our case it was not possible to replace the Table Interface Class with javascript.  We now use the RRI (to an ABAP report) to replace our functionality.