Show TOC

Creating DataStore Objects (advanced) Locate this document in the navigation structure

The DataStore object (advanced) is the central object for data storage and data consolidation in the BW system.

Procedure

  1. You are in the BW Modeling tools. In the context menu for your BW project, choose Start of the navigation path New Next navigation step DataStore Object (advanced) End of the navigation path. You will now be guided through the creation process by a wizard. More information: Creating DataStore Objects Using the Wizard (advanced)
  2. The General tab opens. If you set the External SAP HANA View flag, an SAP HANA view is generated from the DataStore object. More information: http://help.sap.com/saphelp_nw74/helpdata/en/66/33d851345c4770bd4e523701b9f5b0/content.htm
  3. If you have not selected a template for the data warehousing layer, you can configure the required properties manually under Modeling Properties. More information: Modeling Properties
  4. On the Details tab, select the InfoObjects that you want to be included in the DataStore object and/or create the fields. You can create groups in order to organize the fields and InfoObjects.
    More information:
  5. If you add a non-cumulative key figure, the system will also display the Inventory tab. More information: Using Non-Cumulative Key Figures
  6. Optional expert setting: You can create partitions for key fields on the Settings tab.
    More information: Creating Partitions
  7. Optional expert setting: You can create secondary indexes for a DataStore object on the Settings tab. The index is created on the active table. If no active table is found, the index is created on the inbound table. More information: Creating Indexes
  8. Activate the DataStore object.
  9. Under Properties in the screen area under the Editor, you can see information, about the DDIC elements for example. You can navigate further to the relevant information via the links.
    Note The generated view are only intended for internal use, not for use as an interface. You can use the external SAP HANA view instead, or official interfaces. More information: Quick Reference: Interface Overview

Results

The DataStore object (advanced) is displayed in the Data Warehousing Workbench and can be integrated into a data flow.