Skip to Content

Hello Everyone,

In my last blog, I mentioned about the supported input formats for selection option BW variable for the newly introduced feature of manually entering BW prompts.

I tested the new feature further in webi rich client and after some effort was able to make it work.

Here is the step by step instruction on how to make this work.

  1. I started testing this feature by first creating a BW Query with a Selection option variable prompt as shown in the screenshot below:

Image 1.PNGImage 2.PNG

2. This is the most important step. Add a registry key for a client machine running webi rich client at the location below:

Image 6.PNG

The Value Name is the next number in sequence. Depending on your configuration, it may be different then what you see below. The Value Data for the key is “–Dsap.sl.bics.variableComplexSelectionMapping=multivalue”.

Image 7.PNG

3. I then created a webi report based off the BW query using Webi rich client. I tried using the input formats as mentioned in the last blog (intervals, Expression with operator and so on).

Image 3.PNG

4.  I added multiple prompt values for Country Key  as shown below:

Image 4.PNG

5. Ran the report and checked the results:

Image 5.PNG

Above dataset in the report shows that data brought back consist of countries with key value 1,2,3,4,6,25 and 33 excluding 5 (as NOT INCLUDING 5 was one of the conditions.)

I hope this is helpful.

Regards,

Ejaz

To report this post you need to login first.

4 Comments

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

    1. Syed Ejaz Shah Post author

      Hi Carlos,

      Thanks for the comment.

      This is a new functionality added in BI 4.1 SP5. Generally, the new functionality is not back ported to older versions.

      If it’s added it will be in the What’s new guide of SPs released for BI 4.0.

      Regards,
      Ejaz

      (0) 
      1. Carlos Weffer

        Thanks for your reply.

        This new functionality is clearly stated in BIP 41 What’s New Doc, section 6.3

        http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41_whats_new_en.pdf

        (Document Version: 4.1 SP5 – 2015-01-09)

        However is not mentioned at all in BIP 40 What’s New Doc.

        http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_whats_new_en.pdf

        (Document Version: 4.0 Support Package 11 – 2015-02-19)

        We are currently in 4.0 SP7.

        Cheers,

        Carlos

        (0) 
        1. Syed Ejaz Shah Post author

          Hi Carlos,

          As mentioned earlier, normally the new functionality is NOT back ported to older versions.

          If it is not listed in What’s New Doc for 4.0 SP releases, it means this is not included in BI 4.0 SPs and is only available for BI 4.1 SP 5 or above.

          Regards,

          Ejaz

          (0) 

Leave a Reply