Table naming conventions

---

Cognos Planning – Contributor Administration Console



We use different table naming conventions for storing, loading, error statuses.

im_ this is used to store import data.
ie_ this is used to store errors occurred.
et_ this is used to store user entered data.
it_ system tables- used to manage items of d-lists/e-list
cy_ system tables- used to manage hierarchy of various d-lists/e-list.
sy_ system tables- used to manage hierarchy of various d-lists/e-list.

cy and sy both tables are different only in one aspect. sy contains 'leaf code' column also.

Source of Cubes

---

Cognos Planning – Contributor Administration Console


Data source of cubes

Data in a cube can be inserted by various sources. Mainly there are four sources-

1. Another cube

Data can be loaded through another cube. For data transfer d-links can be created mapping the fields which are to be mapped.


2. Admin links

These links are used to transfer data between cubes of different applications. They are created and managed in CAC under planning administration domain.


3. System links

These links are pull links and are run under Get Data functionality. These are used by users to pull data into web contributor.


4. Import data

When you're not able to find the data from any of the source above try finding it in import data folder under application model in CAC.