The cube cannot be partitioned if the data already exists the cube must be empty to do this, one work around is to make a copy of the cube A to cube B, export data from A to B using export data source, empty cube A, create partition on A, re-import data from B, and delete cube B.

The Transaction Code for Administrator work bench is RSA1.

The source system is that which sends the data to BW like R/3, flat file, oracle database or external systems

1. Watch the ABAP code in transfer and update rules.
2. Load Balance on different Servers.
3. Indexes on Source Tables.
4. Use fixed length files if the data is loaded from flat files and put the file on the application server.
5. Use the content extractor.
6. Use PSA and data target in parallel option in the info package.
7. Start Several Info Packagers parallel with different selection options.
8. Buffer the SID number ranges if the data is loaded a lot at once.
9. Load Master Data before loading Transaction Data.

The source which is sending data to a particular info source on BW, for example it contains an OCUSTOMER_ATTR data source to supply attributes to OCUSTOMER from R/3.

Group of logically related objects, for example the OCUSTOMER info source will contain data related to customer and attributes like customer number, address, phone no, etc.

> Operation Data Source is that which can over write the existing data in OSD.

The Types of Info Source are Transactional, Attributes, Text and Hierarchy.

The set of cubes delivered by SAP which is used to measure performance for query, loading data, etc it also shows the usage of aggregates and the cost associated with them.

The Independent structure created from Info source; which is independent of the source system or data source is known as communication structure.