Are you using something like Power BI? If so you can use the Project Portfolio Dashboard as a base. It has several of SQL queries used by the dashboard. I’ve modified the Financial Facts table to include a few other versions that we are capturing and generate reports based on that.
@Thbutler No, I am not using PowerBI. Yes, if its PowerBI there are different ways to get that. This one I am talking directly in the SSRS report. I am referring different SQL queries. Worst Case, I will have to do the math myself to calculate based on the conditions around the data which can be retrieved from the financial data cube.
I ran into the same issue writing a query for a customized tile. Following to see what responses you get to this question. Thanks!
The success center has documentation on the database schema (https://success.planview.com/Planview_Portfolios/Analytics_and_Reporting/Database_Schema_Guide) that might help you. You can also test your queries by going to Administration → Reporting → Dataset Management. This will allow you to run SQL queries against the backend database.
Hi Sakhti,
here is an example of a query you can run against your db:
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
select
structure_code as ppl_code,
C1125 as Costs_At_Complete_Baseline
, C1011 as Costs_At_Complete_Forecast
, C1105 as Total_Benefits_Baseline
, C1013 as Total_Benefits_Forecast
, C1126 as NPV_Baseline
, C1131 as ROI_Baseline
, C1134 as IRR_Baseline
, C1127 as NPV_Forecast
, C1132 as ROI_Forecast
, C1135 as IRR_Forecast
, C1128 as NPV_Variance
, C1133 as ROI_Variance
from vw_fm_columns_plan
Please adjust the codes based and have a look. Hope it helps 
Best,
Michal
Thank you @mserafinowski