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.
As of SAP Design Studio 1.3, SAP provides options to customize the values of a few RSADMIN parameters, at the SAP BusinessObjects level. This is done at the SAP BusinessObjects 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 BusinessObjects 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 SAP Design Studio.
Right click on the SAP 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 SAP Design Studio requests.
Once this is complete, SAP Design Studio applications will show custom values configured in APS servers, when executed in platform mode.
Similarly, for Mixed Units
Happy Learning !
Read more blogs from SAP BusinessObjects Design Studio category here.