By Robin
It looks difficult, but it isn't at all.
This is a short summary, for business warehouse starters, and especially for any other consultant that, at any moment, need to know what represents a specific BW table.
It is simpler than expected.
The beginning is common for all the tables, just a little difference between 0 and C.
Once you ignore this, you have just to focus in a letter. Knowing which represents this letter, you are a BW expert!
In the following lines I will show the difference between 0 and C, and possible letters that you will find.
For all BW objects this is the general naming convention: * /BI0/Lxxx* - Standard /BIC/Lxxx - Customer defined where: + L+ - is the letter that will help us to distinguish quickly which kind of object is involved + xxx+ –is the name of the object. But it is important to know that: If object is a NON standard object then name will be just xxx
Now, let’s see how we can do the differentiation just based in the first letter after the /BI/
DSO* (Datastore Object) Active data /BI/A00
Activation queue
/BI/A /BI/B
* PSA (Temporary staging area) /BI/B
+ Note: Technically Change log are PSA are the same
+
INFOCUBE
| F-fact table (partitioned by request_ID) | /BI/F /BI/E |
| D-dimension tables | /BI/D* In dimension tables L* is a character that represents
each dimension. Possible values for L are: 1.P is the package dimension
of a content cube 2.U is the unit dimension of a content cube 3.T is the
time dimension of a content cube 4.I is the user defined dimension of a
content cube *
AGGREGATES* (partitioned as the cube!) F-fact table (partitioned by request_ID) /BI/F |
| E-fact table (partitioned by Year/Month etc.) | /BI/E *
TEMPORARY TABLES* /BI0/0<number> or /BI0/0D or /BI0/0P Please read these notes for further descriptions: 1139396 and 449891 * INFOOBJECTS /BI/P/BI/Q Stores Values of Time Dependent Atrtibutes /BI/T/BI/X Stores the SID Values for Time Independent Navigation Attributes /BI/Y/BI/S Stores the SID Values for Characteristic Key Values found in the P, Q or T table /BI/M/BIC/H”infoobjectname” - Hierarchy data of an infoobject |
