SAP Knowledge Base Article - Public

2324813 - About Data Limitations

Symptom

About Data Limitations

Environment

  • SAP Roambi Cloud

Resolution

When importing your data to create Roambi Analytics, it is important to keep the following limitations in mind.

 

Data Type Limitations

Type Limitations
Excel
  • Does not import Microsoft Excel formulas (imports data values only).
  • Chart objects are not imported. However, the table data used to create a chart is imported.
  • Does not support dynamic pivot table reporting. You must create a separate Roambi View for each pivot table summary.
CSV
  • Cannot import merged columns. Merged columns are always interpreted as individual fields.
TXT
  • If you import a crosstab table, you will typically need to manually add labels from the first-level header rows to your report using Roambi Publisher.
HTML
  • If you publish Microsoft Excel crosstab data to the HTML format using the Save As command, Roambi Publisher will interpret imported numerical values as text and group data cannot be charted.
   

 

Data Source Limitations

Source Limitations
Computer
  • The Refresh Data option is not supported when uploading files from your computer.
Library
  • Moving or deleting a data source file after publishing a Roambi report (*.rbi) file will break the link between the data source and *.rbi file.

 

Data Size Limitations

The maximum file size for file uploads and imports is 40 MB.

Keywords

Analytics Publisher Import Data Limitations Roambi , KBA , BI-ROM-CLD-PUB-BI , Roambi Cloud publishing clients – BI, Cognos & SSR , How To

Product

SAP Roambi Cloud all versions