Search
BWFreak - Journey to the center of Business Intelligence

Archive for June, 2008

BEx web information broadcasting

Posted on June 30th, 2008

I am using Information Broadcasting (BW3.5) to leverage the server load and make sure some users never need to know how to access SAPGUI or even report by sending them daily/weekly/monthly emails.
Several dummy users are created just to do the background jobs with different regional authority.
Information broadcasting queries are created, slightly different from the original [...]

Platform: BW3.5
Scenario: 
ODS ZA was updated by 3 other source ODSs, ZB, ZC, ZD using delta for about a year. ZA, ZB, ZC, ZD are in the process chain loading daily.
ODS ZE was newly added to be updated from ZB. Init was done on the weekend for ZE. Delta was added to the same process chain.
The process chain stopped [...]

Learning OLTP side of SAP

Posted on June 15th, 2008

For the last several days, I got an opportunity to actively study what R3/ERP functionals do on OLTP side and how SD/MSD work.  Instead of infoObj, infoPackage and InfoCube… it’s t-code, program, and table.
I enjoy the process of trying to figure it out; I am happy that it helps me understand BW data and business process better… however, I can see it’s not [...]

Magic Bullet

Posted on June 14th, 2008

It’s the blender. I enjoy the expression on some people’s face when I say the name. This is one kitchen appliance I never get tired of.
Thing 1: breakfast smoothy
Banana, yogout, frozen fruits from costco
Optional – cereal, nuts, orange juice, water
Thing 2:  Hummus
Chickpea, chicken soup, garlic, lemon juice, tahini sauce

Cheese burger / bun

Posted on June 14th, 2008

Cheddar cheese
Blue cheese
Fesh basil
Atipasto artichoke
They go well together.

BW InfoSoure

Posted on June 8th, 2008

BW 3.x InfoSources are sets of logically-related InfoObjs that are available in the form of a communication structure.
Multiple DataSources can be assigned to an InfoSource, either from different source systems or not. Exceptions: Only one source system for hierarchies InfoSource.
In transfer rule maintenance,

you assign DataSource to InfoSource;
determine whether the communication structure is filled with fixed [...]

TemSe and Spool

Posted on June 7th, 2008

TemSe: TemSe Data Store, for temporary sequential data; that is, objects that are not normally permanently held in the system are stored in the TemSe.
The spool system uses the TemSe to store output data temporarily. You can set whether the spool data is to be stored by TemSe in the SAP database or in the [...]

Data Mart Delta

Posted on June 7th, 2008

In ODS to cube/ods data mart, data is extracted using function module RSBX_BIW_GET_ODSDATA. Delta setting can be seen in RSA2.
Data source are generated automatically during setup. They can be found through RSA6 (RSA5 for Business content) — BW – DM
Data mart delta in myself BW system sometimes can be found in RSA7, sometimes not.
Checking the following tables, if the data mart name is not in them, RSA7 would [...]

SAPGUI settings

Posted on June 1st, 2008

Customize Start transaction when login: SAP Easy Access screen –> Extra (top menu ) –>Set start transaction (Shift F7)
For BW, it’s handy to set it to RSA1 for BW admins and developers. It’s affect only the current user on current system.
Showing transaction code for all manu  items: SAP Easy Access screen –> Extra (top menu ) –> Settings — Display technical [...]

Edit an infoPacage, in Data Selection tab, select an infoObj of “Date” type, click on the round selection button, usually, the calendar pops up, but not for Data Mart (of the same BW system). 
Message no. RSAOLTP150
No solution on this issue so far.