To access the offloaded data of a DataProvider, you must create a HANA view.
Proceed as follows to create a HANA view:
1. Start transaction /DVD/OFF.
2. In the menu bar, click Other > Expert tools.
3. Execute the report /DVD/OFF_ANA_H_CREATE_HNA_OBJS - Create HANA view for the DataProvider.
The function will create the following calculation scenario:
| Parameter name | Description |
|---|---|
|
HANA DB connection |
Name of the connection to the HANA database (leave empty if you want to use primary HANA database) |
|
Schema |
Name of the database schema |
|
Remote source |
Name of the remote source defined on the HANA database that points to the current SAP system |
|
DataProvider Name |
Name of the DataProvider for which you want to create a view |
Object names are generated with the following names:
| Object type |
HANA object name pattern |
|---|---|
|
Virtual table name |
<Remote source>_<DataProvider Name>_VT |
|
Aggregation with pruning condition |
<Remote source>_<DataProvider Name>_CS.AGGR_FILTER |
|
Calculation scenario (for reading data) |
<Remote source>_<DataProvider Name>_CS |
|
If you want to obtain the list of DataProviders for which the HANA view has already been created, use the search help in a view deletion report or read the table /DVD/OFF_ANA_H_S using transaction SE16. |
|
