{"id":7253,"date":"2020-03-24T00:21:06","date_gmt":"2020-03-24T06:21:06","guid":{"rendered":"http:\/\/www.designandexecute.com\/designs\/?p=7253"},"modified":"2020-03-24T00:24:15","modified_gmt":"2020-03-24T06:24:15","slug":"how-to-increase-data-democracy-with-sap-businessobjects-opendocument-remote-url-call","status":"publish","type":"post","link":"https:\/\/www.designandexecute.com\/designs\/how-to-increase-data-democracy-with-sap-businessobjects-opendocument-remote-url-call\/","title":{"rendered":"How to Increase Data Democracy with SAP BusinessObjects opendocument Remote URL call"},"content":{"rendered":"<h1>Benefits of using BusinessObjects opendocument URL<\/h1>\n\n\n<p>The very reason you searched and found this article means you ready know the power of this technology or have heard of it.  Here are some of the ways the opendocument can impress you managers and deliver more business value to your organization.<\/p>\n\n\n<ul>\n<li><strong>Use it in Share point or confluence sites<\/strong>.\u00a0 You can add the hyper link and still have the enterprise security of SAP businessobjects managing the authentication to the system, authorization of resources like reports and and data protection in column restrictions and row level filters of the data being returned.<\/li>\n<li><strong>Drill across in context:\u00a0 <\/strong>you can put links in the report itself and you may drill down to a context of interest, you can then drill across and see a totally different template layout of a different report while passing the declarative parameters that are needed for the context of the destination report.\u00a0 This makes the reports interconnected and somewhat of an explanatory application.<\/li>\n<li><strong>Use is embedded in other applications<\/strong> to make that remote calling application an analytic application.\u00a0 Let SAP businessobjects do what it does best reporting.\u00a0 You can extend the features set of your new application with all the reporting features of BO using the BO Java or .net SDK.\u00a0 Here you can log in and get a session token with time expiration capability.\u00a0 You can then pass this on the call so the user is never prompted so there is an anonymous login.\u00a0 PS.\u00a0 This URL has to be protected and not shared.<\/li>\n<\/ul>\n<p>A decade ago we would write these by hand but today there is an easy wizard for webintelligence (webi) documents.\u00a0 We will cover how to read the code generated to help understand and troubleshoot.<\/p>\n<p>You can link to many viewable object types with the OpenDocument syntax. in the SAP tool set:<\/p>\n<ul>\n<li>Crystal reports<\/li>\n<li>Web Intelligence documents<\/li>\n<li>Analysis workspaces<\/li>\n<li>BI launch pad workspaces<\/li>\n<li>Dashboards objects (formerly Xcelsius)<\/li>\n<\/ul>\n<h1>2 Basics of the SAP Businessobjects openDocument call.\u00a0<\/h1>\n<ol>\n<li><strong>The remote report has to <a href=\"http:\/\/www.designandexecute.com\/designs\/how-to-use-business-objects-prompt-variable-to-build-flexible-universes-and-webintelligence-webi-reports\/\">have the prompts set up<\/a><\/strong> to receive and process incoming calls from declarative opendocument url calls.<\/li>\n<li><strong>The calling hyperlink, report or program has to set up the url<\/strong> and set the values for the prompts<\/li>\n<\/ol>\n<p>There is basic some scaffolding that belong to each link.\u00a0 Here is the basic link and there is only a handful of parameters you need to know and replace here in <em>italics.\u00a0 <\/em>The bold are the 2 parameters passed to the URL as indicated by the &#8220;?&#8221; for the first one and &#8220;&amp;&#8221; for all following parameters.<\/p>\n<h1>Parameters for Web Intelligence opendocument<\/h1>\n<p>&amp;lsS &#8211; single value variables<br \/>&amp;lsM &#8211; multiple value variables<br \/>&amp;lsR &#8211; interval variables<\/p>\n<p>&amp;NAII &#8211; Indicates whether to force the display of the prompt selection page<\/p>\n<p>http:\/\/&lt;servername&gt;:&lt;port&gt;\/BOE\/OpenDocument\/opendoc\/openDocument.jsp?<strong>iDocID<\/strong>=<em>Aa6GrrM79cStephenGoadKI<\/em>&amp;<strong>sIDType<\/strong>=CUID<\/p>\n<p><em><strong>Note<\/strong> <\/em>while you can search by docName, it is not guaranteed to be unique and it not a best practice.\u00a0 It is better to search for the document by the CUID (cluster id) and iDocID (document id)<\/p>\n<p>While there are many parameters for this OpenDocument syntax, we will show you the main stay that manages 80% of the work load.\u00a0 I would typically use this to call webi reports from any of the ways mentioned in the benefits above.<\/p>\n<p>http:\/\/&lt;server&gt;:&lt;port&gt;\/BOE\/OpenDocument\/opendoc\/openDocument.jsp?&lt;doc identifier&gt;<strong>&amp;ls[S\/M\/R][Prompt identifier]=&amp;lsI[Prompt identifier]=[key]<\/strong><\/p>\n<h2>Single Prompt, forced refresh, one parameter is not set and one is not set<\/h2>\n<p>This example assumes there are two prompts in the Web Intelligence document: Year and Country. NAII=Y forces the Prompts dialog box to appear and allows the user to specify a value for the Country prompt. The Year prompt is already set to a value of FY1999 in the URL using the lsS parameter and therefore is not prompted for<\/p>\n<p>http:\/\/&lt;servername&gt;:&lt;port&gt;\/BOE\/OpenDocument\/opendoc\/openDocument.jsp?iDocID=Aa6GrrM79cRAmaOSMGoadKI&#038;sIDType=CUID&#038;lsSYear=FY1999&#038;NAII=Y&#038;sRefresh=Y<\/p>\n<h2>Multiple Prompt, forced refresh<\/h2>\n<p>eg type is webi report and variable is selected, lsM&lt;VAR&gt;=? and sRefresh=Y.<\/p>\n<p>In this example, the Prompts dialog box appears, and multiple permissable values may be selected to narrow down what will be displayed:<\/p>\n<p>http:\/\/&lt;servername&gt;:&lt;port&gt;\/BOE\/OpenDocument\/opendoc\/openDocument.jsp?iDocID=Aa6GrrM79cRAmaOSMGoadKI&amp;sIDType=CUID<strong>&amp;sType=wid<\/strong>&amp;sRefresh=Y&amp;lsMVAR_AUTH_MULT=GB;DE<\/p>\n<h1>2 Important Caveats<\/h1>\n<ol>\n<li>All of the OpenDocument parameters and parameter values are case sensitive.<\/li>\n<li>OpenDocument may add characters to your URL when it redirects to the requested document; however, encoded URLs cannot exceed the maximum character limit for the supported browsers. For example, certain versions of Internet Explorer limit the URL length to 2083 characters. Therefore, know the browser character limit to ensure your URL will be within the maximum limit<\/li>\n<\/ol>\n<h1>Bonus Tip for linking directly to a Section Part of a webIntelligence Document<\/h1>\n<p>http:\/\/bi4hm:8080\/BOE\/OpenDocument\/opendoc\/openDocument.jsp?sIDType=CUID&amp;iDocID=AQtkbbSqN4NOj3ydf.Sw1lY<strong>&amp;mode=part&amp;sReportPart=<\/strong>UIREF:RID=3:BID=13<\/p>\n<p>Details for more parameters and report types: <a href=\"https:\/\/help.sap.com\/doc\/businessobject_product_guides_sbo41_en_sbo41_opendocument_en_pdf\/4.1\/en-US\/sbo41_opendocument_en.pdf\">SAP guide<\/a><\/p>\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Benefits of using BusinessObjects opendocument URL The very reason you searched and found this article means you ready know the power of this technology or have heard of it. Here are some of the ways the opendocument can impress you managers and deliver more business value to your organization. Use it in Share point or [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":7260,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[32,30,31],"tags":[],"class_list":["post-7253","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-dashboards-analytics","category-bi-business-objects","category-bi-data-warehouse"],"jetpack_featured_media_url":"https:\/\/www.designandexecute.com\/designs\/wp-content\/uploads\/2020\/03\/webi-prompts.png","_links":{"self":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7253","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/comments?post=7253"}],"version-history":[{"count":5,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7253\/revisions"}],"predecessor-version":[{"id":7267,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/posts\/7253\/revisions\/7267"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media\/7260"}],"wp:attachment":[{"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/media?parent=7253"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/categories?post=7253"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.designandexecute.com\/designs\/wp-json\/wp\/v2\/tags?post=7253"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}