SAP Creating BI DataStore Objects

Procedure

...

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

2. In the context menu of 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.

You get to the DataStore object maintenance screen.

4. Copying InfoObjects:

On the left side of the screen, there are various templates to choose from. These allow you to get a better overview in relation to 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 switched on to analyze data in BEx.

Or:

You are also able to insert InfoObjects without selecting a template in the left half 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 reassign them.

There has to be at least one key field and one data field.

Additional restrictions:

- You can create a maximum of 16 key fields (if you have more key fields, you can combine fields using a routine for a key field (concatenate)).

- You can create a maximum of 749 fields

- You can use 1962 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. In this way you can sort the data fields in a hierarchy. You then get a better overview of large quantities of data fields in query definition.

6. Using Settings you can make various settings and define the properties of the DataStore object. See also DataStore Object Settingss.

7. Under Indexes, call the context menu to create secondary indexes. This improves the load and query performance of the DataStore object. Primary indexes are created automatically by the system.

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

The description of the indexes is specified by the system. To create a folder for the indexes, choose Continue from the dialog box. Now you can transfer the required key fields into the index folder using drag and drop.

You can create a maximum of 16 secondary indexes. These are also transported automatically.

For more information see 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.