Forum Discussion

JérémyRenard's avatar
JérémyRenard
New Contributor
24 days ago
Solved

No valid DataKeys (Scenario / Time) found in data source.

Hello everyone,

I'm trying to create my first import from scratch.

Unfortunately, it always gives me the same error :

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.

And no line is imported or displayed in the logs.
However, I've gone down each parameter and everything seems correct and consistent with what I have on other import files.

Could you help me investigate?

My settings :

All the UD1 to UD8 are on None.

And the log :

 

  • MarcusH's avatar
    MarcusH
    23 days ago

    The Data Structure Type on the Data Source is set to Matrix Data. As you are loading one period of data this should be set to Tabular Data. 

    The log file has the line: Matrix Lines Read.....  0 

6 Replies

  • DanielWillis's avatar
    DanielWillis
    Valued Contributor

    Can't see Time in your screenshots. Did you do Current Datakey Time like you did with Scenario?

    • JérémyRenard's avatar
      JérémyRenard
      New Contributor

      Hello Daniel,

      Absolutely.
      I have set Current DataKey Time.
      I put the Time screenshot at the bottom of the scenario screenshot.

      I plan to create a column per UD in the import file, as is already the case for the account, the amount and the entity, and thus see if this corrects the problem.

      If it still doesn't work, maybe I can investigate elsewhere?

      Then, if it works, I'll delete the UD columns one by one and hope to see which one is not set up correctly when it's no longer in the import file.

  • MarcusH's avatar
    MarcusH
    Valued Contributor

    The error is saying that there is a missing scenario and/or time target member. That means either the data source is wrong (and it looks OK to me) or the transformation rules for the scenario / time member is missing.

    • JérémyRenard's avatar
      JérémyRenard
      New Contributor

      I've read that this message is generic and that the problem could come from any manage profil member.

      My manage profil member is exactly the same as other import profiles which work perfectly.

      I've created a new csv import “;”
      I've assigned each column to a dimension
      The scenario/time member transformation rules reflect the data in the import file and yet my file doesn't import and I have no explanation for the anomalies :(

      My settings:

       

      • MarcusH's avatar
        MarcusH
        Valued Contributor

        The Data Structure Type on the Data Source is set to Matrix Data. As you are loading one period of data this should be set to Tabular Data. 

        The log file has the line: Matrix Lines Read.....  0