Skip to Content
Author's profile photo Gowda Timma Ramu

Enhancement to SAP BW integration in BI 4.1 SP05

SAP BusinessObjects Web Intelligence and Crystal Report for Enterprise now supports (from BI 4.1 SP05) manual entry of values for variables.

With this enhancements the end users now would be able to simply type in a values in the text box for manual entry instead of selecting each values from List of Values.

Note: Manual entry would be enabled on Web Intelligence and Crystal Reports for Enterprise clients only when the BEX Query variable is created with “Manual Entry/Default value” processing type in BEX Query designer

Bex Query Parameter.png

Upon updating your environment to BI 4.1 SP05, Manual entry of values would be supported on following variable types.

  • Single value variable
  • Multi single value variable
  • Interval (range) value variable
  • Single keydate variable
  • Formula variable
  • Selection Option variable

By default, selection option variables are mapped to a range. In order to use this feature, selection option variables has to be mapped to a multi-value prompt, for which you would have to run the following command depending on the client.

Note: Manual entry support will be enabled for other listed variables types by default with BI 4.1 SP05

For Webi:

  • Webi Rich Client: Run Registry Editor and Add the entry “” in the following registry key and restart the client

       registry path.png

  • Webi Java and DHTML Viewer: Launch CMC -> Servers -> WebI Adaptive Processing Server ->Properties -> in command line parameters add the entry “”

For CR:

  • CR4E: In the config file, add the entry “” and restart the client

        Config file is located at “[Install_Dir]\Crystal Reports for Enterprise XI 4.0\configuration\config.ini”

  • CR Viewer: Launch CMC -> Servers -> Crystal Reports Processing Server ->Properties -> Java child VM arguments add the entry  “”

With Manual entry of values you can make use of expressions and patterns to reduce the number of values to be filled and speed up the selection process depending on the requirement, following are couple of examples.

  • Single member: 1
  • Interval: 1 – 5 (do include the spaces)
  • Expressions with operators: >4 , >=4 , <4 , <=4
  • Exclusions: !5 (any key but 5)
  • Combinations: 1 – 10 ; !5 (all the keys from 1 to 10 except 5)
  • Patterns: *1 : all keys that end in 1 (for ex. 01, 11, 21) and *1* : all keys that include 1 (for ex. 01, 10, 11, 12, 13, 21)

Webi runtime.png

The support for manual entry of values does not have any impact on the existing capability to select values from List of Values, users can still continue to make use of list of values for providing values for prompts.

With this enhancement, following is the consolidated list of clients supporting manual entry of values for variables.


  • Web Intelligence
  • Crystal Report for Enterprise

    Dashboarding & Apps:

  • Design Studio

    Agile Visualization:

  • Lumira Desktop
  • Analysis, edition for Microsoft Office
  • Analysis, edition for OLAP
  • Explorer

Refer to SAP Note 1869560 for detailed SAP Integration support matrix for BI on BW.

Assigned Tags

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

      I just attempted this on SP6 patch 2.  and it appears to not be working, i've submitted a ticket.  Has anyone else experienced this as well?

      Author's profile photo Everhart Chris
      Everhart Chris

      I'm experiencing the same issue with SP6 pl3.  It doesn't work in the Rich Client, nor HTMLD, nor Java.

      Author's profile photo Everhart Chris
      Everhart Chris

      See the thread below.  It looks like places to maintain settings have changed with the release of SP6.  Saral Jain provided easy instructions to resolve.

      BEx Selection Options settings not working in 4.1 SP6 PL3