We have to build forecast hierarchy based on columns from multiple objects, is there a way to build it.
When I tried creating a Forecast on a View object, I got the below error,
Error "42809: referenced relation "UsrSalesPersonForecast" is not a table" occurred when updating schema structure. SQL script text: "ALTER TABLE "public"."UsrUsrSalesPersonForecastForecast" ADD CONSTRAINT "FK1BLqxq3nLaQIhH52szd47Se7eNI" FOREIGN KEY("UsrUsrSalesPersonForecastUsrPrimaryKey") REFERENCES "public"."UsrSalesPersonForecast"("UsrPrimaryKey") ON DELETE CASCADE"
Any suggestions are welcome...
Like
Currently the only possibility to build hierarchy in forecasts is by using connected objects from the columns of the original object in the forecast (by selecting them in the level of hierarchy directly):
As for the error message itself: a foreign key must reference a (base) table* in the same database (a base table: not a view, not a foreign data wrapper table) as stated here. In your case one of the columns is referencing a view so that's why the error message popups when updating the database structure.