Hi everyone,
This EditStop is a method but how can I pull it to the report?
Unfortunately your solution doesn't allow you to reuse any business logic in AX.
There are other good reasons why accessing the database directly is strongly discouraged. Not only you can't use any X++ code, but you also must deal by yourself with all things handled by AX automatically under the hood, such as dealing with data areas, date-effiective data, automatically applied relations in queries and so on. You also bypass role-based security and you must open access to your production database. Thing again whether your current architecture is a good idea.
If you want to stick to your architecture, you'll have to examine code of editStopped() and reimplement it in Power Pivot.
Im using power pivot by connecting to database.
Before you can use AX data in Power Pivot, you must somehow get it there, e.g. by exporting the data to a file, using OData services or connecting to database. Before we can suggest anything, we must understand what you're doing. Please give us the explanation.
Good day Mr.Drab,
My power pivot is just to check whether my stocks have been stopped or still running.
currently, I have item Id and item number. But now I just want to add a stop field for me to check the process that's it.
Can you tell us more about the architecture of your report? What is the data source of your Power Pivot report?
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156