Search
BWFreak - Journey to the center of Business Intelligence

Archive for April, 2008

transfer structure transport errors fix

Posted on April 28th, 2008

Start of the after-import method for object type R3TR ISTS
There is no DataSource with these attributes
Reference to transfer structure [xxxxx_BG] not available. No activation possible.
Cause 1: the transfer structure object is not in the right package or original system
Solution: SE03 –> Change Object Directory Entries –> enter the object –> change package, responsible person, original system. 
Cause [...]

SAP tables

Posted on April 25th, 2008

What is transparent, cluster and pool table?  Where and when we use these tables?
What is the major difference between Standard tables, Pooled tables and Clusterd Tables?
Transparent Table :  Exists with the same structure both in dictionary as well as in database  exactly with the same data and fields.
Pooled Table : Pooled tables are logical tables [...]

setup smtp using bcs interface

Posted on April 25th, 2008

Sending E-Mail from ABAP – Version 610 and Higher – BCS Interface
Business Communication Services (BCS)
use SICF to setup smtp SAPConnect
use SCOT to specify the external mail server
use SCOT to setup default domain server: menu — setting — default domain. 
switch view to Jobs to schedule a new job – sap & connetall
Utilities – overview of send [...]

BW 3.5 authorization settings

Posted on April 25th, 2008

Transactions:
pfcg – create roles
rssm – reporting related authoriztion objects, test roles
su01 – assign roles to users
pfud & “text comparison” button if use CUA
SUGR: set user group.
suim
su10
scul: when save in solution manager but the “last change on” date doesn’t change, use log display to see if there’s any problem using su01.
Quick tips:
Add RFCH in RFC transactions to [...]

OLAP cache setting

Posted on April 17th, 2008

My goal is to set “Flat file as cache” when memory cache is not big enough. 
1. SPRO –>SAP Reference IMG –> SAP NetWeaver –> SAP Business Information Warehous –> Reporting-relevant Settings –> General Reporting Settings in Busines Explorer –> Global Cache Settings –>Persistence Mode: Flat File, Flat file Name : “BW_OLAP_CACHE”
2. FILE –> (olap cache logical file [...]

Copy queries between infoProviders

Posted on April 16th, 2008

T-code: RSZC if all characteristics and Key Figures are the same
or create customized function module base on RSZ_I_COPY_QRY_TO_CUBE and set
l_is_compliant to not empty.

Why high I/O Waiting

Posted on April 16th, 2008

Symptom: Server react very slow, “topas” or ST06 shows High I/O waiting and huge paging. It can be a sign of running out of memory causing swap.
Check sm50 — see what process is running
Check st02 — see where is the problem
In my case, I have several scheduled reports running at the same time. When they [...]

Error when opening Web Application Designer (BW3.5)
I got popup error messages:
Internal error: no template property standard item
run-time error 91: object block variable not set
Then,  the application closed.
Solution:
Deleting cache.
After login before open a web template, goto “Tools” –> “Setting” –>”Delete Cache”
Click on the “Delete Cache” button.