How do I create an analysis that pulls most of the fields on the Element summary screen?
When creating an analysis, the analysis either drops records or stops returning any records after adding certain fields that may not contain any data. I am currently running into this issue when trying to create an analysis to show ALL payroll elements and their setup information. Pulling this information using a BI Publisher report is a lot more complicated, so I would really like to use the "Payroll - Element Entries Real Time" subject area.
My analysis needs to show all of the the configuration data that is shown on the Elements Summary screen (Navigation: Payroll > Administration > Payroll Process Configuration > Elements) in Oracle. I thought I could pull the data from the Element object under the Subject Area named "Payroll - Element Entries Real Time". However, as soon as I include the field named "Category", the analysis drops all elements that have a blank in this field, and my analysis needs to show the setup information for ALL payroll elements, even the ones that don't have anything in the Category field. There are not