Skip to Content
Author's profile photo Sreedevi Venugopal

Enhancement of Lumira document to support Full, Part and Prompts/Variables options via OpenDocument URL for SAP Lumira, server for BI Platform

This blog describes how one can view different lumira document using full or part mode which includes Bookmark, Story Name and Page Number as well as the prompts currently supported in the product using different variable types via the OpenDocument interface in SAP Lumira, server for BI Platform. The below parameters are supported only for Discovery based documents.

 

Prompts/Variables Input Parameters:

 

User should be able to specify the Prompt/Variable values for all prompts currently supported in the product, specifically the below variable types:

  • Multiple Values

Specifies multiple values for a prompt. [Name] is the text of the prompt

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQoRjVb584NPmlQ9cNwYLD4&sRefresh=false&lsMCountry=India;China;Australa

  • Single Values

Specifies a values for a single prompt. [Name] is the text of the prompt

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQoRjVb584NPmlQ9cNwYLD4&sRefresh=false&lsSCountry=India

  • Range Values

Specifies a range of values for a prompt. [Name] is the text of the prompt

For BW:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQoRjVb584NPmlQ9cNwYLD4&sRefresh=false&lsRCountry=[India..China]

For Hana:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQoRjVb584NPmlQ9cNwYLD4&sRefresh=false &lsSCountry(Start)=Belgium&lsSCountry(End)=Botswana

For UNX:

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=AQoRjVb584NPmlQ9cNwYLD4&sRefresh=false &lsSCountry=Belgium&lsSCountry(2)=Botswana

  • Index/Key

Specifies Index or Key value. This parameter must be associated with one of the parameter lsS, lsM or lsR

Index:

http://<servername>:<port>/BOE/OpenDocument.html?iDocID=AeMYi4ShtTlBhImLjK0k4EU&sRefresh=false&sReportMode=full&lsSCountry Single Value Optional=Argentina&lsICountry Single Value Optional=1

Key:

http://<servername>:<port>/BOE/OpenDocument.html?iDocID=AeMYi4ShtTlBhImLjK0k4EU&sRefresh=false&sReportMode=full&lsSCountry Single Value Optional=3302

 

Note:Index/Key parameters are used for BW documents. User should manually enter Prompts/Variables parameter in the OpenDoc URL, because these parameters will not get generated in the open doc link of Lumira document.

 

 

Full and Part mode

 

  • Full mode:

User should be able to be taken to Story/Page/Bookmark if the parameter is mentioned in the open doc URL, but using full mode options he would be able to navigate to other stories/pages/bookmarks. Save bookmark and set as default for bookmark is enabled in full mode option.

But the document actions should be enabled/disabled depending on document-level rights of the user.

By default once you generate open document link the ReportMode is set as “Full”

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=FmBKA1ctBwcAd2IAAACHkTUAAFBWAUy9&sRefresh=false&sReportMode=full&sStoryName=BestRunCorp%20Analysis&sPageNumber=1&sBookmark=Bookmark1

  • Part Mode:

User can specify the required parameters in the Open document URL to view only particular Story/Page/Bookmark by setting the option “ReportMode=Part” in the generated Open document Link

    1. If the user provides only the Document as part mode parameter, then user will able to switch between stories, navigate between pages, switch between bookmarks and apply filters.
    2. If user provides only the Document and Story as part mode parameter, then user will not be able to switch between stories, would be able to navigate to pages or switch between bookmarks and apply filters
    3. If user provides only the Document, Story and Page as part mode parameter, then user will not be able to switch between stories or navigate to pages. User can switch between bookmarks and apply filters
    4. If user provides all the parameter in part mode such as Document, Story, Page and Bookmark. User will not be able to switch between bookmarks or stories or navigate between pages, but user can apply filters.

 

Note: For user using part mode parameter all the Document actions are hidden and Bookmark actions such as set as default and save bookmark are disabled.

 

                http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?                                                sIDType=CUID&iDocID=FmBKA1ctBwcAd2IAAACHkTUAAFBWAUy9&sRefresh=false&sReportMode=part&sStoryName=BestRunCorp%20Analysis&sPageNumber=1&sBookmark=Bookmark1


Support for Bookmarks:

 

User will be able to share OpenDoc URL for Bookmarks, parameters supplied in the OpenDoc URL are:

  • Bookmark Name
  • Bookmark Type – This is an optional parameter and would be required if we have multiple bookmarks with the same name.

http://<servername>:<port>/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Acd4iYd0wctEpiPuaNn_9so&sRefresh=false&sReportMode=full&sBookmark=test1&sBookmarkType=Personal

 

Note: If user provides only bookmark name parameter in OpenDoc URL and the document has multiple bookmarks with same name, then the global bookmark will be opened.

 

Open Document in New or Same window:

 

If the User embeds the URL in the Hyperlink and wants to open the document using Open document URL in the same or new window then the below parameter is used.

&swindow=new or &swindow=same

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hello,

      Very good post thank you.

       

      Input parameters works fine, but I also need to pass some dimensions filters.

      Do you know if it is possible via URL ?

      Best regards,

      Stefano

       

      Author's profile photo Sapanesh Agnihotri
      Sapanesh Agnihotri

      Hi

      Below URL is not working, giving refresh failed error with parameter

      http://192.168.23.20:8080/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&iDocID=Fv10.VpDgwYAZA8AAAAnDb4AAFBWly6k&sRefresh=false&lsSIP_PARAM=ABC

      IP_PARAM is the parameter in Hana with accept ABC in backend for all other value returning blank in hana

       

      if we remove parameter open doc works. please suggest if this supported.

       

      Thanks

       

      Author's profile photo Sowmya Kalidindi
      Sowmya Kalidindi

      Make sRefresh=true  and try

      Author's profile photo Sowmya Kalidindi
      Sowmya Kalidindi

      BW Offline: Open doc URL should have Variable description for the prompt to get applied. We  need to give only lsS  as it shows only text in the chart. Example: Austin.

      BW Online/Live: Open doc URL should have Variable Techinal name in the URL for the prompt to get applied. Make sure you give both lsS and lsI, as it shows both index and text in the chart Example: (6|Austin).

      Author's profile photo Hadi Jafari
      Hadi Jafari

      Hello,

      How is it possible to embed login credentials (User name, Password) as parameters in the generated link?