You’re offline. This is a read only version of the page.
25
Hello!
I am trying to build a Spend Qube for a production company based on tables from d365 in Power BI. One of the visualisations that I would like is based on money spent on suppliers/vendors. For this information to be useful, it is key that the spend can be tied to a specific vendor, cost center (location) and product category. My guess is that the last two is best found through financial dimension.
I am relatively new to D365, but by now I have tried two possible approches:
Using VendTrans:
It worked great to find costs and vendor. The trouble began when I wanted to add what type of cost category it was and cost center in my organization. I did not find a way to do this, so then I had to move on to my second idea.
Using GeneralJournalAccountEntry, GeneralJournalEntry and DimensionAttributeValueCombination:
Building a general ledger would give me every transaction, with the financial dimensions. The problem is to find a good way to sort out the right transaction lines from the table to use in my model(vendor costs), and also to tie these lines to a specific vendor.
I hope that I have made my needs and problems clear enough. If anyone has any input on how to make one of my two planned routes work I would be very happy. Also, if you know a better way to get the information I need it wold work just as well. I have seen in Finance and Operations that there is a spend cube, but ours don't contain data, and i have not found a way to get access to the data that is used in the table.
The way we work now is to import every table we need into Power BI, then clean the data and make necessary connections. So if you have suggestions to tables, I would also be happy if you could point me in the right direction with regards to which coulmns to connect tables with.
Best regards
NewBeginner
Share
Report
All responses (
Answers (
