How to find out InfoArea for particular BW object type – in BW/4 systems?

How to find out InfoArea for particular BW object type – in BW/4 systems?

This blog post is continuation of my earlier blog - How to find out InfoArea for particular BW object type. That blog was focused on classic BW running on anyDB. In advent of BW/4 the tables for the BW objects have changed a little so I’m refurnishing the old blog post in here.

BW obj type	Table	Input field	Field which holds InfoArea’s name
InfoObject	RSDIOBJ	IOBJNM	MTINFOAREA
aDSO	RSOADSO	ADSONM	INFOAREA
Composite Provider	RSOHCPR	HCPRNM	INFOAREA
Open ODS View	RSFBP	FBPNAME	INFOAREA
OpenHub	RSBOHDEST	OHDEST	INFOAREA
DataSource	RSDS	DATASOURCE	APPLNM *
InfoSource	RSKSNEW	ISOURCE	INFOAREA
Data Flow	RSDFDMOD	DATAFLOW	INFOAREA
BW Query components	RSZCOMPDIR	COMPUID COMPID	INFOAREA
HANA Analysis Processes	RSDHAMAP	HAAPNM	INFOAREA *
Planning Sequence	RSPLS_SEQUENCE	SEQNM	INFOAREA *
Process Chain	RSPCCHAINATTR	CHAIN_ID	APPLNM *

 

* Field not populated (not used) in the table

* Instead of InfoArea an Application Component is used

 

More information:

How to find out InfoArea for particular BW object type.

Picture in monitoring/scheduling part of RSA1

There is a possibility of adding a picture to monitoring/scheduling part of t-code RSA1. The picture that can be shown needs to be customized in table RSRADIOMON. The table holds data about user settings related to BW. A field that picture name goes is called - PICNAME (Image name for monitor/scheduler). The picture needs to be stored in table RSMIME. It attributes shall be stored in table RSMIMEATTR. Unfortunately, I cannot find any standard SAP functions to store ne pictures into these tables. However, simple ABAP report that stores any picture into these tables should not be a big thing to develop.

There is a bunch (41 pictures to be precise) of picture already stored in the system. Below I took few screenshots from the pictures available in the systems. I tried BW 74, 75 and BW4 1.0 and 2.0 in all these systems the pictures are all there. 

Moreover, there is other field PICSTRETCH in the table PICNAME that allows stretching the picture over full size of part of the GUI screen.

MONITOR_MED.JPG

WASSERRAD.JPG

SAPBW_MONITOR.JPG

SAPBW_CHAIN.JPG

NETWEAVER_MONITOR.JPG

PICNAME_NETWEAVER_CHAIN.JPG

WATER_MED.JPG

User related settings for tcode RSA1

There are couple of user related settings when it comes to Data Load Monitor function of BW’s Administration Workbench (RSA1). They are stored in table RSRADIOMON. In this post I will discuss what are they about and how to set it. 

Monitor is mostly handled by a report RSMO1_RSM2 and a call of FM RSSM_MON_SHOW_MONITOR_IC_RSM2 (include LRSM2I05, FG RSM2) and FM SELECTOPTIONSDATE. Depending of BW version, the Monitor looks like following:

UNAME                             User for which particular settings is valid for

Below columns are representing customizing of Load Monitor, whether it shall display (possible values either blank or X):

NOW                                Load monitor will show “Today’s” requests only

YESTERDAY                     Load monitor will show ”Yesterday’s and Today’s” requests only

WEEK                               Load monitor will show requests from Past Week (button ”In the Past Week”)

MONAT                             Load monitor will show requests from “This and Last Month”

FREE                                Represents flag: If Active in Time Period (if set means requests will be selected for which the system logged a message in the specified period). Free data range is saved in global memory under ID SELECTOPTIONSDATE, no persistent storage.

Following columns (possible values either blank or X) are representing Request Overview, whether it shall be displayed in format of:

TREE                                Overview Tree

LISTE                               Overview List

DYNPRO                           Planning Table

Following columns are representing visual (look and feel) settings of the Load Monitor:

PICTYPE                          Type of screen on the right side (possible values: 0 = Default; 1 = no; 2 = customer-defined pic)

PICNAME                         Image name for monitor/scheduler

PICSTRETCH                     Whether the picture shall be stretched over the screen (possible values: X or blank)

TREEWIDTH                     Number of pixel for TREE control on the left part of RSA1 (monitor of info packs). Useful to e.g. it in case it is too small and user can’t navigate e.g. can’t be enlarged.

STATSEL                          What statuses of the data load requests shall be filtered in the Load Monitor

RNRSEL                            What Request ID (Request Number) shall be displayed by default

SYSSEL                            What source system shall be selected when user enters Source Systems section

VIEWSEL                         Single-Character Indicator

LIFETIME                         Consider all data monitor entries found (possible values: X or blank)

CHAIN_TREEWIDTH        Number of pixel for TREE control on the left part of RSA1 (monitor and process chain monitor). Useful to e.g. it in case it is too small and user can’t navigate e.g. can’t be enlarged.

CHAIN_ACCESSABLE       Possibility of showing PC tree displayed in Network view. Normally this is not available for SAP GUI for JAVA. If you need to display your PCs in the Network view set this field to Y manually in the table for your user. Possible values: N or Y.

More information:

1991961 - P33; MON; PC: TREE control on left of monitor and PC monitor is too small

Favorites in BW’s RSA1 Modeling section

As of version 7.x BW systems contain a useful function of saving particular BW objects that is maintained via RSA1 into Favorites. This enables faster access to the objects as it doesn’t need to be lookup up the area there it belong as there are thousands of the objects. 

As an example one InfoObject that is normally accessible under InfoObject part of Modeling section of RSA1 can be also accessed via Favorites part of the same Modeling section of the RSA1.

I was curious what the table name is where the objects of the Favorites are actually stored. Whole processing of the Favorites is encapsulated in ABAP class CL_RSAWBN_SER_FAVORITES.  For example method that loads the objects is LOAD_DATA.

There are few tables within this functionality. The table where the objects are stored is SPERS_OBJ - Personalization object repository. But this one is just a form of keys to the objects. The method later retrieves the objects types, its description and so on to be able to present them in the RSA1.

Unfortunately there is no straightforward possibility to easy download/upload a list of objects that one inserted into the Favorites. This is contrary to regular SAP GUI favorites that can be downloaded/uploaded between the systems very easily (See post: Download/ Exporting of user’s favorites SAP GUI). However one easy trick is there to at least a get the type and name of objects but with hierarchical representation (like folders). 

To get the list go to t-codes SU01 or SU01D and navigate to Personalization. Find entry called RS_BI_DWB_FAVORITES - Favorites in the BI Data Warehousing Workbench and double click on it.

 

This will get you a table of all the objects displayed in your Favorites area. The table can be printed to local file and objects can be saved offline by this procedure.