cancel
Showing results for 
Search instead for 
Did you mean: 

excel file as datasource

Former Member
0 Kudos

Hi expert,

     How to use local excel file as data source for SAP DS? I don't want use universe and bw.

Many Thanks,

Bo

Accepted Solutions (0)

Answers (1)

Answers (1)

TammyPowlas
Active Contributor
0 Kudos

You can use CSV as a data source - see

If you want to use Excel you can check the SDK extensions

Former Member
0 Kudos

I create metadata file as follows, but still get error "Cannot load InfoProvider "local/ZB_TEST2\test.csv" (data provider "DS_1": Exception occurred during creation)" when trying for initial view.

<<BEGIN OF METADATA>>
<<BEGIN OF PROPERTIES>>
DESCRIPTION;"BUD0131 - IDC / IDR Summary Report"
VERSION;"1"
<<END OF PROPERTIES>>
<<BEGIN OF ROLESUPPORT>>
Role;"Name";"Description";"Field";"Referenced Characteristic";"Presentation";"Data Type";"Aggregation Mode"
CHARACTERISTIC;"St#";"St#";"1";"";"LONG_TEXT";"STRING"
KEYFIGURE;"Days On Market";"Days On Market";"2";"";"VALUE";"DOUBLE";"SUM"
<<END OF ROLESUPPORT>>
<<BEGIN OF FORMAT SETTINGS>>
TYPE;"VALUE"
GROUP SEPARATOR;"
DATE FORMAT;"M/d/yy"
DATE TIME FORMAT;"M/d/yy h:mm a"
STANDARD TIMEZONE;"America/New_York"
<<END OF FORMAT SETTINGS>>
<<END OF METADATA>>
Former Member
0 Kudos

when I create datasource for the excel file, the excel file and metadata file are automatically loaded into application folder.

TammyPowlas
Active Contributor
0 Kudos

Please see Karol's post

Former Member
0 Kudos

Thanks, it works