Symptom
A Planning Sequence is being used in Analysis Office.
When opening the F4 Help in a hierarchy variable under "Variables of Planning Sequence", if the option "Select All" is selected, the variable value remains empty and the following error occurs after clicking "OK":
-------------------------------------------------
Specify a value for variable <NAME OF VARIABLE> (BRAIN-629, <SID>):
Diagnosis
The variable cannot be empty. You must make an entry in the variable maintenance for variable <NAME OF VARIABLE>.
-------------------------------------------------
Environment
SAP BusinessObjects Analysis, edition for Microsoft Office
Reproducing the Issue
- The steps are numbered as per narrows presented in the screen shots.
- Open Analysis Office and go to "Analysis Design" tab;
- Click on "Display" options;
- Choose "Display Design Panel";
- When "Design Panel" opens, select tab "Components";
- Go to the blank part, as per screen shot below, give a right click and select option "Use Planning Sequence";
- Insert your "Planning Sequence" name;
- Select the required "Planning Sequence";
- Click on "Ok";
- Your "Planning Sequence" will come up in your "Design Panel" and you might have to click on "Components" tab again;
- Use F4 Help for one of your members under "Variables of Planning Sequence";
- Tick option "Select All" in the prompt screen;
- Click on "Ok";
There will be an error message on the left side of your screen and when clicking on it, you can see the following error messages related to the variables you have in your "Design Panel":
Cause
The error occurs because selecting all members means no filter for the variable (empty == Select All), and in case of a mandatory variable, the design of the planning sequence requires a filter in the variable.
Resolution
- Go to menu File
- Click on Analysis
- Click on Customize Analysis
- Select Technical Configuration
- Search for option DoSelectorHierarchyExplicitSelection
- Tick this option (it might be unticked)
- Close Analysis Office and open again.
Once you have restarted your Analysis Office, please take the same steps one more time and now the errors should be gone and you should have results from F4 help. Otherwise, in case the issue remains the same or in case this option DoSelectorHierarchyExplicitSelection was already ticked, please contact SAP Support for further guidance.
See Also
Keywords
Planning Sequence, Variables, Specify a value for variable, error message, F4, help, DoSelectorHierarchyExplicitSelection, Select All , KBA , BI-RA-AO-XLA , Excel Addin , Problem