4 Dimension Table (Kind of UDT) in fusion HCM
We are having a requirement to create some kind of 4 dimension table on the system to maintain the below details as the ticket amount will vary based on the Ticket Route, Class, Type:
- Ticket Route i.e., DUBAI_RIYADH_DUBAI
- Ticket Class i.e., Business, Economy
- Ticket Type i.e., Infant, Child, Adult
- Ticket Amount i.e., 4000
The above details will be used for some calculations in the FF.
If someone has faced such requirement and was able to maintain such logic, Please let us know.
Sample of the table that we need to maintain:
Any inputs will be appreciated.