Monday, April 23, 2012

Deletion of temporary database BW objects

It might happen that because of upgrade of BW system, maintenance activities, inconsistencies etc. you need to reorganize temporary BW objects. These kinds of objects are starting with following name convention: 


Where X means different temporary object given by specifics circumstances which occurred when the object was created. E.g. /BI0/06* are tables used during BEx query processing. Refer to SAP Note 449891 for more object types.

If you face situation that you are running out temporary objects you can delete temporary object. You can use report SAP_DROP_TMPTABLES to reorganize them. Report deletes them pretty straight forward with checking either they are used at the runtime of report. Therefore it is advisable to run this report as a part of maintenance activities in defined time frame when no regular activities are happening in the BW system. Make sure no user is running queries, no data load is happening, no compression is in place etc.

Notice that report’s runtime is depended on how big your system is. In general if you going to run it for first time it might be that it will run for several hours.

Furthermore you can use function module RSDDTMPTAB_CLEANUP (while specifying input parameter I_NAMETYPE = 03) for the same as well.

See other SAP notes on topic of Temporary database objects in BW:
1139396 - Temporary database objects in BW 7.X
449891 - Temporary database objects in BW 3.x
659946 - FAQ: Temporary tablespaces

Thursday, April 12, 2012

SAP BusinessObjects BI 4.0 – new names of tools

It is been some time since SAP introduced SAP BusinessObjects 4.0 on the market last year (16th of September 2011). This version came as successor of SAP BusinessObjects XI 3.x and was developed under code name Aurora. 

Anyway might be enough time to get acquainted with the new names of tools included in package of BI 4.0. Just not enough time for me :) that’s why I’m posting this short blog.

Former name
New Name
 SAP BO Enterprise (BOE)
SAP Business Intelligence Platform
(BI Platform)
BO Explorer

Interactive Analysis
Crystal Reports
Crystal Reports Enterprise
Crystal Reports Dashboards Design
SAP BO Dashboards
Advanced Analysis Web
SAP BO Analyses Edition for OLAP
Advanced Analysis
SAP BO Analyses Edition for MS

Used sources:

Other posts of interest in BO topic: