Save prompt values – The underexposed but very helpful, new features in BI4.1
Today, in our continuing series of new functionality that may not share the spotlight with others; I would like to highlight the recently added ability to save or not save, prompt values with the A-OLAP workspace.
SAP BusinessObjects Analysis edition, for OLAP was originally designed with the user experience as a top priority. And, one of those design choices was to save prompt values with the workspace, in order to allow the workspace user to re-open the workspace without reentering those prompt values. This works great as planned for most users. However, when the prompt values are user specific such as in case of BW authorization values or customer exit values another option was preferred, which was based on feedback from Analysis users.
Upon opening a workspace, the prompt values in the dialog were populated with the values entered by the workspace’s author.
New (BI4.1 and 4.0 SP06)
In BI4.1 a workspace author can chose to save or not save the prompt values with the workspace. If they uncheck the checkbox, the author’s values will not be saved with the workspace and instead, the default values, BW authorization values or customer exit values will populate the dialog.
The following images, illustrate the new behavior, when a default value is defined.As you can see, In this first image, a default value (3006) has been specified in the BEx Query Designer and populates the prompt dialog’s value field.
In the next image, the author of the workspace has changed the prompt value (to 7770) but they have also unchecked the “Save prompt values with workspace” check-box.
As a result, when the workspace is re-opened, the dialog is populated with the default value from the Query Designer (3006) and not the author specified value.
Look out for other posts showcasing what’s new in Analysis edition for OLAP over the coming days leading up to Sapphire.