How to make an Automatic Selection with Dimensions and related tables

How to use advanced filters
Video 11/11
  • Helpful
  • Not helpful
  • Needs update
  • Technical error
An advanced video is for the experts, and it requires detailed knowledge about the specific area of Business Central. Advanced Watch "the details", if you need detailed knowledge about a specific topic. These videos are only relevant for particular users. The Details This video includes functionality from the app "Flexible Forecast" which is available at Microsoft AppSource. Click to visit AppSource. Flexible Forecast
Open Playlist
Presenter: Sune Lohse, Chief Strategy Officer

If you are using the flexible forecast per mension, you might use it for campaign handling or handling with dimension somehow and one of the issues in here is that normally, we will just display items without forecast, meaning we get this view, but if we display items without forecast, it will of course run through all project values, all my global dimension one values. This is a short list here but in real life, it tends to be very long because you have many dimension values that seems to die when they are done using them. So I’d like to make a filter on this list with project codes or global dimension codes that are still active.

This is what happens in the video

Active meaning I’d want to add a salesperson filter. So two of my sales person, I would like to filter on all their customers and I’d like to pick the information value from those customer and make a filter on those. So if the customer in here has a project code like this, a dimension value code, i’d like that to be part of the filter. Let’s build that.

So in my items, I’ll make a selection for that view. We go into the forecast per dimension, I’ve actually built it already so I’ve cheated a little.

If we go in here and this selection, I made a selection called salesperson and dimension.

And in here I said, I’d like to look at table number 18, which is my customer table and on the customer table, i’d like to look for the field number 29, which is the field salesperson code down here.

So add the salesperson code, it needs to have this filter.

So finding all those customers with that filter and after that apply finding the global dimension one code which is field number 16 in the customer table and match it with my code, which is my dimension value in the dimension value table.

So this is my filter very simple actually, now when I use that one, salesperson and dimension, it will find all those customer and say they have in a total six or five different information value. Here you are. So this is a way to do complex automatic dimension filters.