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
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.
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 |