AX2054
Axiom queries can be used to update and/or insert data into a sheet. Using an Axiom query, you define:
- The set of data to be queried from the database, by completing data query settings on the Control Sheet
- The placement of that data on the target sheet, by placing database column names on a reserved row (or column) in the sheet, and by defining data ranges where records will be inserted and/or updated
- The formatting and any additional formulas to be applied to each inserted record of data, by using the calc method library or an in-sheet calc method
- How data should be updated when data refreshes are performed, by completing the update settings on the Control Sheet
Axiom queries can be used in any Axiom file, but are most likely to be used in templates/plan files and report files. In templates, Axiom queries are typically used to dynamically populate the plan file with the data relevant to each individual plan code. In reports, Axiom queries can be used for any data query. While Axiom queries are well-suited for data that needs to adjust dynamically, they can also be used for configurations that are static in nature (update-only queries).
