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.
