*Background </p><p>I've been involved in building a custom portal for client to display BI reports on portal. We were using SAP EP 7.0 and BI 7.1. The use of portal was the display the data in BI 7.1. in the form of reports to the end users who where given the privilege to navigate and search for the particular report. To fetch the proper data the end user had to provide the Fiscal year / Period / Original Acquisition year as mandatory parameter in all iviews and the Area / Profit Center / Region in some in the initial variable entry screen. The variable entry screen is generated directly from BI and there is no specific configuration in portal iviews for it. The issue here was this variable entry screen was not getting displayed in the BEx Web Application iview when a mandatory value was set for the variables in BI.</p><p> </p><p>Approach</p><p>The process for creating the iviews was not at all complicated. All I had to do is create a logical system for the BI server in portal and create a BEx Web Application iview for BI 7.1. using the template provided with EP 2004s and provide the proper query string as parameter.</p><p>The process for creating BEx Web Application iview for BI 7.1. is as follows. For more details on creating iviews please refer to http://help.sap.com/saphelp_nw04s/helpdata/en/f5/eb51590e6a11d7b84900047582c9f7/frameset.htm (http://help.sap.com/saphelp_nw04s/helpdata/en/f5/eb51590e6a11d7b84900047582c9f7/frameset.htm)</p><p>Logon to the portal and go to Content Administration -> Portal Content -> Portal Content folder -> Right click -> New -> iView. In the iview template screen select the type as BEx Web Application iView (SAP NetWeaver 7.0 format). In the step 4 of the iview creation wizard, it requires the value for the Query string. </p><p> </p><p>!https://weblogs.sdn.sap.com/weblogs/images/251846458/step4.JPG|height=412|alt=image|width=649|src=ht...! </p><p> </p><p>For details on BEx Web Application iview please refer to the SAP Help documentation using the link http://help.sap.com/saphelp_nw04s/helpdata/en/33/39fa40ee14f26fe10000000a1550b0/frameset.htm (http://help.sap.com/saphelp_nw04s/helpdata/en/33/39fa40ee14f26fe10000000a1550b0/frameset.htm)</p><p>As mentioned in the document the field BEx Web Application Query String must contain the following values for BEx Web applications, BW queries and BW bookmarks:</p> <table border="1" cellspacing="0" cellpadding="0"><tbody><tr><td width="144" valign="top"><p>BI Object</p></td><td width="374" valign="top"><p>Value</p></td></tr><tr><td width="144" valign="top"><p>[Web Template | http://help.sap.com/saphelp_nw04s/helpdata/en/2a/2da2394fbf4e6ae10000000a11402f/content.htm]</p></td><td width="374" valign="top"><p>template=<TEMPLATE></p></td></tr><tr><td width="144" valign="top"><p>[Query | http://help.sap.com/saphelp_nw04s/helpdata/en/46/0278c96fd33d54e10000000a155369/content.htm]</p></td><td width="374" valign="top"><p>query=<QUERY></p></td></tr><tr><td width="144" valign="top"><p>[Query View | http://help.sap.com/saphelp_nw04s/helpdata/en/46/0294bc82f37041e10000000a155369/content.htm]</p></td><td width="374" valign="top"><p>initial_state=VIEW&initial_state-view=<VIEW></p></td></tr><tr><td width="144" valign="top"><p>[InfoProvider | http://help.sap.com/saphelp_nw04s/helpdata/en/4d/c3cd3a9ac2cc6ce10000000a114084/frameset.htm]</p></td><td width="374" valign="top"><p>initial_state=INFOPROVIDER&initial_state-infoprovider=<INFOPROVIDER></p></td></tr><tr><td width="144" valign="top"><p>[Bookmark | http://help.sap.com/saphelp_nw04s/helpdata/en/43/7050769c407100e10000000a1553f7/content.htm]</p></td><td width="374" valign="top"><p>bookmark=<BOOKMARK_GUID></p></td></tr><tr><td width="144" valign="top"><p>[Report | http://help.sap.com/saphelp_nw04s/helpdata/en/dd/cea14119eb9f09e10000000a155106/content.htm]</p></td><td width="374" valign="top"><p>report=<REPORT></p></td></tr></tbody></table><p> </p><p>There was no parameter mentioned specifically that should be added to the Query string to get the variable entry window. I tried with all of them one by one but none of them showed the variable entry screen. Instead it directly showed the report taking into consideration the default value of the Fiscal year / Period / Original Acquisition year variable .</p><p> </p><p>Solution*
Since the variable screen was generated automatically there was no specific setting for this in portal. The solution to this was found in the BEx Web Application Designer. When I executed the template using BEx Web Application Designer (WAD) I found that the string in the address bar of the executed page contained a fully qualified query string.
!https://weblogs.sdn.sap.com/weblogs/images/251846458/WADscreen1.JPG|height=243|alt=image|width=698|s...!</body>
