Auto populate child under the specified parent logic in FCGL
Dimension member/COA for cost center dimension | |||
---|---|---|---|
Within Cost Center Main viewpoint for FCGL | |||
Name | Company Code Property | ||
Parent | Dummy | ||
Child | 13275 | 1001 | |
Child | 13276 | 1001 | |
Child | 13209 | 1005 | |
Child | 21063 | 1005 | |
From this view, need to create an alternate hierarchy for Cost Center to Company mapping through subscription request, such that the company code property will become parent with suffix C and all mapped cost center will be rolled up under the parent | |||
Alternate Hierarchy View will be like this | |||
Parent | C1001 | ||
Child | 13275 | ||
Child | 13276 | ||
Parent | C1005 | ||
Child | 13209 | ||
Child | 21063 |