Dynamic Column and Parameter Header Translation

You need to use Dynamic Column Translation Rules . This feature allows for the dynamic translation of both report header column names and parameter names based on custom rule SQLs . For your GL example, the rule SQL would reference the selected ledger parameter to query the Chart of Accounts structure and dynamically return the column name alongside its corresponding translated prompt .

The output of a Dynamic Column Translation rule SQL must contain exactly two columns . The first column must return the original column or parameter name (the key to be translated), and the second column must return the desired translation text .

The dynamic translation rules are applicable to both parameters and header columns within the report . This allows you to present a completely customized user experience, where the parameter prompts themselves reflect the terminology relevant to the selected organizational context (e.g., Ledger or Operating Unit) .

If you are using dynamic translation rules, you must ensure they are included in the migration package . You would use the generic export function `XXEN_API.EXPORT_FILE_DATA` and specify the `p_type` parameter as ‘Dynamic Column Translation Rules’ , or include them when exporting the report by checking the appropriate box in the user interface .