Parameters (and Variables) defined in both SAP HANA and SAP BW data sources are presented to users when they open up Calculated Views or InfoCubes. Parameters in both technologies are set before the main analytical queries are executed and can drive a variety of logic and functionality ranging from security and filtering to logic configuration and display.
The parameter dialog presents parameters as they have been defined in the underlying data source. Pyramid reflects each parameter type, its settings and options exactly as configured in either BW or HANA. The effect of each parameter is unknown to Pyramid, and is passed on to the SAP system for its own internal execution requirements.
When a data model that contains parameter configurations is opened (from any relevant app), the Model Parameter dialog (as shown below) is automatically presented to users.
This dialog can also be subsequently opened by clicking Predefined Parameters from the Report ribbon in Discover afterward to change any settings made (yellow box below).
The Parameter Dialog is similar for both BW and HANA. The first image below id for a BW example, the second is for a HANA example. Apart from common UI elements (like drop downs, text boxes, multiple selections, multiple parameter settings) the dialog has these settings in common for both data source types:
- Parameter refresh (purple arrow below): reloads all parameter values and default settings
- Restore Defaults (yellow arrow below): restores all changed parameter prompts to their original default values. This can also be done for each prompt, using each prompt's menu (see below).
- Required Flag (red arrows below): indicates which prompts are mandatory. The flag is shown as a yellow star next to each prompt. The user will not be able to continue until all these items have been selected.
- Saving Parameter Choices (blue arrows below): allows the user to decide if and how to save their choices for the parameters for the future. See below for more.
BW dialog example
HANA dialog example
The type of prompts available will depend on the type of parameters that have been defined and configured in the data source.
- For instance, in the BW dialog above, the first parameter is a listing of years, while the second is a Product listing from the product category hierarchy, consisting of Bikes, Clothing, Accessories, and Components.
- In the HANA dialog, the first prompt is a text box asking for a cut off date. A default value has prepopulated this box for the user. The second is another text box requiring discount percentage.
The other unusual prompt variations are shown below.
Users may be presented with a From-To prompt, where they need to pick a starting and ending value (or element).
Another From-To prompt type is show below, where users are asked to first pick a comparison operator (teal arrow), and then make subsequent selections in the from-to drop downs based on the operator choice. If enabled, they may also be presented with the option to add more than one such condition (blue plus).
Multi-set prompts allow the user to add more than one prompt selection using the blue plus (orange box below). Users can also delete these options using the delete button (purple box below).
If the prompt is date time in BW, the user may be presented with a calendar picker instead of a simple drop down (red box below). This can be changed back to a classic drop down in the options menu (see below).
Other Parameter Options
Depending on the parameter type (and data source), clicking on the prompt's menu (red circle below) will allow the user to change the settings for the parameter.
- Use Default Value: instead of supplying a specific value for the parameter, the user forces the system to get the latest default value and use it instead. This only works if there is a default value. if blank values are submitted, it may produce errors instead.
- Technical names (BW only): this switches the parameter caption to its technical version
- Parameter Source (BW only): this allows the user to switch engine provides the parameter's values
- Change to drop down (BW only): ths allows users to switch the calender view for date-tiome parameters to a simple drop down.
- Restore Defaults: resets the parameter to its original settings.
Pyramid makes re-using both SAP BW and HANA parameters easy by allowing users to save their prompt settings both for themselves and for others (if designing content for other users).
These options are provided when the parameter dialog is opened for each user. These settings are effectively "model" level and not specific to any given report.
- Apply Now Only: The settings made you choose are used once only for the current exercise. They are not saved for the next time the parameter dialog is opened.
- Keep for Session: your selections will be saved for the current user for 24 hours when accessing the given view or 'model'. After 24 hours you will be prompted to define re-choose parameter selections.
- Keep for Future: your selections will be saved and will always appear in the parameters dialog whenever the report or model is opened.
These options are saved into the content item (Discover report). They are most relevant when making setting choices for yourself or others who may open this same content. These settings are effectively "report" specific.
- Set for this Report - for all Users: your selections will be saved for all users who access the report. When any and all users open the saved report, they will not be prompted to input SAP Parameter values.
- Set for this Report - for each User: your selections will be saved for yourself. When you open the saved report in the future you won't be prompted to input SAP Parameter values. However, any other user will prompted to define their own Parameters inputs when opening the report.