Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
How to convert State Code into State name in BI Analysis — Cloud Customer Connect
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
58
Views
7
Comments
edited Aug 18, 2017 9:15AM in Reporting and Analytics for HCM 7 comments

Summary

Convert state code into description using subject area or table.

Content

Hi,

       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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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