Forum Discussion

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

Format for a Data Adapter/Method Query using an Excel file

Originally posted by Lawrence Manekin Hi, Working on a POC for a client.  To get data in quickly, I uploaded an Excel document so I can run a pivot off of it.  The Excel is in the public folder. ...
Dashboards
TonyToniTone's avatar
TonyToniTone
Icon for OneStream Employee rankOneStream Employee
5 years ago

The File Source Types are defined as:

1.  Dashboard - This option displays a file stored in a Dashboard Maintenance Unit File section 

2.  Application -  This option displays a file stored in the XF Application Database storage location

3.  System -  This option displays a file stored in the XF System Database storage location

4.  File Share -  This option displays a file from the XF File Share storage location

 

Without seeing the full error message, the possible solutions for the invalid error are:

1.  Verify that the File Source Type is pointing to where the Excel file resides in the File Explorer

2.  Verify that the Folder Path and File Name exactly match where the file is stored in the File Explorer

3.  Verify that Excel Worksheet Tab is correct

4.  Verify that the Named Range from the Excel file is defined correctly