BEx Selection Options settings not working in 4.1 SP6 PL3

[former_member190952]

This past week, we upgraded our Sandbox system to BIP 4.1 SP6 PL3.  I was looking forward to testing the new features that allow manual entry and improved options for BEx variable prompts that employ SELECT-OPTIONS.  Unfortunately, the multiple value selection for select-options doesn't seem to be working either in the WebI Rich Client or the HTMLD and Java applications.

I have followed steps in the blog pages below and set “–Dsap.sl.bics.variableComplexSelectionMapping=multivalue” both in my registry for the Rich Client and also in the command-line parameters for the APS servers on our BIP, but my testing scenario continues to show an interval rather than multiple value selection as expected.  I have even purged the document and tried creating a new document with no difference.

Clearly I'm either missing a step, or this feature is not working in the current patch level.  Has anyone else had the same experience and found a resolution?

REFERENCES

http://service.sap.com/sap/support/notes/2143472

[Former Member · Accepted solution]

Hi Chris,

This is caused by new DSL-BICS configuration mechanism with properties file
which is taking precendence over command line arguments specified in server
properties.

From BI 4.1 SP 06 onwards, below two files are automatically generated by a
running DSL:

1. DSLBICSConfiguration.xml - This file contains all available
   options and their default values. This file should not be
   modified.
2. DSLBICSConfiguration_custom.xml - This file contains all
   options with end-user specified values.

These files will be located in the disk directory from where the DSL proccess

loads the DSL Java libraries. For the BI Platform Adaptive Processing
Server and the Web Intelligence Rich Client interface,

it will be by default at:

<INSTALLATION_ROOT>/SAP BusinessObjects
Enterprise XI 4.0/java/lib/

Alternatively, a file may be explicitly identified
via command-line option for the DSL:

-Dcom.sap.sl.BICSConfigurationFile=C:\myDSLBICSConfiguration.xml

and custom options should be configured in that file.

Resolution

1. Navigate to the file DSLBICSConfiguration_custom.xml.
2. Edit the file and change the following entry key:
   
   < entry
   key="variableComplexSelectionMapping">interval</entry>
   To
   <
   entry key="variableComplexSelectionMapping">multivalue</entry>
3. Restart the APS containing DSL bridge service for the changes to take
   effect.

Note: These solution steps applies to both Webi Rich client as well as BI
Launchpad.

Regards,

Saral Jain

[former_member190952 · Accepted solution]

Saral, thanks for your very quick response and clear resolution instructions.  Issue resolved!

[Former Member · Accepted solution]

Hi Chris,

Glad it resolved the issue.

This change in the behavior should soon be documented in the SAP Knowledge base article which you can refer in future.

Regards,

Saral Jain

[former_member190952 · Accepted solution]

Hi Saral,

One last question, and feel free to point me to documentation if it's out there.  When testing the multivalue behavior, I found that select-options on dates didn't work as expected.  I'm not able to enter a date interval (1/1/2015 - 3/31/2015) like I expected.  It simply won't accept that type of input, although it works fine with the string characteristics.

I looked at note 2143472, which seems to address something similar, but indicates that it's fixed on SP6, PL0.  But I'm already on PL3.  Any ideas on this?

Best regards,

Chris