Standalone tables

In AX Server, a standalone table is the basic Analytics table layout in Analytics. Once an Analytics table layout is imported to AX Server, it is referred to as a standalone table to differentiate it from the other table types that AX Server supports.

Table structure

Standalone tables have a two-part structure:

  • the table contains the metadata that describes the structure of the source data file and appears in the Server Explorer of AX Client and Data Tables in AX Web Client
  • the source data .fil file contains the raw data records and does not appear in AX Client or AX Web Client

You can also import the table without its associated data file to create a standalone layout that can be manipulated in analytic scripts.

Tables usage

Standalone tables are the most basic table type in AX Server and are used to analyze the data in the underlying source file. Use the standalone table for direct analytic processing that does not require linking or sharing of data stored on AX Server.