Web reporting by CSV or TSV PivotData Microservice Documentation

Microservice settings are specified in the appsettings.json file.

Cube config for SQL database should have 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 working dir */ 
    "Type": "Csv"  /* possible values: Csv, SerializedPivotData */

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