Web pivot tables by CSV Data Source Setup
Microservice settings are specified in the
appsettings.json
file.Cube config for CSV file should have "SourceType": "file"
and additional "SourceFile" section:
{ "Id": "AdventureWorksOrdersCsv", "Name": "Adventure Works Orders (CSV)", "SourceType": "File", "SourceFile": { "Name": "App_Data/adventure_works_order_details.zip", /* relative path is resolved to microservice work dir */ "Type": "Csv" /* possible values: Csv, SerializedPivotData */ }, "InferSchema":true }
CSV file separator (comma, semicolon, tab) and file encoding are determined automatically. Data file may be compressed with Gzip or Zip (if zip contains several files only first one is used).