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).