Forum Discussion

wm2's avatar
wm2
New Contributor
6 months ago

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

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!

Application Properties
  • DanielWillis's avatar
    DanielWillis
    Valued Contributor
    6 months ago

    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's avatar
    MarcusH
    Contributor III
    6 months ago

    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.

  • Kamila's avatar
    Kamila
    Contributor
    6 months ago

    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's avatar
      wm2
      New Contributor
      6 months ago

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

       

      • Kamila's avatar
        Kamila
        Contributor
        6 months ago

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