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?
BC Dimension Combinations
93 Views Asked by Alec Zrike At
1
There are 1 best solutions below
Related Questions in POWERBI
- Embedding Microsoft Power BI into Liferay
- PowerBI hierarchy creation without the cloud
- How to create nested tiles in Power View
- BI Designer many to many relationship
- Microsoft Power BI Designer data model to Excel or PowerPivot
- How to link table row content to source in Power View
- Stream Analytic to PowerBI complains about PowerBIOutputAdapterTransientError
- How can I connect datasets from machine learning to SQL database in Azure?
- drilling from powerbi to ssrs
- How do you connect an Azure Table Storage with Power BI through Stream Analytics?
- Power BI Line Chart Getting Confused
- Handle blank value in Complex expression IF condition in PowerBi
- Power BI running total measure not working when no data for dimension
- Periods to Date Calculation MDX
- Loop on M query
Related Questions in DYNAMICS-BUSINESS-CENTRAL
- Updating Sales Order line items in Dynamics business central
- Business Central AL Code Hyperlink Method
- Business Central: know if an extension is installed
- SerialPort read in extension fails on dotnet error
- Is there a tool/extension/script I can run for Visual Studio Code to Bulk handle errors?
- Issue with Accessing D365 Business Central using user_impersonation permission
- Dynamics 365 Business Central: Show Notes globally
- Expose Blob field in business central via web services
- Retrieve all dimensionSetLines for all SalesOrders
- Print location of repeating columns on RDLC report
- Get data from Odata service Business Central
- BC Dimension Combinations
- Invalid context URL when pulling Business Central data using Azure Data Factory
- Is there an alternative to LookupPageId but on the page?
- How do I get Customer Price Group, Business Central API 2.0
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
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)