Business Central 2023 wave 2 (BC23): Turn off data analysis mode on pages and queries (AnalysisModeEnabled Property and Allow Data Analysis Mode permission)

Hi, Readers.
The public preview for Dynamics 365 Business Central 2023 release wave 2 (BC23) is available. Learn more: Link.

I will continue to test and share some new features that I hope will be helpful.

Turn off data analysis mode on pages and queries:

Business value:
When first introduced, the data analysis mode was available on all list pages. However, for some list pages, using the data analysis mode doesn’t make much sense. In addition, in this release, it’s now also possible for users to analyze data that’s defined in query objects. With query objects, as with list pages, it doesn’t always make sense to use the data analysis mode. This is especially true with existing query objects, which were typically developed for a different purpose.

Therefore, we’ve made it possible for tenant admins and AL developers to turn off the analysis mode on list pages and query objects that aren’t suited for analytical usage.

https://learn.microsoft.com/en-us/dynamics365/release-plan/2023wave2/smb/dynamics365-business-central/turn-off-data-analysis-mode-pages-queries

PS: Analyze, group, and pivot data on queries using multiple tabs (In-client Analysis mode in Query)

In this wave, Microsoft make the following possible:

• AL developers can turn off the data analysis mode using page object metadata.

This is mentioned in AL Language extension changelog Version 12.0

AnalysisModeEnabled property
Introduced the AnalysisModeEnabled property on list pages, which allows to enable or disable data analysis mode on the page. For more information, see Analyze list data using data analysis mode.

AnalysisModeEnabled:
Sets a value that specifies whether analysis mode on the page is allowed.

Let’s look at a simple example.
I created a new list page, and did not set the AnalysisModeEnabled property. (Default is true)

Then we can turn on Analysis Mode on the new list page.

Then set the AnalysisModeEnabled property to false.

Unable to switch to Analysis Mode on the new list page. This only affects this customized page.

PS: The property ‘AnalysisModeEnabled’ cannot be customized.

Update 2023.11.13: Business Central 2023 wave 2 (BC23.1): The AnalysisModeEnabled property is now supported on pages of type Worksheet

• Administrators can turn off the data analysis mode for specific users (probably done using a system permission)

From this wave, Microsoft added the following new system permission.

PS: There is a standard permission set that includes this permission, DATA ANALYSIS – EXEC.

Let’s look at another example.
The following user have permission to use mode Analysis Mode.

I created new permission set and excluded system permissions, 9640 Allow Data Analysis Mode

Then assign it to the user.

As with the method above, the user will not be able to switch to Analysis Mode. But please note that this affects all list pages and queries.

Awesome improvement. Give it a try!!!😁

PS: Why data analysis mode cannot be used on some list pages, such as Chart of Accounts (16, List)

END

Hope this will help.

Thanks for reading.

ZHU