BC Dimension Combinations

63 Views Asked by At

I'm using Business Central in the Cloud, and I have a data structure with nested dimensions (I don't know a better term for it). There's Dimensions A, B, and C. Each dimension has a full list, but only some of the entries in Dimension B are valid for a given value of Dimension A. Likewise, only a subset of Dimension C is valid for a given value of Dimension B. I've been tasked with using Power BI to create a report that shows which values for C are allowed for each B, and likewise for B and A. I can't find a table, page, web service, or API that shows that info. How would I go about retrieving it?

1

There are 1 best solutions below

0
On

There is no default API available to retrieve the Dimension Combinations.

You will have to create your own API by extending Business Central.

The data your are looking for can be found in the following tables:

  • Dimension Combination (table 350)
  • Dimension Value Combination (table 351)