How to pull oData Reports in Excel Administration Training This presentation will demonstrate the following How to get the oData feed link in the Convercent App How to create an oData report in Excel2013 ID: 769285
Download Presentation The PPT/PDF document "How to pull oData Reports in Excel" is the property of its rightful owner. Permission is granted to download and print the materials on this web site for personal, non-commercial use only, and to display it on your personal computer provided you do not modify the materials and that you retain all copyright notices contained in the materials. By downloading content from our website, you accept the terms of this agreement.
How to pull oData Reports in Excel Administration Training
This presentation will demonstrate the following: How to get the oData feed link in the Convercent App How to create an oData report in Excel-2013Note: We recommend using Excel-2013 as it is more stable, and more User-Friendly when pulling oData. Excel-2010 will work, but has potential stability issues and thus won’t be covered in this guide. Overview
How to acquire oData feed links in Convercent ©2014 Convercent. All rights reserved. 3
©2014 Convercent. All rights reserved. 4 To start the process, click “Reports”.acquiring oData feed links in Convercent
©2014 Convercent. All rights reserved. 5 You are now in your “Reports” dashboard. To access oData reports, scroll down until you reach the Data Services section.acquiring oData feed links in Convercent
©2014 Convercent. All rights reserved. 6 From here, highlight and copy the link for the oData feed you would like to pull.acquiring oData feed links in Convercent
Creating ODATA Reports in Excel ©2014 Convercent. All rights reserved. 7
©2014 Convercent. All rights reserved. 8 Now you will need to open up Excel. Next open up a new blank workbook. Once open, look along the ribbon and click the “Data” tab.Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 9 After selecting the “Data” tab, click the “From Other Sources” dropdown menu. Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 10 Next, select “ From OData Data Feed” from the dropdown menu. Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 11 Paste in the copied URL from before under “Location of the data feed”. Then under “Log on credentials”, select “Use this name and password”. Next enter in your login/password credentials. Then click “Next” Note: Your credential will be your Convercent Admin login and password. Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 12 Select the tables you want, click “Finish”. Your OData report will now load in to Excel. Note: Connection to the server can be slow, making this window slow to appear.Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 13 The final step is to select the form in which you wish to receive your data. Select from the options presented. Your OData report will now load in Excel.Note: The time it will take to load will depend on how much data you are pulling. Example, if there is a lot of data, it will take longer to load. Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 14 Below is an example oData report in “Table” form.Creating ODATA Reports in Excel
©2014 Convercent. All rights reserved. 15 Make sure to save your report so that you can continue to use. Once a report has been pulled, you only need to refresh it to get the most recent data. If you would like to know how to refresh your oData report please refer to “Refreshing oData”. If you would like to know how to build interactive PivotTables and PivotCharts, please refer to “How to Build PivotTables and PivotCharts”. Both of these documents can be found in our support portal.Creating Odata Reports in Excel
©2014 Convercent. All rights reserved. 16