Exporting cubes to a text file

With OLAP you can export cubes as records. An exported cube creates an ANSI text file. The system offers a selection from which you can select the corresponding delimiter. The text file contains one value per record. The records each have one field per dimension of the exported cube where the corresponding value is listed in the last field. You can also specify the decimal separator. You can also export dimensions.

See Exporting dimensions as text.

To export a cube as text file:

  1. Click Cubes in the Database group on the ribbon.
  2. Select the cube to export.
  3. Click Export.
    By default, exports are saved in C:\Users\Public\Documents\Infor\BI\OLAP\. To specify another location, click Search next to the File field.
  4. Select a delimiter and click OK.
    Note: The delimiter and the decimal separator must not be the same.