Process data

The Process Data function can import data from a text file, or from a cube. It imports the data sequentially into the first row of a worksheet. You use different functions in the worksheet to read the first row and process the data in different ways. For example, if you use an AT.SET function, the information is sent to an attribute table. If you use the DBSET function, the data is sent to a cube.

When processing text files, the Process Data function reads each record from the file into the first row of a spreadsheet in sequence. It recalculates after each record.

When processing data from another cube, the Process Data function reads all the occupied cells in a cube area sequentially and displays them, as a record, in the first row of a spreadsheet. It recalculates after each record.

Note: You can use any Microsoft Excel functions to modify or convert the data as you are processing it.