Skip to main content

Notifications

Finance | Project Operations, Human Resources, ...
Unanswered

How can I pull display method value and show on my report(Power Pivot) ?

Posted on by 135

Hi everyone, 

8880.PNG

This EditStop is a method but how can I pull it to the report? 

0247.PNG

  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    RE: How can I pull display method value and show on my report(Power Pivot) ?

    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.

  • RainChong Profile Picture
    RainChong 135 on at
    RE: How can I pull display method value and show on my report(Power Pivot) ?

    Im using power pivot by connecting to database.

  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    RE: How can I pull display method value and show on my report(Power Pivot) ?

    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.

  • RainChong Profile Picture
    RainChong 135 on at
    RE: How can I pull display method value and show on my report(Power Pivot) ?

    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.

  • Martin Dráb Profile Picture
    Martin Dráb 230,188 Most Valuable Professional on at
    RE: How can I pull display method value and show on my report(Power Pivot) ?

    Can you tell us more about the architecture of your report? What is the data source of your Power Pivot report?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Product updates

Dynamics 365 release plans