Handling Demand Plan Dynamic PDS table in custom BI report

Summary:

Handling Demand Plan Dynamic PDS table in custom BI report

Content (please ensure you mask any confidential information):

Hi Team,

We are building custom BI report to get the forecast data from PDS table in demand plan which is dynamic in nature i.e., table name is different for each plan for various granularity IDs. since this is not static in nature, we thought to hard code these table name values in our custom report query. But the challenging part here is, when we create a new plan in production/lower instance or migrate the reports between 2 environments we need to modify our data set query and harcode correct PDS table with respect to that instance and plan everytime. So to