Skip to main content

Consuming Output of ODATA - Part 1


Hi all,

As discussed in earlier post today we will try to consume output from the ODATA Services.

The best tool that i like for same is Power Pivot, an Microsoft Excel add in.

You can download same from link - Power Pivot



After installing the add-in lets try to consume the output from ODATA Service hosted yesterday for Customer Card.

Here is the URL - http://localhost:7048/DynamicsNAV70/OData/NAVCustomers

Steps -
1. Open Excel.
2. You will find a new tab in Ribbon called Power Pivot as shown below.

3. Click on PowerPivot Window, icon placed at left corner of the screen.
4. A new window will open as shown.


5. The Power Pivot Addin can accept data from Multiple sources like Text, Access, Database and many others. For ODATA we will be using the From Data Feeds.

6. Click on From Data Feeds.
7. Type in the Friendly Name and Copy the URL from above to Data Feed URL.
8. Click Test Connection.


9. Click Next and then finish.
10. After some time you will find that data Feed have been imported and status will tell you the no of rows transferred.


11. Now all the data from customer table is there in excel, most of customer find it easy to do analysis here.
12. From time after time you can refresh the data to find update in navision.

13. From this you can create Pivot Tables & charts which can be accessed via ribbon of power pivot.
16. With Excel 2010, the Pivot charts are also too good with Slicer as you can see in the Left and Right Part of the Pivot Chart below.



The slicer can be added, by selecting the pivot chart and then from ribbon select analyze Tab.
Here you will find menu to insert slicer.

You can save the sheet and see the changes by updating the Power pivot whenever required.

I hope you will like the post. We will see other consumption uses of ODATA Feed in future posts.

Regards,
Saurav Dhyani

Comments

  1. Knowing that, as from 2013, PowerPivot is only available with Office Professional Plus (and no longer for all retail SKUs of Office as it is in 2010), what other tool would you recommend to consume output from the ODATA Services ?

    ReplyDelete
  2. Hi,

    ODATA can be used with Sharepoint & C#.

    For C# Consumption of OData Please refer article in Archer Point.

    http://community.dynamics.com/nav/b/archerpointdeveloperblog/archive/2012/07/13/consuming-a-nav-2013-page-using-c-and-odata.aspx

    Regards,
    Saurav Dhyani

    ReplyDelete

Post a Comment

Popular posts from this blog

BC 21 and Higher - PowerShell Cmdlet (Replacement of Business Central Administration).

Hi Readers, As discussed in last article about deprecating of Business Central Administration, there are few common actions that we use in administration till Business Central 20. For our on-prem customers, we will still require doing activities. As Microsoft suggest we need to start using PowerShell cmdlet.    Let's see how to do those via PowerShell, or Administration Shell. I will be keep adding commands as you comment to this article.

Send Mail with Attachment From Navision.

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let's link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing - 

MSDYN365BC - Data Upgrade To Microsoft Dynamics 365 Business Central on premises.

Hi Readers, We have already talked about the number of steps for upgrading to Business Central on Premises from different NAV versions. After that article, I received multiple requests for an article which list down steps for Data Migration. In this article, we will discuss steps of data migration to MSDYN365BC (on-Prem) from NAV 2017. For this article, I am considering a Cronus Demo Database without any customization. For an actual upgrade project, we will have to complete object merge using compare and Merge process. After the Merge Process, the next step is data migration. Let's discuss those steps. Direct Upgrade to Microsoft Dynamics 365 Business Central (on-Prem) is from following versions - 1. NAV 2015. 2. NAV 2016. 3. NAV 2017. 4. NAV 2018.