I am specifically referencing Ad hoc reporting when I write this, as I use Ad hoc to report from the DWH tables -- not writing a query.
all the DWH tables are posted in the documentation.. it is a large Excel sheet.. have you seen that and you don't see your desired fields? If so, remember that not all fields were put into the DWH. (Advanced reporting domain field descriptions) or if you have not, this link has the different versions: CA PPM Advanced Reporting and Database Schema Index - CA Technologies if you are indeed trying to write a query, then that may help???
to use an Ad Hoc (if you build the Ad hoc, you can then get the query using the View SQL query button)
Example:
Using the project domain, the fields (top section) > calendar periods: you would use Month Start, for example, as a filter and a row (assuming crosstab).. Filter on is between Month and Month + 6 to get the current month + 6 month view, for example
under the measures (the bottom section) > calendar periods> you have various measure choices.
You may need the financial domain, but I haven't played with that one enough to know what it all can do.
if it help, Rego has done several really good google hangout/webinars that you can view as well. You can google it and you can find them all.
Sorry if I am not helping.. just trying to give some other avenues to use to perhaps get the information you are seeking.