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: AI Resources for Oracle Cloud HCM – Go Here

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

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!