The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Manjinder_Singh's avatar
Manjinder_Singh
New Contributor
2 years ago

BI Blend : No valid Datakeys (Scenario/Time) found in Data Source

Hi,  I am practicing building a BI Blend report on Golfstream Application.  I was able to create a connection to the external database i.e SQL Studio, make the config changes in Onestream Database ...
Analytic Blend
JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
2 years ago

BiBlend fetches data from datasources in the same way an Import step would do. What you're seeing is not a blend problem as much as a generic DataSource / Transformation issue: none of the valid records generated by the datasource, after transformation, actually points to Scenario Actual and Time 2011M1.

You might get some information by looking at the log (clicking on the gear-in-document icon on the Blend toolbar, and selecting to open the file with Notepad - not Excel!).

Generally, I'd suggest to test datasources with a simple Import step in a separate Scenario, since you get to see what the records end up looking like. Then wire the Datasource to Blend steps once you're sure they will generate "good" records.