Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
| 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.
Geographic areas
Visit the Explore Feature Geography report for Microsoft Azure areas where this feature is planned or available.
Language availability
Visit the Explore Feature Language report for information on this feature's availability.