In a BW system, the RSADMIN table is used as a configuration table for many processes and functionalities. This table has parameters that define some system configurations, behavior and display of result sets. For instance, when there is division by zero in a BEx Query, the result is displayed as the symbol ‘X’. This symbol is defined in the RSADMIN table. Similarly, RSADMIN parameters define many other options, like the max no of cells in a result set, message to display for lack of authorization etc.
BEx Output – DIV by zero shown as ‘X’
As of Design Studio 1.3, SAP provides options to customize the values of a few RSADMIN parameters, at the Business Objects level. This is done at the Business Objects layer through “Analysis Application Service” APS parameters. Customizing RSADMIN parameters can help developers and end users by displaying more meaningful text in case of errors in calculation, units or authorizations.
Steps to edit RSADMIN parameters
Login to “SAP Business Objects CMC” with an account that has administrator rights.
Select the “Servers” option under “Organize”.
Select “Servers List” to view all the APS servers in the system.
Select the APS server that hosts the “Analysis Application Service” (or) the one that is configured for Design Studio.
Right click on the Design Studio APS and select “Properties”.
In “Properties”, search for “Analysis Application Service” and update each RSADMIN value as required.
Click on “Save and Close” to complete the configuration. Update this across all APS servers configured to process Design Studio requests.
Once this is complete, Design Studio applications will show custom values configured in APS servers, when executed in platform mode.
Design Time Vs Run Time views of DIV by zero
Similarly, for Mixed Units
Design Time Vs Run Time views of Mixed Units
Happy Learning !