EPBCS - WFP - Security employee dimension - till top most manager

Hi Team

in an EPBCS, custom WFP cube, we need to implement security on Employee dimension.

The requirement is that the employee level data should be visible to their managers upto the CEO level.

We have built a flat file integration into EPM for employee dimension (Extract via HCM cloud).

Now, how to build this complex security via excel sheet, where we need to identify 10 levels of manager for each employee, someone could just have 1st level of manager, while few employees could have 10 level of managers.

we were thinking of doing this in excel sheet using vlookups and assigning security via EPMAutomate or importsecurity.cmd from that excel.