Skip to Content
Author's profile photo Former Member

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

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

Assigned Tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Martin Maruskin
      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./

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Martin

      Thank you for your reply. I'll (try to) squize in the SICF somewhere today đŸ™‚

      Gr

      Sven

      Author's profile photo Former Member
      Former Member

      Hi Sven

      Parameter.PNGI'm missing export parameters in FM as in above screen shot

      cheers

      Raj

      Author's profile photo Martin Maruskin
      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./

      Author's profile photo Former Member
      Former Member

      Thanks Martin

      Cheers

      Raj

      Author's profile photo Former Member
      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.

      Author's profile photo Sherif Elkoumi
      Sherif Elkoumi

      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

       

      Author's profile photo Alexander Kutz
      Alexander Kutz

      You get easy the URL if you test in SE80 the Web Dynpro Application RSO_METADATA_REPOSITORY

      Author's profile photo Damian Zurawski
      Damian Zurawski

      Alexander Kutz note that you're talking about similar view - but not same as showed in this tutorial.