Summary


This article describes the various formats available for content publishing. Format options will vary based on source document type.



Format Matrix


Formats vary based on document type or query.



Web Intelligence
Universe Query
Crystal Reports
Tableau Workbook
SSRS
Database Query
Excel
Description
PDFX
XXX


Excel (.xls)X
X
X

BusinessObjects only supports .xls format for Crystal

Excel (.xlsx)X

XXX

Excel Data (.xlsx)X
X



Data only. No formatting.
Excel CSVX
X
XX

BusinessObjects does not support report-level CSV. InfoBurst extracts Excel and converts to CSV.

Excel CrossTab (.xlsx)


X


Burst-level only. Not available in Workflow.
CSV


X



PowerPoint


X


Workbook-only. No View support.
HTMLX


XX

PNGX
XX


Image file
Plain TextX





Report-level text with formatting
Data Provider CSVX





One CSV file per data provider
Tableau HyperX
X



XXUniverse Query is Workflow-only
Tableau Packaged WorkbookX





Requires TWBX to embed
Power BI DatasetX
X



X
X
Workflow onlyUniverse Query is Workflow-only
NativeX
X



Web Intelligence: .wid
Crystal Reports: .rpt



PDF


  • Content Password (optional): Supply a password to protect the file. This option provides password protect and not encryption.
  • Select Use Macro to supply customized password(s) using the Extra Column macro.
  • Split Report Tab(s)/Split View(s): Select and publish individual report tabs or views
  • Recombine: Select this option to combine the selected report tabs into a single PDF
  • View Selection (Tableau Workbook only): Select view or views to be published as PDF


Print Options


Available when Destination is Network Printer.

  • XOffset: Select an XOffset value
  • YOffset: Select a YOffset value
  • First Page: Select first page to print
  • Last Page: Select last page to print
  • Options: Enter one or more print options



Excel (.xls) / Excel (.xlsx) / Excel Data (.xlsx)

  • Content Password (optional): Supply a password to protect the file. This option provides password protect and not encryption.
  • Select Use Macro to supply customized password(s) using the Extra Column macro.
  • Split Report Tab(s): Select and publish individual report tabs or views
  • Recombine: Select this option to combine the selected report tabs into a single document 


Extensions


Select the + icon to add one or more Excel Extensions.



Excel CSV


Publish report-level CSV.
  • Delimiter: Select delimiter
  • File Extension: Specify file extension
  • Suppress Headers: Check this option to omit column headers from resulting file
  • Quote Character: Specify a string quote character
  • Remove byte order mark (BOM): Select this option to omit the BOM from the resulting file
  • Keep data formatting: Select this option to retain report-formatted values (all values returned as STRING). Disable this option to return raw data formats (STRING/DATE/NUMBER).

Requirements


Report-level CSV is not a supported format by BusinessObjects. To produce CSV, InfoBurst extracts Excel and converts to CSV. CSV formatting can be influenced by use of report-level formatting in the BI report. To avoid unused space in the resulting Excel which can influence CSV formatting, we recommend the following:

  • Original report table must contain column headers
  • Original report table must not contain duplicate column headers
  • Margins are minimized (0px)
  • Report HEADER and FOOTER are disabled
  • Report table block is aligned to top and left edge of report (0px)
  • Report table(s) must have a header row



Excel CrossTab


Publish Excel CrossTab format from Tableau Workbook. Tableau Server does not support filtering for this format.


  • Content Password (optional): Supply a password to protect the file. This option provides password protect and not encryption.
  • Select Use Macro to supply customized password(s) using the Extra Column macro.
  • Select View(s): Select view(s) to publish 
  • Recombine: Select this option to combine the selected views into a single document 


Extensions


Select the + icon to add one or more Excel Extensions.



PowerPoint


Publish PowerPoint from Tableau Workbook. Tableau Server only supports workbook export (no views) and does not support filtering for this format.



CSV


  • Select View(s): Select view(s) to publish



HTML


  • Split Report Tab(s): Select and publish individual report tabs

Database Query


Formatting of HTML output from a database query can be customized by editing the DBQry_Table.css file located in the InfoBurst application root folder (default = C:\Program Files (x86)\InfoSol\InfoBurstPlatform).



PNG


Recommended for mobile devices.

  • Page Range (optional): Specify range of report pages to render as PNG image. Leave blank if the range of pages is variable.
  • Image Width (optional): Specify image width (pixels)
  • Image Height (optional): Specify image height (pixels)
  • Split Report Tab(s)/Split View(s): Select and publish individual report tabs or views


Select Destination tab and Attach option to attach image file to email message.



Plain Text


  • Delimiter: Select a delimiter
  • File Extension: Specify file extension
  • Split Report Tab(s): Select and publish individual report tabs



Data Provider CSV


  • Delimiter: Select delimiter
  • File Extension: Specify file extension
  • Quote Character: Specify a string quote character
  • Suppress Headers: Check this option to omit column headers from resulting file
  • Remove byte order mark (BOM): Select this option to omit the BOM from the resulting file
  • Select Data Provider(s): Select and publish individual data providers



Tableau Hyper


  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab(s): Select and publish individual report tabs
  • Select Data Provider(s): Select and publish individual data providers
  • Warn if empty (do not create): Select this option to prevent delivery of an empty Hyper file



Tableau Packaged Workbook


  • TWBX To Embed: Select a TWBX file
  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab: Select report tab data to use



Power BI Dataset


  • First Row Headers: Un-check if first data row is not column headers
  • Select Report Tab(s): Select and publish individual report tabs
  • Select Data Provider(s): Select and publish individual data providers
  • Warn if empty (do not create): Select this option to prevent delivery of an empty Data


Data Limits


Power BI Server limits the volume of data which can be published to a dataset. See the following Microsoft article for details:

https://docs.microsoft.com/en-us/power-bi/developer/automation/api-rest-api-limitations