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.
It is always better to look at the xfl file from here.
That will give you a better idea on what is going on.
