Loading 0calweek, 0calmonth to the ODS and cube works. If it’s an old cube without those fields, the best thing to do is using structure in the query

BW Reporting, SAP BW | No Comments »

BW3.5
Key figure is treated by BW as one structure. Therefore, if you create two structures and want another key figure outside of the structures, you can’t. You need to include the key figures in.

SAP BW | No Comments »

Users got above error when openning excel BW workbook.
List of possible reasons to check:
Check Excel Add-ins setting – menu –>Tools –>Add-ins –> uncheck all
Authorization: S_GUI, activity 60, 61
Excel Security setting  - menu –> Tools –>Macro –>Security –>level “Medium”
GUI – reinstall.

BW Admin, SAP BW | No Comments »

Error when loading to ODS – BW3.5. It happens after transport  to production a new change which delete an “Date” type infoObj in the key section.
Checked RSA3 in source system, fine, didn’t work
Reactivate update rules, didn’t work
Activate the ODS again,  didn’t work
RSRV – All elementary tests – ODS – Check how up-to-date the generated program of [...]

BW Admin, SAP BW | No Comments »

The job SAP_COLLECTOR_FOR_NONE_R3_STAT is designed to collect non ABAP Statistic Data in/for a central repository.
If any errors, you can see errors from slg1.
Determination of component from SCR failed
Diagnosis
The system cannot determine the components for which the component collector is to be started. The cause is missing data in the CCMS System Component Repository (SCR). Either [...]

BW Admin, Basis & DB, SAP BW, SAP General | No Comments »

After system copy, init/delta load might fail.
To fix delta,
1. check on BW server, table RSSDLINIT, ROOSPRMSF, and ROOSPRMSC
select logsys,isource,oltpsource from sapr3.RSSDLINIT;
select logsys,isource from sapr3.RSSDLINITSEL;
2. In Source system, RSA7, delete delta in delta queue
3. Run program RSSM_OLTP_INIT_DELTA_UPDATE on failed delta on BW system, Fill in logsys and isource from RSSDLINIT table. See note:852443

BW Admin, SAP BW | No Comments »

Duplicate records error may occur during Master data extracting/loading.  Usually reload from PSA or source system can solve the issue. But when it’s a daily load with process chain, an once for all solution is needed. 
It’s possible to select the following if update only to Master data.
Open the InfoPackage –> Update tab –> Error handling –>Valid records update, reporting possible
But if [...]

BW Admin, SAP BW | No Comments »

You can delete the values that are not used from a characteristic using the report RSDMD_DEL_BACKGROUND.You have to execute the report with the following parameters:

P_IOBJNM = (Technical name of time characteristic)
P_CHABNM = (Technical name of time characteristic)
P_DELSID = ‘X’
P_DELTXT = ‘ ‘
P_OBJ = RSDMD
P_SUB = MD_DEL
P_EXT = ‘ ‘
P_NOPROT = ‘ ‘
It takes a long time [...]

BW Modeling, SAP BW | No Comments »

A transaction code “Delete_facts” can generate an ABAP program to perform selective deletion for ods and cube.
The program should be renamed as a “Z” program, otherwise, it’s in SAP namespace.
Run that generated program and save the variant which should be a variable so that it changes.
Add the program into process chain. Using Synchronous mode.
Alternative: Write your own ABAP [...]

BW Admin, SAP BW | No Comments »

go to RSPC-> open process chain-> enter “COPY” as T-code, then the chain on the right panel is the new chain -> save -> Check -> change starter

SAP BW | 1 Comment »