How can I display the rate from the rate table in OTBI for Incentive Compensation?
Here's how you can display the rate:
In the Incentive Compensation Attainment Real Time and Incentive Compensation Rate Table Real Time subject areas you can create a Business Intelligence Publisher (BIP) report with query to get the rate tiers and values with filter on the rate table name from the earnings table.
The Rate Percentage field is the COMMISSION_VALUE column in the CN_RATE_TABLE_VALUES_ALL table. The tiers and sequence for a particular dimension are stored in the CN_RATE_DIM_TIERS_ALL table.