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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Add a Column with a Static Value in OTBI

edited Sep 14, 2020 6:04PM in Reporting and Analytics for HCM 5 comments

Summary

Trying to add the same value to all records, i.e. add a dummy column that holds a static field

Content

In OTBI, I need to add a column to a report that doesn't necessarily need to come from the application. I need to add a field so that each record has the same value in the column, i.e. in this example below called status. 

I have even tried to hijack another field and tried to use if not null, else {value}. but I don't see an If not null, and I can't figure out how to make the ifnull to be not(ifnull). Isn't there a way to just add a value to the entire report for each record? 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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