on 05-02-2016 9:22 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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>> |
User | Count |
---|---|
84 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.