[BW] Setting the Global Workbook Template in SAP NetWeaver 2004s BI or BW 3.x

Introduction

Recently, I've had many people ask me about setting a default workbook template, both in BW 3.x and SAP NetWeaver 2004s BI. This blog will show you how this can be done.

The Tables

In case you are wondering, these are the basic tables used for workbooks.

RSRWBINDEX – Workbook Header Table

RSRWBINDEXT – Workbook Text Table

RSRWBSTORE – Workbook Storage Table

RSRWBTEMPLATE – Default Workbook to User Table

Setting a global workbook

To see the default global workbook, go to table RSRWBTEMPLATE. In a BW 3.x system, this table has 2 fields (TEMPLATEUSER and WORKBOOKID). In SAP NetWeaver 2004s BI, this table has 3 fields (TEMPLATEUSER, WORKBOOKID, and LEAST_BEX_VERSIO). The version has been added to distinguish whether this is a BW 3.x workbook or an SAP NetWeaver 2004s BI workbook. If the version is listed as "70" in this version field, that is a 2004s workbook. If not, it is a BW 3.x workbook. If there are no entries specified in this table, the system utilizes the default workbook which is programatically restricted.

Therefore, if you leave this table blank, you will use the SAP default workbook. When an end user logs in to the BEx Analyzer (3.x or 2004s), they can specify their own default workbook.

Within the BW 3.x analyzer, this is done by going to "Business Explorer -> Settings -> Permanent Workbook Template" and choosing the permanent workbook template. This will create an entry in the RSRWBTEMPLATE table for this user. Similarly, within the 2004s BEx Analyzer, the user can go to "BEx Analyzer -> Global Settings -> Select Default Workbook". This will allow them to set a permanent workbook for themselves or they can flag the global parameter to set this globally.

If you want to specify a global workbook programatically, this is pretty easy. Specifying the blank user within RSRWBTEMPLATE is the global workbook template for that particular runtime. If you just want to set this globally, then don't use the program below. As I described earlier, you can setup the global workbook through the BEx Analyzer by specifying the global flag in the 2004s runtime. Additionally, you can very easily create an ABAP program to mass update this table with a particular workbook and user entries. This simple ABAP program gives you an example how to mass update this table. The p_vers parameter allows you to flag whether you want to update this for 2004s or not. Typically, you would just update the blank user for 2004s, but this is an option if you want to mass populate this table. You can adapt this program to assign different user groups to different templates as well...



In addition, for the BW 3.x runtime, you will need to update the registry to tell the application to use the default template. To manually make these changes, go to regedit.

Go to the following path:
HKEY_CURRENT_USER -> Software -> SAP -> BEx -> chooseTemplate
Make sure the Default value is set to “T”.

Summary

Now you should know how to set the global workbook for the BW 3.x runtime or SAP NetWeaver 2004s BI runtime! Keep in mind this program is just an example. You can adapt it to your needs. That is why I listed the tables.

==========================================================
*&---------------------------------------------------------------------*
*& Report Z_SET_BEX_USER_TEMPLATE *
*& *
*&---------------------------------------------------------------------*
*& Program to update all user's default template *
*& *
*&---------------------------------------------------------------------*

REPORT Z_SET_BEX_USER_TEMPLATE.

**************************************************************************
* Type Pools
**************************************************************************
type-pools:
rs, rsr, rspar, rssg.
**************************************************************************

selection-screen begin of block rad2 with frame title text-001.
parameters: wbid like rsrwbindex-workbookid,
p_vers as checkbox default rs_c_true..
selection-screen end of block rad2.

tables: rsrwbtemplate, usr01.
select * from usr01.
rsrwbtemplate-templateuser = usr01-bname.
rsrwbtemplate-workbookid = wbid.
if p_vers = rs_c_true.
rsrwbtemplate-LEAST_BEX_VERSIO = '70'.
endif.
update rsrwbtemplate.
if sy-subrc <> 0. insert rsrwbtemplate. endif.
endselect.

[NW04s] Apply java patches

Release all change requests first.
====================================================
apply kernel patches:
copy uncar file to G:\usr\sap\BWJ\SYS\exe\uc\NTI386
====================================================
update sdm first
detail check blog(search SDM)
====================================================
review notes : 884537
In step 3 of the SP-stack wizard select the button 'Save As File', right-click on the XML-file entry and save the file in your global EPS Inbox directory

/usr/sap/trans/EPS/in.
For more information, see SAP Help Portal at help.sap.com -> Documentation -> SAP NetWeaver -> SAP NetWeaver 2004s -> SAP Library -> SAP NetWeaver Library -> SAP

NetWeaver by Key Capability -> Solution Life Cycle Management by Key Capability -> Software Life Cycle Management -> Software Maintenance -> Java Support Package

Manager -> Applying a Support Package Stack.
http://help.sap.com/saphelp_nw2004s/helpdata/en/25/c45b4211aac353e10000000a1550b0/frameset.htm
copy the xml and java patch files to /usr/sap/trans/EPS/in
run go.bat in G:\usr\sap\BWJ\DVEBMGS00\j2ee\JSPM
====================================================

[NW04s] Exception style control

change the theme 內文 in portal

[BW] raise error message from variable user exit

DATA: LOC_VAR_RANGE LIKE RRRANGEEXIT.

IF I_STEP = 3.
LOOP AT I_T_VAR_RANGE INTO LOC_VAR_RANGE WHERE VNAM = 'MONTH'.
IF LOC_VAR_RANGE-LOW(4) LE 1998.
CALL FUNCTION 'RRMS_MESSAGE_HANDLING'
EXPORTING
I_CLASS = 'RSBBS'
I_TYPE = 'I'
I_NUMBER = '000'
I_MSGV1 = 'Year <= 1998 not allowed'.
RAISE no_replacement.
ENDIF.
ENDLOOP.
ENDIF.

[BW] Change variable process type RSZGLOBV

You can change the query variable properties with table RSZGLOBV

[Javascript] 兩個 iFrame 同步捲動

1. 兩個 iFrame：f1，f2

2. f1.htm：

function SCRL()
{
parent.window["f2"].document.body.scrollLeft = document.body.scrollLeft;
parent.window["f2"].document.body.scrollTop = document.body.scrollTop;
}

3. f2.htm：

function SCRL()
{
parent.window["f1"].document.body.scrollLeft = document.body.scrollLeft;
parent.window["f1"].document.body.scrollTop = document.body.scrollTop;
}

4. 兩邊的 Body 加上 onScroll="SCRL()"