Need Ability to define controlling hierarchy for FCGL so inheritance can work
Description:
Currently inherited properties are not supported for FCGL applications because the properties are exported from a list view point.
With this idea you should be able to identify a "controlling" hierarchy view point for the FCGL dimension that will define the property value on the list view point.
Use Case and Business Need:
Account Type is the best use case for this. Since account type is typically set very high in the hierarchy and all descendants have the same value, inheritance is the best data governance method for managing this property. Doing this allows members to be added and a value based on the hierarchy location is determined by default. Then when there are contra accounts the data steward only has to manage these few exceptions.
Status:
Under Oracle Review
More details:
A simple drop down on the FCGL default view inspector could allow for the assignment of the "controlling" hierarchy view point for inherited properties.
Or, when defining a FCGL property as inheritable, you can have the hierarchy view point list drop down selection there.
Once the controlling hierarchy view point is defined, the values on the list view point for FCGL will be calculated from the controlling hierarchy inherited value.
