How to convert State Code into State name in BI Analysis
SummaryConvert state code into description using subject area or table.
I am building an analysis to get some information from a Person's payroll run results subject area. I am able to filter a certain element and 'input value name' and returning the run result value. But the run result value is returning as code instead of description.
In my case I am looking for state name as 'GA' but the analysis returning code as '11'.
So is there another subject area where i can join and get the description or should i refer a lookup table. If there is no subject area then what is the exact table name having state code and description in HCM.