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

VIEW SERVER STATE permission on SQL Server?

Hi all, Sometime While trying to Login into a database we face an error message as shown below. --------------------------- Microsoft Dynamics NAV Classic --------------------------- You cannot start Microsoft Dynamics NAV Classic because you do not have the VIEW SERVER STATE permission on SQL Server. Contact your system administrator. --------------------------- OK    ---------------------------

RTC Report It is not possible to instantiate the Visual Studio bridge.

Hi all, As a Navision developers I have Multiple Versions of Navision running in single Machine. As discussed Earlier in the post how to run multiple Version of RTC in single machine. So my machine have following details for RTC Versions - NAV 2009 R2    - is installed. NAV 2009 SP1  - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 SP1 IN\ NAV 2009         - is copied at C:\Program Files (x86)\Microsoft Dynamics NAV\60\NAV 6.0 IN\ This approach has been working great for execution of Classic and RTC Clients. However, after installing Dynamics NAV 2009 R2, if i tried to view the Layout for an NAV 2009 SP1 Report i was getting the following error: ---------------------------  Microsoft Dynamics NAV Classic  ---------------------------  It is not possible to instantiate  the Visual Studio bridge.  ---------------------------  OK    --------------------------- After searchi...

Dynamics NAV - All that you need to know about MenuSuites.

Hi Readers, This article is based on a request from a blog reader who wanted to understand about MenuSuite in Dynamics NAV. If you have started working with Business central with AL Code then it does not apply to those releases but if you are interested go ahead. Let's start with Future - In Latest and greatest version of product MenuSuite are obsolete and no longer used. So this article applies if you want to learn about C/AL MenuSuite.