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
Skip to content
  • Register
    • Get Started: AI Resources for Oracle Cloud HCM – Go Here

    Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

    Need Help Formatting Output in BI Answers

    edited Sep 25, 2017 6:45PM in Reporting and Analytics for HCM 1 comment

    Content

    I am in HR and am trying to write a report quickly without asking HRIS for help in the BI Answers section of the system. I was easily able to format the date to what I need, but need some help with the following:

    - How would I remove the dashes from the SSN output field?

    -How can I change the output name of a field (Ex. Male = M and Female = F) or (Single = S, Divorce = D)

    - Can I add cell output limits (ex. Address 1 can only has a 30 character limit, state can only be 2 digits, etc).

    If this would be something better left to the HRIS professionals, please let me know! I could always edit this in excel after the fact, but I am trying to limit the manual interventions as much as possible. Any help would be greatly appreciated!

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

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