Introduction

This document contains the Configuration steps which are to be performed after installing SAP BW system.

Step1: Maintain the logical Systems

After installation, login to the 000 client and add the logical system entry.

Transaction BD54: Add all Logical systems which are in use

/wp-content/uploads/2014/06/1_478223.png

Step2: Defining Client in transaction code SCC4 or use below path to configure client

/wp-content/uploads/2014/06/2_478102.png

It will take you to below screen

/wp-content/uploads/2014/06/3_478121.png

Create new entries

/wp-content/uploads/2014/06/4_478122.png

  • Enter client number, name, logical system name, std currency, client role.

           For development system selects customizing

Changes and transports for client-specific objects

           For development system: “select Automatic recording of changes”

           For Quality/Production system: “No changes allowed”

Cross-client Object changes

           For development system: Changes to repository and cross-client Customizing allowed.

/wp-content/uploads/2014/06/5_478225.png

After creating the standard client, add the parameter login/no_automatic_user_sapstar in the instance profile and restart the system for the parameter to take effect. After the restart, you will be able to login to the standard client using the sap* user id   with the standard password.

Perform a client copy from 000 client to the standard client which you have created

T-code SCCL.

/wp-content/uploads/2014/06/6_478136.png

Schedule a background job to by giving the above input values.

Once the client copy is completed, perform a kernel upgrade to the latest level and then support pack upgrade.

Step3: RSADMINC (Customizing Table General BW) table configuration

Update the Table with below values:

INFOIDOCFRQ update with the value 10

IDOCPACKSIZE update with the value 30000

PSAPARTSIZE update with the value 1000000      

File name: BW_OLAP_CACHE

File name span: BW_OLAP_CACHE_SPAN

UOM_BUFF_SIZE: 500

SPLT_QRY_TAB_THR: 50

SPLT_DM_TAB_THR: 20

ORA_PARALLEL_DEG: 4

TMPLID_ANALYZER: ANALYSIS_PATTERN_SPECIAL

RSER_TMPL_ID: 0REPORT_DEFAULT_SPECIAL

This table should have updated with User in source system for ALE communication – ALEREMOTE

/wp-content/uploads/2014/06/7_478137.png

Step4: ALEREMOTE settings for Background users

Set ALEREMOTE as the default setting for background users (table entry RSADMINA)

/wp-content/uploads/2014/06/8_478138.png

/wp-content/uploads/2014/06/9_478145.png

Step5:
Activating the Software Component SAP_BW in the CVERS_ACT Table

You can use Function module “RS_SET_ACTIVE_COMPONENT_FLAG” in SE37 to set flag I_ACTIVE_FLAG = ‘X’

/wp-content/uploads/2014/06/10_478233.png

Step6: Preparing the BW System

Go to transaction code RSA1:

Start the Data Warehousing Workbench (transaction RSA1). When starting for the first time, the ‘myself source system’ is created automatically and table RSLOGSYSDEST is modified.

/wp-content/uploads/2014/06/11_478241.png/wp-content/uploads/2014/06/12_1_478246.png

Step7: Activate Technical Content

When starting the Data Warehousing Workbench (transaction RSA1) for the first time, the content is activated automatically.

/wp-content/uploads/2014/06/13_478152.png

Step8: Set the BW Transport System as Default

Field TADIRPOPUP in table RSADMINS (System Settings) is set to “x”. With this entry, you define that the BW transport system is activated in the default system

In case of blank value the dialog prompting the user to enter a transport request does not appear when editing the objects.

Development system: As we need to record changes and collect into transport request, Field TADIRPOPUP in table RSADMINS should not
be blank.

This setting will work on top of SCC4 transport settings.

/wp-content/uploads/2014/06/14_478153.png

Step9: Defining the Recording Time for Transports

Go to->transaction code RSA1, click on transport connection.

Then Edit -> Transport -> Switch-on Standard.

/wp-content/uploads/2014/06/15_478162.png

Step10:

Create job and schedules weekly once

Job name: ZBW_OLAP_CACHE_CLEAR

Program name: RSR_CACHE_RSRV_CHECK

Step11:

Schedule report to clear the DTP buffer

Job: ZBW_DTP_CACHE_CLEAR

Program: RSBKCHECKBUFFER

Step12:

Deleting Messages and Parameters of the BW Background

Job: BI_DELETE_OLD_MSG_PARM_DTPTEMP on daily basis

Program: RSBATCH_DEL_MSG_PARM_DTPTEMP.

Step13: Metadata repository configuration

Prerequisite: The HTTP or HTTP(s) port needs to be open based on the usage. By default, metadata repository will open using HTTP protocol. In case if you want to launch metadata repository using HTTPS protocol, you can add the below ICM parameter in the instance profile using RZ10 T-code and restart the ICM in SMICM transaction.

Icm/HTTP/redirect_0            = PREFIX=/, FROM=*, FROMPROT=http,
PROT=https, HOST=logicalsystem.FQDN, PORT=XXXX (HTTPS PORT NO)

Transaction code: STRUST

Activate SSL server Standard

/wp-content/uploads/2014/06/16_478180.png

SPRO -> Maintain web protocol HTTP/HTTPS.

/wp-content/uploads/2014/06/17_478182.png

Transaction code SICF: Activate service “rso_metadata_repository”

/wp-content/uploads/2014/06/18_478183.png

Metadata repository then launches fine in RSA1transaction.

/wp-content/uploads/2014/06/19_478184.png

Step14: Activate personalization content:

Create Development package with project specific naming convention using T-code SE21 or SE80.

Then activate the personalization content using SPRO transaction

/wp-content/uploads/2014/06/20_478193.png

Please refer the below link for Part 2 of this Configuration Process.

http://scn.sap.com/docs/DOC-55956

To report this post you need to login first.

9 Comments

You must be Logged on to comment or reply to a post.

  1. Vikrant Soni Post author

    Hi all,

    I am also writing a second part of this doc which will be shared soon.

    Please read and provide me feedback if any.

    Thanks,

    Vikrant

    (0) 
    1. Aparajit Banik

      Hi Vikrant,
      First of all its nice to know many configuration level concepts. Its new to me.
      But are these BASIS activities or BW Consultants also do perform such activities say if to start implementation from scratch?
      Regards!

      (0) 
      1. Vikrant Soni Post author

        Hi there,

        It more of Basis activities, but the reason of posting in BW space is just because these activities gives you more insight knowledge about configuration which makes the system ready for us.

        These configuration are actually very important, so its always better to cross check and see if everything is on place for us to work. Consultant at Lead position are pretty well aware of these configurations normally.

        Regards,

        Vikrant

        (0) 
  2. Iheanyi Achareke

    Hi,

    I was just following your post to set up a BW system. the tables RSADMIN* are read only. how d you update them with new values?

    Thanks

    (0) 

Leave a Reply