One of important
customizing tables in BW is table RSADMINC.
The customizing of this table takes place when the BW system is setup for first
time. But also during time when the system is operational some parameters need
to be maintained. Also entries need to be adjusted in case of BW upgrade.
The table stores basic
customizing parameters of the BW system. Depending on installation scenario of
the BW system values of parameters are either populated automatically (so
called Wizard-Based Basic Configuration for BW ABAP) or if it is not the case than
then it is possible to perform all steps manually.
In general you can find a
documentation of the table params here. On
that page all params that are really needed for BW to function properly are
listed. Also there on the page are listed corresponding t-codes where respective
params are maintained.
General
parameter
CUSTOMIZID ID
for Customizing in BW. For the BW system a value of this param is always BW.
Note: 1576461 -
Unable to open any Web Application from BI Launchpad
Data
Warehousing Workbench related parameters
RSAWBN_HIDE_FUNC Hide
obsolete Functions of the Data Warehousing Workbench
PROTAWBSTART Write
Log to Application Log when DWB Starts
COL_WARNING Traffic
Light Color in Monitor if Warnings Occurred
Query
processing related parameters
SPLT_QRY_TAB_THR Threshold
Value for Query Split, Note: 514907 - Processing
complex queries (data mart, and so on)
SPLT_DM_TAB_THR Threshold
for Splitting Data Mart Requests
Analysis
Process related parameters
ANPR_SERV Application
Server for Batch Execution of Analysis Processes
ANPR_SERVTYPE Type of Server
Any
DB specific related parameters
DB_STATISTICS Let
BW Generate Database Statistics
Oracle
specific related parameters
ORA_LOGGING Deactivates
NOLOGGING while Building Index
ORA_PARALLEL_DEG Degree
of Parallelization during Aggregate and Index Building, Note: 544521 - Controlling
the PARALLEL degree
Upload
related parameters
INFOIDOCFRQ Frequency
with which status IDocs are sent
IDOCPACKSIZE Number
of Data Records per Package
MONITIMEOUT Waiting
time until traffic light status is changed in the monitor
MDMTBOOKMODE Update
method in master data maintenance
DB
Connect source system upload related parameters
DBC_BWSERVER BW Application
Server (as of 6.10) settings for DB Connect customizing settings, Note: 930353 - DB Connect
customizing settings
DBC_PACKSIZE Number
of Data Records per Package for DB Connect
DBC_SHOWSIZE Number
of Data Records with Display Mode
SID
generation related parameters
AUTOSID Automatic MD ID entry when
loading transaction data
RRSITHRESHOLD Threshold Value: Select Single ->
Select for All Entries, Note: 1522691 -
Performance Optimization: SID Flag Updates
Flat
file format related parameters
EXCEL_ESC Field Delimiter for CSV Files
EXCEL_FIELDSEP Field separator for csv files
Authorization
related parameters
USE_NEW_REPAUTH Analysis
Authorization System, Value NEW means current procedure with analysis
authorizations. Note: 1369820
- Analysis authorizations: Select concept
MPRO_CHECK Use
MultiProvider Authorization Object (S_RS_MPRO)
MPRO_CHECK_QUERY Use
MultiProvider Authorization Object in Query
CUBE_CHECK_QUERY Use
Authorization Object InfoCube (Query)
“Display
of Numeric Values in the Business Explorer” related parameters
RRXDATADIFF0 Display value for dividing by zero
RRXDATANOTEXIST Display
value for cells with error
RRXDATALARGE Display value for numeric overflow
RRXDATANOAUTHOR Display
value for cells without authorization
Currency
display/conversion related parameters
CURR_CONV Currency
Conversion for External Systems
RRXDATAMIXCUR Display
value from various currencies/units or mixed values
RRXSHOWMIXCURVAL Display
value of a cell with mixed currency
TCURF_FAKT Indicator:
Consider TCURF Ratios in Currency Conversion, Note 531983 - TCURF
factors ignored during currency translation
Quantity
conversion related parameters
UOM_BUFF_SIZE Quantity Conversion: Setting Buffer
Size Internal Tables
Hierarchies
related parameters
MERGE_APPL Hierarchies:
Merge with applications, yes/no
MERGE_AREA Hierarchies:
Merge with InfoArea, yes/no
MERGE_IPG Hierarchies:
Merge with IPG, yes/no
HIER_ISRCMD Hierarchies:
Use Authorization Object S_RS_ISRCM
PSA
related parameters
PSAPARTSIZE Size
of PSA Partition. In case if the highest existing partition has more records
than this param specifies new partition is created. Note 771191 -
Copying BW objects to new tablespaces
PSA_REQUDEL Check
for Activity 06 during PSA Request Deletion
Attribute
Change Run (ATR) related parameters
DELTALIMIT Threshold Value (0-99): Delta
-> Reconstruct Aggregates, Value 0 means that all the aggregates are always
reconstructed (this normally has a negative impact on performance). It is
recommended that you start with a value of approximately 20%. Note: 903886 -
Hierarchy and attribute change run
BLOCKSIZE Block Size for Building
Aggregate. Size of block for ATR. If E or F table of aggregate is larger than
this parameter, system does not read the source in one go, rather it divides it
into blocks. The division into blocks is based on a characteristic, the value
range of which is divided into intervals. The system only reads the data from
such an interval from the source and writes it to the aggregate. If there is no
value of the param default value is 100,000,000 valid for ORACLE. Notes: 903886 -
Hierarchy and attribute change run; 646402 -
Programs for checking aggregates (as of BW 3.0B SP15)
CR_MAXWAIT Wait
Time for Change Run Lock (in Minutes), Note: 825927 - The BW
Changerun: CR_MAXWAIT
LOCKCR Reporting
Lock on Change Run. I case of huge volume of data while master data IO
activation a DB commit is executed between DELETE and UPDATE operation on data
if this param is set to X. This ensures that it doesn’t dump. Note: 1694993 - Consulting:
Transactional logs filled during MD activation
BW
Web environment related parameters
STYLE_SHEET Style
Sheet for Html Page Generation
TMPLID Name
of the Web Template for Ad Hoc Analysis (SAP BW 3.x)
PROPERTIESID Name
of Standard Template Properties (SAP BW 3.x)
ITS ITS
Name for URLs Created by Server for BW Web Reporting; Obsolete in 3.x and 7.x.
WEBSERVICE ITS
Service for BW Web Reporting URLs created by the server; Obsolete in 3.x and
7.x.
WBID Workbook
ID for the Standard Web Page; Obsolete in 3.x and 7.x.
PAGEID Page
Name of the Standard BW Web Template; Obsolete in 3.x and 7.x.
For an overview of web reporting related params see
Note: 589947 -
Relevant Customizing entries in RSADMINC in Web environment
Web
templates related parameters
RSER_TMPL_ID Standard
Template for Enterprise Reporting, Note: 1576461 - Unable to
open any Web Application from BI Launchpad
TMPLID_BROADCAST Standard
Web Template for Broadcasting (BW 3.5), Note: 666214 - Enhancement
RSADMINC - 'Standard Web Template'
TMPLID_QUERY_BR Standard
Web Template for Query Precalculation (BW 3.5)
TMPLID_DOCUMENTS Standard
Web Template for Document Browser (SAP BW 3.x)
TMPLID_BCAST Standard
Web Template for Broadcasting
TMPLID_BCAST_QUE Standard
Web Template for Query Precalculation
TMPLID_ANALYZER Name
of the Template for Ad Hoc Analysis
TMPLID_BCAST70 Standard
Web Template for Broadcaster
TMPLID_BCAST_Q70 Standard
Web Template for Query Precalculation
TMPLID_BCAST_REP Standard
Web Template for Report Precalculation
TEMPL_PARAM Name
of Standard Template Settings
Broadcasts
related parameters
BCAST_SUPP_FOOT Broadcasting:
Suppress Footer in E-mail
BCAST_MAIL_EXP Number
of Days Until Send Requests Are Deleted
OLAP:
Cache related parameters
INACTIVE Cross-transactional
cache is deactivated
MAX_LCS_MB Local
Cache Size
MAX_GCS_MB Global
Cache Size
PERSISTMODE Cache
Persistence Mode
FILENAME Flat
File Name
FILENAME_SPAN Comprehensive Flat File Name for
AppServer
LIMIT Database
Cache Limit
CLUSTER_LIMIT Size
Limit for Clustering
HANA
related parameters
RS2HANA_PACKAGE SAP
HANA Content Package for HANA Views
RS2HANA_ASSIGN_TYPE Privileges
assignment type
RS2HANA_DBMS_USER_MAPPING SAP BW user to SAP HANA user mapping option
Other
parameters
Most of these parameters is not used any more in modern
BW systems (7.x + versions).
SRCSYST_USER User in source system for ALE
communication
COL_NODATA Traffic-light color in monitor if no
data in source system
CHAR1000 Thousand separator
DECIMALCHAR Character for decimal point
GANTT_MIN_LENGTH Length
of horizontal bar in Gantt chart
MSGPOPUP Message Long Text As Dialog Box
MONITORASSI Indicator
for standard default starting of the wizard
SRVNAME Data
element for MD server name
RFCOLAPDEST RSDP:
data tp encapsulating RFC destination to work with
MSASEXIST RSDP:
Data element for storing info if MS AS2000 can be used
TECHNAME RSDP:
Data element for technical names
LOCALBORURL Drag
& Relate (D&R) Links for BW Unifier
WP3DEST Destination
of URL Generation Server
WEBPROTOCOL Web
Protocol for BW Web Reporting URLs Created by Server, Note: 961142 - HTTP or
HTTPS protocol when you jump to a 6.40 system
ISETHUGEWHERE InfoSet: Limit Value for Large Where
Conditions, Note: 673575
- InfoSet: Long running program - SAPSQL_STMNT_TOO_LARGE
EP50_MENU Hide
Menu 'Publish to Enterprise Portal 5.0'
MHTML_AS_ATTACH Send
MHTML Documents by E-Mail As Attachments
ER_STYLESHEET Stylesheet
for Exception Reporting (Path in MIME Repository)
SOBI_RFC_DEST RFC Destination for BW Model
Generation
ASYNCHR_DELETION Asynchronous
Deletion from Write-Optimized DSOs
Related post:
No comments:
Post a Comment