Notitie
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen u aan te melden of mappen te wijzigen.
Voor toegang tot deze pagina is autorisatie vereist. U kunt proberen om mappen te wijzigen.
| Enabled for | Public preview | General availability |
|---|---|---|
| Users, automatically | - | 
Dec 1, 2024 |
Business value
You can create reports and do ad hoc data analysis on transactions from fixed assets, projects, and service management. You can group, summarize, and pivot data to get the insights you need without running a report.
Feature details
In 2023 release wave 2, we introduced the ability to do data analysis on an AL query. Now, 2024 release wave 2 has out-of-the-box queries that make ad hoc analysis easier for fixed assets, projects, and services.
- The query for fixed assets is available in version 25.0.
- The query for service management is available in version 25.1.
Many of the first examples are ledger entry tables, such as fixed assets ledger entries or project ledger entries, joined to relevant tables. Typically, these relevant tables are the tables where a code field on the ledger connects to other tables. By adding extra fields, you enrich the analysis scenarios that people usually do on ledger entry list pages.
Example: fixed assets ad hoc analysis
The fixed assets ad hoc analysis query combines data from fixed asset ledger entries with data from master tables, such as the Fixed Asset, Fixed Asset Class, Fixed Asset Subclass, Fixed Asset Location, and Depreciation Book tables. When you open the query, you can explore and analyze data about fixed assets in any way you want. The following image shows the available options.
