You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to get Total Compensation Statement values through a BI Report

Received Response
104
Views
7
Comments

Summary:

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.

CMP_TCS_STMT_CAT

CMP_TCS_STMT_VL

CMP_TCS_CAT_VL

CMP_TCS_PER_PERD_STMT_XML

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!