Share
Report
6I am working on a BI project where we need to create a Power BI model for BC data. It is for financial reporting in Power BI.
We pull data into a data warehouse using the BC Standard APIs. I understand that Dimensions, DimensionValues, and DimensionSetLines are the core of BC for reporting purposes. We need to somehow model these "dimensions" in Power BI, and create a connection from these dimensions to the generalLedger, salesInvoiceLines, salesOrderLines, etc.
My question is how to do this modelling? Just so we are clear on what I mean by this: There was an "old" way of doing this dimension modelling using something called "Dimension Set Entry" as this article explains very well: https://www.linkedin.com/pulse/dealing-dimensions-hooking-power-bi-up-microsoft-marghi-cpa-cga/.
In the article, you can clearly see how dimension set entry and values are used. This method has clearly changed.. what is the new method? How exactly am I to do a similar thing as shown in the article, but using the new method? "DimensionSetLines" is clearly something new that I assume has to be used.
I will not be using Web Services, which has the old method - I need to use Standard APIs and the new method.
If anyone can explain or perhaps even show images of how the modelling works, I'd be grateful.
Categories:
All responses (
Answers (
