Handling Demand Plan Dynamic PDS table in custom BI report — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Handling Demand Plan Dynamic PDS table in custom BI report

Received Response
17
Views
2
Comments

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!