Skip to Content

*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=https://weblogs.sdn.sap.com/weblogs/images/251846458/step4.JPG|border=0! </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|src=https://weblogs.sdn.sap.com/weblogs/images/251846458/WADscreen1.JPG|border=0!</body>

To report this post you need to login first.

6 Comments

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

  1. Ashish Narway
    Thanks for sharing your solution.

    You can also use SELECTION_OPTION=X parameter in the URL, to achieve the same results.

    You can also set the global setting to always “force show” the selection screen by change the “default template” and providing the parameter SELECTION_OPTION=X in there.

    (0) 
  2. Kamaljeet Kharbanda
    Even though you are populating variables values in advance still the template shows variable screen using the default iView query string. I am not sure why it was creating problem for you, but it works for me always.

    The only scenario where it won’t prompt for variable screen is when you have set the web template variable screen property in WAD as ‘ not to show variable screen’. Please check your WAD property, and this should solve your problem.

    (0) 
  3. Ravi Reddy
    If the query does not have a required parameter, by default the template does not show the variable screen.  To display you can add the parameter Seleciton_Option=X as Ashish mentioned or change the Display Variable property in the WAD template to ON from OFF.  This will force the display of Variable screen.
    (0) 
  4. Sai Kumar
    Hi Seema

    I have a question……..How to get the query description in place of “General Variables” word above the variable screen……..because in the previous version we were able to display the query description at that place…….is there any way to get that???

    (0) 

Leave a Reply