Skip to main content

Hi Experts,

I know how we can access the different financial versions and values present in them. I am interested in reading the Financial Subtotals value. I understand that they are virtual columns. Is there a way we can access through SQL Query?

This is for Planview portfolios.

 

Thanks

Sakthi.

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.


Reply