Search
BWFreak - Journey to the center of Business Intelligence

Archive for March, 2010

Canadian Address Parsing

Posted on March 10th, 2010

Never thought I’ll need to parse Canadian address one day, and never thought parsing addresses not easy. Just so that somebody else don’t need to collect all different kind of addresses again, here’s a list, and likely to grow.
Suite#/Apt#/House# – Street# – Street Name, Postal code
Route#, Postal code
Highway#, Postal code
PO Box#, Postal code
RR#, Postal code
RR = rural route
LCD [...]

RSRV

Posted on March 8th, 2010

Error with partition when loading
Error:
Communication errors (RFC)
DBIF_RSQL_SQL_ERROR
CX_SY_OPEN_SQL_DB ORA-14400:
inserted partition key does not map to any partition
Internal call code………: “[RSQL/INSR//BIC/B0000xxxxxx ]”

Solution:
RSRV -> PSA Tables -> Consistency Check for PSA
Error calling number range object for dimension when loading cube
Solution:
1. rsrv > all elementry tests > master data > compare number range and maximum sid > execute. press [...]

BW recordmode

Posted on March 3rd, 2010

To get a clear defination of BW recordmode:
SE11, data type RODMUPDMOD -> click Documentation
RODMUPDMOD
____________________________________________________
Short Text
BW Delta Process: Record Mode
Definition
This attribute describes how a record is updated in the delta process. The various delta processes support different combinations of the seven possible characteristic values. If a DataSource implements a delta process that uses several characteristic values, [...]