Updating Data Flexibly from a
Flat File
Procedure
...
1. Defining the Source System from Which You Want to Load Data
In the source system tree choose File → Create.
2. Defining the InfoSource for Which You Want to Load Data
Optional: choose InfoSource Tree → Root (InfoSources) → Create Application Components.
Choose InfoSource Tree → Your Application Component → Additional Functions → Create InfoSource 3.x → Flexible Updating. Enter a name and a description
3. Maintaining the Communication Structure: defining the Fields for the Flat Files as InfoObjects in the BI System
Specify an InfoObject for each column of your flat file. You can either use existing InfoObjects or create new ones.
More information:
Creating InfoObjects: Characteristics
Creating InfoObjects: Key Figures
The sequence of columns in your communication structure does not have to correspond to the sequence of columns in your flat file.
Activate the communication structure.
4. Assigning the Source System to the InfoSource
Expand the Transfer Structure/Transfer Rules in the lower half of your screen and select your source system.
A proposal for the DataSource, the transfer structure, and the transfer rules is generated automatically.
5. Maintaining the Transfer Structure/Transfer Rules
Change the transfer structure or the transfer rules where necessary.
More information: InfoSources with Flexible Updating of Flat Files
The sequence of columns in the transfer structure must correspond to the sequence of columns in your flat file. If you do not use the same sequence, the corresponding transfer structure is filled incorrectly.
Activate the transfer structure/transfer rules.
Further Steps:
For example, InfoCube:
Creating Update Rules for InfoProviders
Checking the Data Loaded in the InfoCube