Generating Queries issue BW

Due to an issue in one of the latest support packs (in our case SP08), many queries were being generated on each call of an enduser.

This causes major performance issues in reporting in our system. Mainly in generating the variable screen and the (non) usage of cache for these queries.

Wonder if this is happening in your system? Check on table RSRREPDIR and check if the timestamp in field GENTIME is not too recent for your active queries.

Also in the system you will see if you trace the call of the report that tables D010TAB and D010INC are accessed many times.

Implementing note 1528921 helped out on this (Queries regenerated each time during

execution). Please be aware!

Query tables BW

Below tables are relevant with respect to query elements.

RSRREPDIR – Directory of all reports

RSZCOMPDIR – Directory of reporting components

RSZELTDIR – Directory of the reporting component elements

RSZELTTXT – Texts of reporting component elements

RSZELTXREF – Directory of query element references

RSZOPRATXT – Texts of the formula operators

RSZCOMPIC – Assignment reusable component to Info Cube

RSZSELECT – Selection properties of an element

RSZCALC – Definition of a formula element

RSZGLOBV – Global variables in reporting

RSZELTPROP – Element properties (settings)

Analysis on these tables can be done via ANALYZE_RSZ_TABLES program in SE38.

It might be wise to clean up especially in large BW systems to increase performance of generating query elements like variable screen in Bex Web/Analyzer.

Clean old requests from Write-Optimized DSO

In the LSA setup the W/O DSO is often used to replace the function of the PSA table. By keeping all history in the W/O DSO you might encounter serious performance or data volume issues.

With program RSSM_DELETE_WO_DSO_REQUESTS it is possible to delete old requests in the Write-Optimized DSO, exactly like we are used to do with PSA requests via a Process Chain.

This program is available as of SAP NetWeaver BW 7.01 SP07. See note 1437407 for details.

You can automate the deletion of old WO requests by using the ABAP program step in the Process Chain.

Process Chains

Hi all,

Are you getting lost in RSPC when searching between 100+ process chains for the one you need? Try transaction RSPC1, it will directly bring you there!

Another issue in a system with many process chains is how to find out in which meta chain a local chain is used. Therefore use table RSPCCHAIN and fill the name of the local chain in field VARIANTE. All meta chains will show in the result!

Good luck!

Important Tables SAP BW / BI

Below is a list of useful tables in SAP BW / BI feel free to add more!

Transformations
RSTRAN	Transformati e information (routine ID start/end/expert)
RSTRANFIELD	Mapping rules Transformation
RSTRANROUTMAP	Mapping of routines in Transformation (RSAABAP)
RSBKDTP	DTP information table
RSBKREQUEST	DTP request information
RSREQICODS	Request information in DSO’s or Infocubes
RSREQDONE	Table with load request information

Transfer Structure
RSTS	Transfer Structure List
RSTSFIELD	Transfer Structure fields
RSTSRULES	Transfer Structure rules
RSAROUTT	Text name of Transfer Routine
DD03T	Text for R/3 Transfer structure Objects
Update Rules
RSUPDROUT	Update rules List
RSUPDDAT	Update rules with routines
RSUPDKEY	Update rule key fields
RSUPDINFO	InfoProvider to Infosource correlation
Embedded ABAP coding for Transfer / Update Rules
RSAABAP	ABAP source code per object routine
InfoPackage
RSLDPIO	Links datasource to infopackages
RSLDPIOT	InfoPackage Text Description
RSLDPRULE	ABAP source code for InfoPackages
RSLDPSEL	Hardcoded selections in InfoPackages
RSMONICDP	Contains the request-id number by data target
RSPAKPOS	List of InfoPackage Groups / InfoPackages

ProcessChain
RSEVENTCHAIN	Event Chain Processing Event Table
RSEVENTHEAD	Header for the event chain
RSEVENTHEADT	Header for the event chain
RSPCCHAIN	Process chain details
RSPCCHAINATTR	Attributes for a Process Chain
RSPCCHAINEVENTS	Multiple Events with Process Chains
RSPCCHAINT	Texts for Chain
RSPCCOMMANDLOG	System Command Execution Logs (Process Chains)
RSPCLOGCHAIN	Cross-Table Log ID / Chain ID
RSPCLOGS	Application Logs for the Process Chains
RSPCPROCESSLOG	Logs for the Chain Runs
RSPCRUNVARIABLES	Variables for Process Chains for Runtime
RSPC_MONITOR	Monitor individual process chains

Queries
RSZELTDIR	Directory of the reporting component elements
RSZELTTXT	Texts of reporting component elements
RSZELTXREF	Directory of query element references
RSRREPDIR	Directory of all reports (Query GENUNIID)
RSZCOMPDIR	Directory of reporting components
RSZRANGE	Selection specification for an element
RSZSELECT	Selection properties of an element
RSZELTDIR	Directory of the reporting component elements
RSZCOMPIC	Assignment reuseable component <-> InfoCube
RSZELTPRIO	Priorities with element collisions
RSZELTPROP	Element properties (settings)
RSZELTATTR	Attribute selection per dimension element
RSZCALC	Definition of a formula element
RSZCEL	Query Designer: Directory of Cells
RSZGLOBV	Global Variables in Reporting
RSZCHANGES	Change history of reporting components

Workbooks
RSRWBINDEX	List of binary large objects (Excel workbooks)
RSRWBINDEXT	Titles of binary objects (Excel workbooks)
RSRWBSTORE	Storage for binary large objects (Excel workbooks)
RSRWBTEMPLATE	Assignment of Excel workbooks as personal templates
RSRWORKBOOK	Where-used list for reports in workbooks

Web templates
RSZWOBJ	Storage of the Web Objects
RSZWOBJTXT	Texts for Templates/Items/Views
RSZWOBJXREF	Structure of the BW Objects in a Template
RSZWTEMPLATE	Header Table for BW HTML Templates
InfoObject
RSDIOBJ	Directory of all InfoObjects
RSDIOBJT	Texts of InfoObjects
RSDIOBJ	Directory of all InfoObjects
RSDIOBJT	Texts of InfoObjects
RSDATRNAV	Navigation Attributes
RSDATRNAVT	Navigation Attributes
RSDBCHATR	Master Data Attributes
RSDCHABAS	Basic Characteristics (for Characteristics,Time Characteristics, and Units)
RSDCHA	Characteristics Catalog
RSDDPA	Data Package Characteristic
RSDIOBJCMP	Dependencies of InfoObjects
RSKYF	Key Figures
RSDTIM	Time Characteristics
RSDUNI	Units

InfoCube
RSDCUBE	Directory of InfoCubes
RSDCUBET	Texts on InfoCubes
RSDCUBEIOBJ	Objects per InfoCube (where-used list)
RSDDIME	Directory of Dimensions
RSDDIMET	Texts on Dimensions
RSDDIMEIOBJ	InfoObjects for each Dimension (Where-Used List)
RSDCUBEMULTI	InfoCubes involved in a MultiCube
RSDICMULTIIOBJ	MultiProvider: Selection/Identification of InfoObjects
RSDICHAPRO	Characteristic Properties Specific to an InfoCube
RSDIKYFPRO	Flag Properties Specific to an InfoCube
RSDICVALIOBJ	InfoObjects of the Stock Validity Table for the InfoCube

Aggregates
RSDDAGGRDIR	Directory of Aggregates
RSDDAGGRCOMP	Description of Aggregates
RSDDAGGRT	Text on Aggregates
RSDDAGGLT	Directory of the aggregates, texts
ODS Object
RSDODSO	Directory of all ODS Objects
RSDODSOT	Texts of all ODS Objects
RSDODSOIOBJ	InfoObjects of ODS Objects
RSDODSOATRNAV	Navigation Attributes for ODS Object
RSDODSOTABL	Directory of all ODS Object Tables
PSA
RSTSODS	Directory of all PSA Tables
DataSource (= OLTP Source)
ROOSOURCE	Header Table for SAP BW DataSources (SAP Source System/BW System)
RODELTAM	BW Delta Procedure (SAP Source System)
RSOLTPSOURCE	Replication Table for DataSources in BW
InfoSource
RSIS	Directory of InfoSources with Flexible Update
RSIST	Texts on InfoSources with Flexible Update
RSISFIELD	InfoObjects of an InfoSource
Communications Structure
RSKS	Communications Structure for InfoSources with Flexible Update
RSKS	Communications Structure (View) for Attributes for an InfoSource with Direct Update
RSKSFIELD	Texts on InfoSources with Flexible Update
RSISFIELD	InfoObjects of an InfoSource with Flexible Update
Transfer Structure
RSTS	Transfer Structure in SAP BW
ROOSGEN	Generated Objects for a DataSource (Transfer Structure, for example in SAP Source System)

Mapping
RSISOSMAP	Mapping Between InfoSources and DataSources (=OLTP Sources)
RSOSFIELDMAP	Mapping Between DataSource Fields and InfoObjects
InfoSpoke
RSBSPOKESELSET	InfoSpoke Directory and Selection Options
RSBSPOKEVSELSET	InfoSpoke Directory with Selection Options and Versioning
RSBSPOKE	List of all InfoSpokes with attributes maintained with transaction RSBO which include the name of the Source & Target Structures
RSBSPOKET	List of all InfoSpokes with the Short & Long Descriptions (only one of these can be maintained).
RSBSTEPIDMESS	Contains all the messages that have been recorded during the execution of an InfoSpoke. This table can be added to using the ABAP Class/Method i_r_log->add_sy_message.
SAP BW Statistics
RSDDSTAT	Basic Table for InfoCubes/Queries
RSDDSTATAGGR	Detail Table for Aggregate Setup
RSDDSTATAGGRDEF	Detail Table of Navigation for each InfoCube/Query
RSDDSTATCOND	InfoCube Compression
RSDDSTATDELE	InfoCube Deletions
RSDDSTATWHM	Warehouse Management
Misc
RSFEC	BW Frontend Check. Useful for checking the installed SAP GUI versions on user machines.
RSSELDONE	InfoPackage selection and job program, there in field UPDMODE the update status (INIT/DELTA/FULL)
RSPSADEL	PSA Table deletion
TBTCP	Job Schedule Definition
TBTCO	Job Schedule Result
RSMONMESS	Monitor Messages
RSERRORLOG	Check loading errors in table
V_RSZGLOBV	Report Variables view table
DEVACCESS	Developer Keys table
TSTC	All Transactions in the system
RSDDAGGRDIR	Directory of the aggregates
ROIDOCPRMS	Control parameters for data transfer from the source system
SMEN_BUFFC	Objects in User's Favorites
TSTCT	Transaction Codes with Text
DD03L	field names and corresponding data element names
DD03LT	Description of each data element
DD02L	All SAP Defined Table Names
DD02LT	Description of All SAP Defined Table Names

Web Item
RSZWITEM	Header Table for BW Web Items
RSZWMDITEM	BW Web Metadata: Template Item ( Dataprovider, Item, ... ).
RSZWITEMXREF	Cross Reference of Web Items
RSZWMIMEIOBUFFER	Buffer for Translation MIME Rep. to IO
RSZWOBJ	Storage of the Web Objects
RSZWOBJTXT	Texts of Templates/Items/Views
RSZWOBJXREF	Structure of the BW Objects in a Template
RSZWTEMPLATE	Header Table for BW HTML Templates
Archiving
RSARCHIPRO	BW Archiving: General Archiving Properties
RSARCHIPROIOBJ	BW Archiving: General Archiving Properties
RSARCHIPROLOC	BW ARchiving: General Local Properties
RSARCHIPROLOCSEL	BW Archiving: Archived Data Area
RSARCHIPROPID	BW Archiving: Program References of InfoProvider
RSARCHREQ	BW Archiving: Archiving Request
RSARCHREQFILES	BW Archiving: Verfified Archive Files
RSARCHREQSEL	BW Archiving: Request-Selections
Open Hub Destination
RSBOHSERVICETP	Open Hub: Service Types
RSBREQUESTDELTA	Open Hub: Cross Reference Outbound/Inbound
RSBREQUESTMESS	Open Hub: Log for a Request
RSBREQUID	Open Hub: Requests
RSBREQUID3RD	Open Hub: Status of 3rd Party Requests
RSBREQUIDRUN	Open Hub: Table with Status for a Request
RSBSTRUCTURE	Open Hub: Generated Structures and Tables