Oracle Transactional Business Intelligence

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Subject Area -- Custom Column Formula Issue

Accepted answer
25
Views
2
Comments

We have an analysis built off of "Workforce Management - Accrual Real Time" joined to "Workforce Management - Work Relationship Real Time."

Results return on a data table, but when trying to build out a chart, two of the columns fail. This is the first time I've encountered such an issue. It appears that something in the custom formula is causing the results to balk.

Additionally, I used the Logical SQL to build a data model in OAC. The data profiled and previewed without issue, but when I pulled into a new workbook, it was not accessible. When commenting out the two columns, there was no issue.

I'm attaching the SQL here and would appreciate any advice or input.

Best Answer

  • John Hung-Oracle
    Answer ✓

    Hi, To better serve you, I have moved your post to the Reporting and Analytics for HCM forum since its specific to HCM subject areas/use cases. Thank you.

    Moved to: https://community.oracle.com/customerconnect/discussion/819263/subject-area-custom-column-formula-issue

Answers