Working with Dimension Combinations

(1) Share

Report

Posted on by CU11120629-0

154

There is a table of Dimensions Combination in which there are 8 Dimensions with combination with each other

and inside these if I open a combination of PROG with AREA

Now this is the combinations of PROG code with AREA code so for now these are manually unblocked or blocked but what i want is that i would process an excel sheet like this

that would do my working like as in excel sheet it will block SCHOOL 1 with AREA A016 and so on

Please provide me the working if anyone has done any working or guide how to do this

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Jainam M. Kothari 13,802 Super User 2025 Season 2 on at

Like (1)

Report

Working with Dimension Combinations

Hello,

You can automate blocking/unblocking Dimension Combinations in Business Central by using a Configuration Package or RapidStart: export the Dimension Combination table to Excel, update the Blocked field for each PROG–AREA pair as per your sheet (e.g., SCHOOL1 with AREA A016 = Yes), then import and apply the changes.

For recurring automation, you can build an AL codeunit that reads the Excel via Excel Buffer and updates the Blocked field in the Dimension Combination table.

Excel Structure Example

PROG Code AREA Code Blocked

SCHOOL1 A016 Yes

SCHOOL2 A017 No

Was this reply helpful? Yes No