Create a Connector Data Source which you add to your WF. That specifies a Connector Business Rule to execute which returns the data table containing your data.
The BR has 2 sections you need to fill in: GetFieldList and GetData. And then you need to specify the ProcessData command - you might build the return data table using SQL or through script. This post has a bit more info:
I tried the above , data is returned from the custom table ,But am getting the below error in the transformation rule even though i have the year 2024 and Forecast_Working in the TR.
Summary: No valid DataKeys (Scenario / Time) found in data source. Review the source data load processing log and check one-to-one transformation rules to ensure that you have created proper Scenario and Time dimension rules for this data source.
That error means that the import process cannot identify what scenario and/or time period the data should be imported to. You have either not included the Scenario and/or Period in the source template or you have not added the Transformation Rules for the Source Scenario and/or Period.
It is always better to look at the xfl file from here.
That will give you a better idea on what is going on.
