Files As Destinations in BW BI

Use

You can select flat files in format .CSV as an open hub destination.

Features

The only file format that is supported for extraction to flat files is .CSV. A control file with information about the metadata is also generated. You can either save the file on the application server or in a local directory.

If you save the file locally, the file size must not exceed a half GB. When transferring mass data, you should save the file on the application server.

If the data is to be written to a BI system application server, you can determine the file name in two ways:

● File name:

The file name is made up of the name of the HOME directory (DIR_HOME in transaction AL11), the technical name for the InfoSpoke and the suffix .CSV. You cannot change this name.

● Logical file name:

You can use input help to select a logical file name that you have already defined in Customizing. Create a logical path and assign a logical file name to it (see Defining Logical Path and File Names).

When you define a logical file name you can also specify a data format. However, the InfoSpoke ignores this specification. Extraction always takes place in CSV format.

A logical file name can be made up of fixed path information, but also of variables such as calendar day and time. Logical file names can be transported.

If you save the file in a local directory, you cannot change the name of the file. It consists of the technical name of the InfoSpoke and the suffix .CSV. The associated control file also has the prefix S_.