I 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.
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.
