Creating DataStore Objects 

Procedure

...

       1.      Select the InfoArea that you want to assign the DataStore object to, or create a new InfoArea. Choose Modeling → InfoProvider  → Create InfoArea.

       2.      In the context menu for the InfoArea, choose Create DataStore Object.

       3.      Specify a name and a description for the DataStore object, and choose  Create.

If you want to create a copy of an existing DataStore object, specify the DataStore object that you want to use as a template.

The DataStore object maintenance screen appears.

       4.      Add the InfoObjects:

The left side of the screen contains a number of different templates. These give you a better overview of a particular task. For performance reasons, the default setting is an empty template. You use the pushbuttons to select different objects as templates.

On the right side of the screen, you define the DataStore object. Using the drag and drop function, assign the InfoObjects in the key fields and in the data fields. You can select several InfoObjects at once. The system assigns navigation attributes automatically. These navigation attributes can be activated to analyze data in Business Explorer. If the navigation attributes are switched on, they are also displayed in the transformation (only if the DataStore object is the source) and can be updated.

Or:

You can also insert InfoObjects without selecting a template in the left side of the screen. This is useful if you know exactly which InfoObjects you want to include in the DataStore object. To do this, choose Insert InfoObjects in the context menu for the node for key fields or data fields. In the dialog box that appears, you can enter and transfer up to 10 ten InfoObjects directly and or you can select them using input help. You can use drag and drop to move them.

There must be at least one key field.

Additional restrictions:

-         You can create a maximum of 16 key fields. If you have more key fields, you can merge (concatenate) fields into one key field using a routine.

-         You can create a maximum of 749 fields.

-         You can use 4030 bytes (minus 44 bytes for the change log).

-         You cannot include key figures as key fields.

       5.      In the context menu of the Data Fields folder you can Insert New Hierarchy Nodes. This allows you to sort the data fields in a hierarchy. You then get a better overview of large quantities of data fields in query definition.

       6.      Under Settings, you can make various settings and define the properties of the DataStore object. More information: DataStore Object Settings

       7.      Under Indexes, call the context menu to create secondary indexes. This improves the load performance and query performance of the DataStore object. The system automatically creates primary indexes.

If the values in the index fields uniquely identify each record in the table, select Unique Index from the creation dialog box. Errors can occur during activation if the values are not unique.

The system specifies the number of each index. To create a folder for the indexes, choose Continue from the dialog box. You can add the required key fields to the index folder using drag and drop.

You can create a maximum of 16 secondary indexes. The system also transports these automatically.

More information: Indexes

       8.      Use  Check to make sure that the DataStore object is consistent.

       9.      Save the DataStore object and activate it. When you activate the DataStore object, the system generates an export DataSource. You use this to update the DataStore object data to further InfoProviders.

Result

You can now create a transformation and a data transfer process for the DataStore object to load data. If you have loaded data into a DataStore object, you can use this DataStore object as the source for another InfoProvider. More information: Processing Data in DataStore Objects. You can display and delete the loaded data in DataStore object administration. More information: DataStore Object Administration.