How to get Total Compensation Statement values through a BI Report
We are trying to build a BI Report to get the Total Compensation Statement values which are defined in the system. We need to fetch the details in a Tree structure (Statement -> Categories -> Sub Categories -> Items) same as defined in the system.
We tried below tables to get the Statement and Categories details. But we are not able to fetch the Categories which are linked under the Statement as defined in frontend.
Please let us know if there is a way to find which categories are tagged under which Statements and which Items are tagged under which Categories through BI Report.