Thursday, February 11, 2016

2225793 - Where-Used of HANA Objects in CompositeProviders (Part 2)

Symptom
Usage of HANA objects (e.g. calculation views) in CompositeProviders is nowhere displayed.


Other Terms
BW modeling tools; where-used; cross reference; RSOOBJXREF_HANA; RSO_BW_HANA_OBJXREF_REBUILD


Reason and Prerequisites
Missing fast data access for used HANA objects. A special persistency layer needs to be established.


Solution
To solve the issue, apply the following Support Packages:
  • SAP BW 7.40

    Import Support Package 14 for SAP BW 7.40 (SAPKW74014) into your BW system. The Support Package will be available as soon as SAP Note 2207824 with the short text "Preliminary Version SAPBWNews NW BW 7.4 ABAP SP14", which describes this Support Package in more detail, is released for customers
  • SAP BW 7.50

    Import Support Package 2 for SAP BW 7.50 (SAPK-75002INSAPBW) into your BW system. The Support Package will be available as soon as SAP Note 2220381 with the short text "Preliminary Version SAPBWNews NW BW 7.50 ABAP SP2", which describes this Support Package in more detail, is released for customers.

Before you use the correction instructions, make sure that you check SAP Note 1668882 for transaction SNOTE.

This SAP Note might already be available before the Support Package is released. In this case, however, the short text still contains the term "preliminary version".

This note is the step 2 to get the solution complete. Note 2228161 contains part 1.

You need at least version 1.11 of the BW Modeler in order to display a where-used list for a HANA object. You will find this functionality in the BW Object Search dialog (find it in the toolbar menu), where you can specify a HANA object together with restrictions (name, type, user etc.). Find the "Uses" line below the date restrictions and press "browse" to select your HANA object.

Since the usages of HANA objects are persisted in a new DB table in the system, you need to run report RSO_BW_HANA_OBJXREF_REBUILD once. This report will fetch the existing BW objects (CompositeProviders) in the system, determine the used HANA objects for each of them, and save the result in a DB table. The BW objects will not be changed by this process. After that, the where-used lists will be available.





------------------------------------------------------------------------
|Manual Post-Implement.                                                |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   SAP_BW                        Business Inform...|
| Release 740          SAPKW74010 - SAPKW74013                         |
------------------------------------------------------------------------

Run report RSO_BW_HANA_OBJXREF_REBUILD in order to inialize the DB table which stores all usages of HANA objects by BW objects.

On the selection screen, select "Rebuild HANA object reference table" (R_CHG) and press F8.

For testing purposes, you can simulate the execution by choosing "Simulate (do not save in DB)" (R_SIM). The system will just tell you the number of used HANA objects.
Also, you can restrict the BW objects (CompositeProviders) to be processed. However, the DB table storing the usage of HANA objects is then not complete.


------------------------------------------------------------------------
|Manual Post-Implement.                                                |
------------------------------------------------------------------------
|VALID FOR                                                             |
|Software Component   SAP_BW                        Business Inform...|
| Release 750          Until SAPK-75001INSAPBW                         |
------------------------------------------------------------------------

Run report RSO_BW_HANA_OBJXREF_REBUILD in order to inialize the DB table which stores all usages of HANA objects by BW objects.

On the selection screen, select "Rebuild HANA object reference table" (R_CHG) and press F8.

For testing purposes, you can simulate the execution by choosing "Simulate (do not save in DB)" (R_SIM). The system will just tell you the number of used HANA objects.
Also, you can restrict the BW objects (CompositeProviders) to be processed. However, the DB table storing the usage of HANA objects is then not complete.


Header Data

Released On 09.10.2015 12:32:01
Release Status Released for Customer
Component BW-MT-HCPR CompositeProvider in BW Modeling Tools
Other Components
BW-MT Modeling Tools (Eclipse)
Priority Correction with medium priority
Category Program error

No comments:

Post a Comment