Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
Subject Area -- Custom Column Formula Issue
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
-
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
0
Answers
-
Thank you @John Hung-Oracle , I wasn't certain if it would fall under that forum.
0