On this page
AX2078
Once you have configured an Axiom query, you can preview the data to be returned, using the Preview Axiom Query Data button on the Sheet Assistant.
The preview is a flat view of the data as it exists in the database. The intent of the preview is to confirm that you are querying the intended set of data, at the intended sum level, before it is inserted into a sheet. For example, if the query returns 200 records of data when you are only expecting 50, then this may mean that the sum level of the query needs to be adjusted, or that the data filter is not set as intended.
The entries in your field definition are used to determine the columns of data returned. Column filters and other special field definition settings are honored for this purpose.
NOTE: If the Axiom query uses a system table as the primary table (such as Axiom.Aliases), then the preview displays all columns of data in the table. Field definition row entries are ignored.
Only settings that impact the data query itself are honored by the preview. For example, the Axiom query data filter is applied, but any data range filters are not.
AX2078
|
Get more information and training resources: www.kaufmanhall.com |
Was this topic helpful? preview_axiom_query_data.htm |
