Possibilities of DataSource replication

Replication of DataSources is quite painful in BW systems. It usually takes time and there is high effort that needs to be put into it. Normally it is done in tcode RSA1 -> Modeling -> Source Systems -> right click on particular systems and choose Replicate DataSources. This brings up below dialog box where parameters for replication can be set up.

By starting this up it activates all DataSource available in respective source system. SAP delivered improvement to this functionality via below SAP Note that supports replication of specific DataSouce within a source system or an application component.

Despite there are some drawbacks like it replicates all DataSources in 7.x fashion it speeds up whole replication process.

In order to be used this enhancement you need to setup a parameter called REPL_DATASOURCE_UI_740 = X in table RSADMIN. Feature is available as of BW 7.3 SP11 and BW 7.4 SP05.

More information:

1885443 - Replication of Datasources

Export DataSource creation and replication

Hierarchy activation syntax error

Recently I faced an error with regards to activate hierarchy related datasource. While trying to do that there was an error:

Syntax error in GP_ERR_RSAPTH3, row 30 (-> long text)

Issue is within data inconsistency for specific hierarchy in table ROOHIECAT. Luckily there are SAP Notes that can solve this issue. After implementing ABAP report ZROOHIECAT_REPAIR and running it for particular hierarchy issue is solved.

To get the ABAP report look for following SAP Notes:

484370 - Syntax error during activation of BW730 HIER data sources

2113639 - Activation of Hierarchy DataSource - GP_ERR_RSAPTH3

Error loading data from BEx Query – so called VirtualProvider based load

Recently I faced following error. It was on BW on HANA system and source of the load was BEx (or as now called BW Query) Query.

Parallel processing of query 1 resulted in the following messages:

Error reading the data of InfoProvider ZCUBE1$X

Error 2,949 has occurred in the BWA/SAP HANA server

TREX_DBS_AGGREGATE]

view or procedure invalidated;table or view name = 0BW:BIA:ZCUBE1/[Request Info: Object Name = "SAPXXX"."0BW:BIA:ZCUBE1", FM

Error reading the data of InfoProvider ZCUBE2$X

Error 2,949 has occurred in the BWA/SAP HANA server

TREX_DBS_AGGREGATE]

view or procedure invalidated;table or view name = 0BW:BIA:ZCUBE2/[Request Info: Object Name = "SAPXXX"."0BW:BIA:ZCUBE2", FM

Errors occurred during parallel processing of query 3, RC: 3

Error while reading data; navigation is possible

An exception occurred

Error reading the data of InfoProvider @Z_BEX_QUERY

Error reading the data of InfoProvider ZCUBE1$X

Error 2,949 has occurred in the BWA/SAP HANA server

TREX_DBS_AGGREGATE]

view or procedure invalidated;table or view name = 0BW:BIA:ZCUBE1/[Request Info: Object Name = "SAPXXX"."0BW:BIA:ZCUBE1", FM

Parallel processing of query 2 resulted in the following messages:

Error reading the data of InfoProvider ZCUBE2$X

view or procedure invalidated;table or view name = 0BW:BIA:ZCUBE2/[Request Info: Object Name = "SAPXXX"."0BW:BIA:ZCUBE2", FM

Normally this should not be an error as having a BEx Query as source system is not an issue since BW 7.x. However this time even query wasn’t runnable. In attempt to run it I got message:

X MESSAGE BRAIN 299: CL_RSR_RRK0_QCUBE_PACKAGE_CTRL INIT_CUR_QCUBE-02

X MESSAGE BRAIN 299: CL_RSR_OLAP_STATE_INVALID CONSTRUCTOR-01-

I tried to regenerate the query in in t-code RSRT but it didn’t help. Then I turned to SAP Notes search. I found a note 1656582 - Query terminations - InfoCubes, DSOs, master

Data in the SAP HANA DB. This Note suggests running ABAP rep RSDDB_LOGINDEX_CREATE for objects reported by the load error. It worked for me and after running it for both cubes reported I was able to successfully repeat the load.

The report offers to show XML output of all things that were recreated. Here’s how output message looks like:

BEx History not appearing in Query Designer Open dialog

Recently I observed that in my BEx Query Designer there is an empty list on History part of Open dialog pop up window. I knew that I opened many reports in the same BW system in past so it looked like that something doesn’t work. The dialog popup looked like this:

I checked and I found that personalization of BEx History is not active. To activate it is can be done in t-code RS_PERS_ACTIVATE which points to ABAP report of same name.

The t-code is also accessible via SPRO -> SAP NetWeaver -> Business Warehouse -> Settings for Reporting and Analysis -> General Settings for Reporting and Analysis -> Activate Personalization in BEx.

For me it looked like below:

After activating it it turned to this and I started to get a list of previously accessed reports in BEx QD:

The data of previously accessed reports is itself stored in DSO “Personalization Data for the BEx Open Dialog [0PERS_BOD]”. ABAP code which does the activation is encapsulated in ABAP class CL_RS_PERS_PHK and in particular in method ACTIVATE. Table RSPERSHEAD stores information whether BEx History is active or not.

Within the t-code among the BEx history if can also be activated values for BEx Variables that were selected and in case of Web applications report’s drilldowns are saved.

Further information:

Personalizing of BW reports running in JAVA web reporting environment

1849642 - New revision of the transaction RS_PERS_ACTIVATE

1638155 - Issues related to Inactive Personalization in BEx

When process chain will run next time?

One quick tip today for SAP BW developers here. 

When we need to find out when process chain will run next time we normally turn to t-code RSA1 or RSPC1. While having the process chain displayed there is a button “Next Start” available in the toolbar. Clicking on the button there is a pop up window displayed with the information about date/time of the next start.

Now how to find out the same if I need this information in my ABAP program? Luckily there is a nice FM RSPC_GET_DELAY. Just by giving the process chain name as input parameter it displays next start of PC.

ABAP inline declaration doesn’t work in SAP BW

Since I started to use ABAP inline declarations I liked it much. Naturally I’m using it in all SAP NetWeaver environments where I do ABAP programming. However in case of SAP BW I recently faced problem applying the inline declarations.

In particular I programmed a Start routine within SAP BW’s transformation. I used the inline declarations in the Start routine. If I put the same code I had in the routine into standalone ABAP program - the code seemed to work. But if I placed the same code into the routine I got error message while trying to activate the transformation – “Error in Start Routine”.

The transformation couldn’t not be activated. I tried to do hopeless thing – to remove the inline declarations. So I redid the code w/o it. And surprisingly it worked!

The version of the SAP BW system I used was:

SAP_BW                  740     0009   SAPKW74009  SAP BW

SAP_ABA                 740     0009   SAPKA74009  Cross-Application Component

Kernel release          742

Compilation              AIX 1 6 00F79A484C00 use-pr20160324 Mar 30 20

Sup.Pkg lvl.             329

ABAP Load               1981

CUA load                 40

As the inline declarations are available in NW release 7.40, SP05 I assume it should work in SP09. However turned out that BW doesn’t really work with it. In case it is used standalone (e.g. ABAP report or FM) without encapsulating it into BW object like the transformation it doesn’t. I need to try to upgrade my system perhaps to BW 75 to see if it is solved in there :)

SAP BW/4HANA (B4H) versions

Last update on 23APR2025

One of flavor of BW 75 is edition for HANA - so called BW4/HANA (B4H) – see more information about it here. In this post, I keep track of versions available for this product. Notice that version that will follow version 2 is not version 3 but it is called SAP BW/4HANA 2021. This is basically to align with the latest SAP S/4 version that is SAP S/4HANA 2020.

 

From the software component DW4CORE below are versions:

SAP BW/4HANA version 4.0 aka SAP BW/4HANA 2023

SAP BW/4HANA version 3.0 aka SAP BW/4HANA 2021

SAP BW/4HANA version 2.0

SAP BW/4HANA version 1.0

 

Detailed versions listing per SPs:

 

SAP BW/4HANA 2023      Gen. Avail.             End of Maint          Rel.Note

SP05 (xx/2025)                 DD.MM.2025                                         

SP04 (02/2025)                 24.02.2025                                           3515771

SP03 (11/2024)                 18.11.2024                                           3381471

SP02 (07/2024)                 08.07.2024                                           3381441

SP01 (02/2024)                 28.02.2024                                           3372694

Initial Shipment Stack         25.10.2023             31.12.2030             3365187

Online docu

 

SAP BW/4HANA 2021      Gen. Avail.             End of Maint          Rel.Note

SP12 (xx/2025)                 DD.MM.2025                                         

SP11 (11/2025)                 31.03.2025                                           3490445

SP10 (10/2024)                 14.10.2024                                           3381405

SP09 (06/2024)                 24.06.2024                                           3381477

SP08 (03/2024)                 11.03.2024                                           3381413

SP07 (12/2023)                 04.12.2023                                           3348460

SP06 (07/2023)                 24.07.2023                                           3303491

SP05 (03/2023)                 20.03.2023                                           3228347

SP04 (12/2022)                 05.12.2022                                           3220868

SP03 (08/2022)                 28.08.2022                                           3145496

SP02 (05/2022)                 12.5.2022                                             3145449

SP01 (02/2022)                 02.03.2022                                           3092812

Initial Shipment Stack         25.10.2021             31.12.2027             3100794

Useful links version 2021:

Online docu 1

Online docu 2

 

Version 2.0            Gen. Avail.             End of Maint                    Rel.Note

SAP BW/4HANA 2.0  25.02.2019             31.12.2025

SPS levels

SP17 (12/2024)                 02.12.2024                                           3381436

SP16 (05/2024)                 13.05.2024                                           3381469

SP15 (04/2023)                 21.04.2023                                           3326333

SP14 (03/2023)                 24.03.2023                                           3221043

SP13 (11/2022)                 28.11.2022                                           3215451

SP12 (07/2022)                 25.07.2022                                           3141437

SP11 (03/2022)                 21.03.2022                                           3105028

SP10 (12/2021)                 07.12.2021                                           3071065

SP09 (08/2021)                 02.08.2021                                           3032263

SP08 (04/2021)                 06.04.2021                                           2989901

SP07 (12/2020)                 07.12.2020                                           2942766

SP06 (08/2020)                 04.08.2020                                           2908965

SP05 (05/2020)                 04.05.2020                                           2887979

SP04 (03/2020)                 02.03.2020                                           2849318

SP03 (11/2019)                 11.11.2019                                           2813668

SP02 (08/2019)                 12.08.2019                                           2775326

SP01 (05/2019)                 06.05.2019                                           2738784

Initial Shipment Stack                                                                     2733740

Useful links version 2:

#BW4HANA 2.0 Has Been Released

Improvements of bw4hana analytical engine bw4hana-2.0

 

Version 1.0            Gen. Avail.             End of Maint                    Rel.Note

SAP BW/4HANA 1.0  07.09.2016             31.12.2021 - Reached End of Mainstream Maintenance.

 

SPS levels

21                          MM.DD.YYYY                                                    3077773 – not released

20                          12.10.2021                                                     3043673

19                          03.05.2021                                                     2981252

18                          16.11.2020                                                     2937095

17                          13.07.2020                                                     2891199

16                          16.03.2020                                                     2861081

15                          16.12.2019                                                     2833752

14                          23.09.2019                                                     2797027

13                          24.06.2019                                                     2756841

12                          25.03.2019                                                     2687111

11                          17.12.2018                                                     2646765

10                          25.9.2018                                                       2613215

09                          26.6.2018                                                       2561976

08                          26.3.2018                                                       2526413

07                          11.12.2017                                                     2526413

06                          26.09.2017                                                     2491835

05                          17.07.2017                                                     2458236

04                          15.05.2017                                                     2429588

03                          20.03.2017                                                     2407087

02                          30.01.2017                                                     2379490

01                          10.11.2016                                                     2364946

Initial Shipment Stack 07.09.2016                                                   2347382

Useful links version 1:

2347382 - SAP BW/4HANA – General Information (Installation, SAP HANA, …)

2189708 - SAP BW/4HANA Add-On Handling and Usage

2404122 - Check for BW Upgrade to BW4HANA

2347384 - SAP BW/4HANA 1.0 Important Notes before you start

 

More information:

Support Portal (Marketplace) component: BW-B4H

Software Components:

BW4HANA - SAP BW/4HANA

DW4CORE - SAP BW/4HANA Core

BW4CONT - SAP BW/4HANA Content

BW4CONTB - SAP BW/4HANA Extended Content