No Valid Data Keys in File.
How do you add a data key to a OneStream application?
Forum Discussion
Sorry, data keys in terms of scenario and time. This is the report I am receiving and the error message:
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.
Thanks wm2. You get this error when your file contains no data to be imported.
This is usually due to issues in your data source and/or transformation rules set up.
From the log I can see that you have 41 rows in your source file but none of them is correctly mapping to a valid intersection. I'd start by ensuring that you have the one-to-one mappings for the Scenario and Time set up correctly.
After a closer look, the log is actually saying that all lines are non-numeric which seems to point to an issue with the definition of your amount column?
If I was using global POV for time and scenario, would I still need one to one rules and what would those look like?
And I should be uploading from a CSV right?
Yes, the mappings for scenario and time are required even if using global POV.
Sure, the Delimited files sources accept the csv format.
I'd look into your amount column / definition as it seems to be resulting in a non-numerical value.
It was the amount column thank you so much
Last question, everything is working except for the view transformation rule
Do you know what the source value would be if the target value is YTD?