Help get this topic noticed by sharing it on Twitter, Facebook, or email.

Has anyone developed the SQL to reproduce Forecasts data?

Has anyone written the SQL to recreate the Forecasts reports (revenue forecasts)?

I'm having a hell of a time traversing the Hierarchy and determining when a value should be ignored because of an override at another level.
And conversely, I see override records but their values do not match what I see in the SFDC Forecasts detail.

I'm attempting to automate an elaborate Excel document and they are currently manually copying the Enterprise Forecast Extract report data into a sheet. So I need to have a query that produces the same result.
1 person has
this question