Error: No valid DataKeys (Scenario / Time) found in data source. Review the source data load process

[wm2]

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!

[Kamila]

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.

[wm2]

I tried to create these 2, do you think they are correct?

[Kamila]

I think so, did you add them to the workflow profile? I mean you first need to have a Rule Profile within Transformation Rules

[wm2]

i have this in the profile, but that still will not work. heres the workflow profile as well

[DanielWillis]

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

[MarcusH]

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.