Categories
- All Categories
- Oracle Analytics Learning Hub
- 19 Oracle Analytics Sharing Center
- 18 Oracle Analytics Lounge
- 232 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.9K Oracle Analytics Forums
- 6.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 87 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- 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