Enabling Contain Patterns/Wildcards in prompt of Analysis for Excel

[Former Member]

Enabling Contain Patterns/Wildcards in prompt of BO Analysis for Excel

Applies to

Development and support based on SAP BW 7.0 and  Analysis for Excel 1.4.5

Summary

This document provides step by step guide on Enabling Contain Patterns/Wildcards in prompt of BO Analysis for Excel.

Author: Lakdawala Ashish

Created on: 16th June 2014

Version: 1.0

Key Concept

Selection Option variables allow to enter Contain Pattern operator in prompt to include values such as "XYZ*" to refer to members that start with XYZ. BO analysis for Excel standard solution doesn’t support this functionality due to performance issue. As users are familiar with this functionality in web analyzer and BEx analyzer, users facing problem in Analysis due to non-availability of this option. For making more user friendly analysis tool, SAP Released Note 1920589 which help you to enable the contain Patterns/Wildcards in Prompt of BO Analysis for Excel.

Business Scenario

As shown in below pic, for selection option variable user cannot enter wildcards/contain patterns as Contain pattern(CP) option is not available in options.

This document provides step by step guide on Enabling Contain Patterns/Wildcards in prompt of BO Analysis for Excel.

Solution

To activate this feature, set the registry key SAP(in LOCAL_MACHINE) ->AdvancedAnalysis -> Settings -> Variable -> ContainsPattern to true. The operators in the prompt screen will be enhanced by "CP" and "!CP", where user can use the asterisk * for an arbitrary set of characters.

Step 1. Go to Run and enter regedit.

Step 2. Find AdvancedAnalysis under the SAP (in LOCAL_MACHINE)

Step 3. Create New Key under the Settings Key with the name of ‘Variable’ and create new string value there with name of ‘ContainsPattern’

Step 4. Set the Value of ContainsPattern to ‘true’.

Step 5. Re-open the analysis of Excel. Now “CP” and “!CP” options will be available for selection option variables. Here user can use wildcards in prompt variables.

Note: - If Characteristic is alpha enable then user have to consider the alpha input values. Ex. In case of GL Account, if user want to search 5* (where 5* = 0050000000 to 0059999999) then has to enter 005*.

Create Reg file for this setting and share with the user. So just by click, user can enable the Contain Patterns functionality.

Appendix

1920589 - "Contains Pattern"/Wildcards in Prompt