Need to build an analysis report of all pay periods that exist to date

Summary:

I'm trying to build an analysis in OTBI that brings me all of the pay period names and dates for all Consolidation Groups in a Legislative Data Group. This is to help identify how far in the future pay periods have been created for each group as well as the payroll dates associated so that they can be reviewed to adjust for pay days that fall on stat holidays.

Based on some direction found online I am using subject area 'Payroll - Payroll Balances Real Time'. I can either get information from the 'Payroll' folder fields or I can get data from the 'Payroll Period' fields but as soon as I try and get information from both my results drop to nothing.