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

Values Based on custom SQL

edited Apr 30, 2020 5:52AM in Reporting and Analytics for HCM 7 comments

Summary

Values Based on custom SQL

Content

I would like to display the Data for last 4 years based on data from initial setup.

Eg :  Need to display value 100 for each of the rows in 2017,2018,2019 and 2020. 

Able to bring the years , but the values are not getting displayed because , there are no values in 2017 till 2020. 

Data configured in System :

    Input Value  
Element Start Date 1-Jan-16 100  
Element End Date 31-Dec-12    
       

Data Should look like below :

2017 2018 2019 2020
100 100 100 100

 

If the data changes in any of the year, it should display the new value. 

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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