07-02-2024 12:55 PM
Hi!
Ok here is my data:
Here is my data sources:
Here is my application properties:
If I have Global DataKey Scenario on for both Scenario and Time in Data Sources, why am I getting this 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
When I try uploading? Does anyone know if I need a transformation rule and what that would be?
Thank you!
07-02-2024 03:13 PM
Hi,
I remember I had a similar issue in the past when transformation rules was missing.
Try to create One-To-One rules for Scenario and Time, it helped me.
07-02-2024 03:15 PM
I tried to create these 2, do you think they are correct?
07-02-2024 03:19 PM
I think so, did you add them to the workflow profile? I mean you first need to have a Rule Profile within Transformation Rules
07-02-2024 03:22 PM
i have this in the profile, but that still will not work. heres the workflow profile as well
07-02-2024 07:05 PM
You will get this error when there are no valid rows to load. You can view a report of why rows were considered invalid if you click the button I've circled in the screenshot below. It is a little cryptic but each row has a number before it and there is a legend detailing what the numbers (log codes) mean at the top
07-04-2024 07:43 AM
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.