Skip to Content

Displaying the SAP BW Metadata Repository via a (web) URL

January 21, 2015 | 2,272 Views |
 biBusiness Intelligencebwmetadata repositorysap bwurllinking
Follow

All of us, who’ve been around in SAP BW for a while, will recognize the picture below. The ‘good old’ meta data (repository) available within a SAP BW system and accessable via transaction RSA1

6.JPG
But how to access this repository from ‘outside’ SAP BW. Thus without RSA1 and via a (web) URL?

  • First of all we need to know which URL to use to access our BW system. To find out which URL to use, transaction SMICM comes in handy. After executing SMICM, go to the ‘services’ information (via SHIFT+F1) and the following information will be shown

0 smicm - shift F1 services.JPG

(For confidentiality purposes I’ve blurred/greyed out/removed some information in the above (and below) pictures)


  • When the Host Name is not completely shown (via SMICM ->services), transaction SE37 offers a solution. Start SE37 and execute/test a function module called RSBB_URL_PREFIX_GET

1.JPG

  • Input parameter I_HANDLERCLASS should be filled with the value CL_RSR_WWW_HTTP

2.JPG

  • When executing the function module with the above mentioned input parameter value, the following output will be provided

/wp-content/uploads/2015/01/3_629226.png

  • Output parameter E_URL_PREFIX (as marked with a red box in the picture above) will give you the entire/complete URL which can be used to access the BW system via a webbrowser.


Beware: The port number, in this case 8100, is not correct! The port number delivered by transaction SMICM, in this case 3299 (see the red box in the first picture), should be used


  • Use the URL_PREFIX in combination with the SMICM port number to generate the following string:

http://ic**blur**.ics-eu**blur**.com:3299/SAP/BW/DOC/METADATA/?page=BW_O_TYPES&SystemID=BHDCLNT100


(**blur** : for confidentialty reasons I’ve removed parts of the URL)

(BW_O_TYPES: Enter this static text to receive an overview of active repository objects)

(BHDCLNT100: A concatenation of <systemID>, “CLNT” and  <clientnumber>)


  • The following information will be shown when entering the above URL in a webbrowser

4.JPG

  • When you’re not interested in the entire BW metadata repository, but, for example, in the metadata of a particular multiprovider, small adaptions have to be made to the URL. 

Let’s assume that I’m interested in the metadata of multiprovider MP_0039. In this case the following URL would do the trick


http://ic**blur**.ics-eu**blur**.com:3299/SAP/BW/DOC/METADATA/?page=BW_O_D&SystemID=BHDCLNT100&ClassID=MPRO&ID=MP_0039


5.JPG

  • This URL can now be used to directly access the BW metadata from (almost) any webpage. For example when embedding SAP BW metadata within a sharepoint page

ps. As mentioned by Martin Maruskin : The service SAP/BW/DOC/METADATA needs to be activated in tcode SICF.

Execute transaction SICF. Navigate all the way down to SAP -> BW -> DOC -> METADATA, right click on METADATA and select activate

7.JPG

To report this post you need to login first.

8 Comments

You must be Logged on to comment or reply to a post.

  1. Martin Maruskin

    Hi Sven,

    I like your idea of sharing BW metadata repository in e.g. intranet pages related to documentation fo BW project as you mentioned in sharepoint.

    Just want to add that service SAP/BW/DOC/METADATA needs to be activated in tcode SICF.

    cheers,

    m./

    (0) 
    1. Martin Maruskin

      Hi Raj, you just need to run the FM and then you will get the export params…Simply click on Execute button – green icon on the toolbar – first one from left.

      cheers

      m./

      (0) 
  3. Former Member

    Thanks for that Sven. It works really well and it’s nice to have that back because the 7.3 version of the metadata repository is not as user friendly as the this version.

    (0) 
  4. Former Member

    Hi Sven,

     

    how can I change the host name? I moved to another host and when I try to open the metadata reposotiry,  I get the error Service cannot be reached 

    I need to change the setting of the URL, how can I achieve that.

    thanks in Advance,

    Sherif

     

    (0) 

Leave a Reply