Hello, Has anyone had this error message "No valid DataKeys (Scenario/Time) found in data source". I received this message when importing a "text" file through the workflow. Once import is selected and is at 94% complete prior to validation. I have checked on Scenario & Time to make sure it is proper. I need help on how to fix this.
Welcome to one of the most unintuitive error messages in OneStream. This is essentially returned when there is no data returned from the data source. I think one of the most common issues is it doesn't like the amount column. Usually you can click the two icons to the right of the 'Complete Workflow' button to find out why records are getting rejected. One of them will show your data and an error code to the left of it with a legend of whta the error codes are at the top.
You get this error if you do not have a Scenario or Time transformation rule for the current period. You will also get it if the import data step is not importing any data. As DanielWillis says check the import log and log for suppressed rows. As a check you can set Zero Suppression on the Amount field in the data source to False. If you have any Attribute Value dimensions on the data source, their suppression must also be set to False.
