Project OBS
Project OBS is a parent-child tree structure that can include 99 levels in Infor LN. In Birst, the tree structure is limited to 15 levels. It is a flattened structure and the tree can be formed using drill maps in Birst Visualizer. The tree displays the OBS elements and the linked activities.
This table shows the LN tables from which fields are retrieved for the dimension:
| Table | Description |
|---|---|
| tppdm096 | User Defined Structure elements |
| tppdm600 | Projects |
| tppss200 | Activities |
| tccom001 | Employees - General |
This table shows the attribute mapping to LN table fields for the dimension:
| Attribute | Mapping |
|---|---|
| Actual Structure Element Flag | 1 if actual structure element, else 0 |
| Current Hierarchy Level | Indicates the level no. of the OBS element |
| Company | tppdm096.compnr |
| Hierarchy Max Level | Indicates the max no. of levels |
| OBS Element | tppdm096.coel |
| OBS Person Name | tccom001.nama |
| Object Type | OBS if OBS Element else Activity |
| Organization Breakdown Structure | tppdm096.cobs |
| Parent Structure Element | OBS Element or Activity |
| Project | Retrieved based on tppdm600.cobs |
| Project Activity | Retrieved based on tppss200.coel |
| Project OBS Level01 | tppdm096.coel |
| Project OBS Level01 ID Desc | tppdm096.coel + tppdm096.dsca |
| Project OBS Level02 | tppdm096.coel or tppss200.cact |
| Project OBS Level02 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level03 | tppdm096.coel or tppss200.cact |
| Project OBS Level03 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level04 | tppdm096.coel or tppss200.cact |
| Project OBS Level04 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level05 | tppdm096.coel or tppss200.cact |
| Project OBS Level05 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level06 | tppdm096.coel or tppss200.cact |
| Project OBS Level06 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level07 | tppdm096.coel or tppss200.cact |
| Project OBS Level07 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level08 | tppdm096.coel or tppss200.cact |
| Project OBS Level08 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level09 | tppdm096.coel or tppss200.cact |
| Project OBS Level09 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level10 | tppdm096.coel or tppss200.cact |
| Project OBS Level10 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level11 | tppdm096.coel or tppss200.cact |
| Project OBS Level11 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level12 | tppdm096.coel or tppss200.cact |
| Project OBS Level12 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level13 | tppdm096.coel or tppss200.cact |
| Project OBS Level13 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level14 | tppdm096.coel or tppss200.cact |
| Project OBS Level14 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Project OBS Level15 | tppdm096.coel or tppss200.cact |
| Project OBS Level15 ID Desc | tppdm096.coel or tppss200.cact + tppdm096.dsca or tppss200.desc |
| Structure Element | Linked Activity or Parent OBS element |
| Structure Element Desc | Linked Activity desc |
| Structure Element ID Desc | Linked Activity ID Desc or Parent OBS element ID Desc |
| Structure Element Type | tppss200.tact |
| Unknown | 1 for null records, else 0 |
| deleted | 1 if deleted in LN, else 0 |
| Customer Defined Fields | Standard list of fields |