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 convert State Code into State name in BI Analysis

Received Response
edited Aug 18, 2017 9:15AM in Reporting and Analytics for HCM 7 comments


Convert 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.


Howdy, Stranger!

Log In

To view full details, sign in.


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