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

OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago

Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.

Originally posted by Michael Malandra 6/18/2018 Do we have a KB article on using Excel files as a source for an Import? I have formatting questions.
Data Sources
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
6 years ago
Originally posted by Chul Smith

It's the easiest data source - don't need to define any of the dimensions, just ensure that the Allow Dynamic Excel Load is TRUE and put in your xfd ranges in each tab. If you want each tab to be listed as a source, use the Excel formula to pull in the tab name for Source ID.