Write
280
edits
Difference between revisions of "Linking your OData Feed to a OdataLink Standard Excel Report Template"
Jump to navigation
Jump to search
Linking your OData Feed to a OdataLink Standard Excel Report Template (view source)
Revision as of 22:32, 28 October 2024
, 28 Octoberadded a new image, edited content - copy consolidation feed for standard report templates
(changed title, changed content) |
(added a new image, edited content - copy consolidation feed for standard report templates) |
||
| Line 1: | Line 1: | ||
[[File:copy_consolidation_odata_feed.png|300px|thumb|right|Copy the Consolidation OData Feed]] | |||
[[File:Excel_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | [[File:Excel_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | ||
OdataLink provides a set of downloadable Excel Report templates which are linked to [[OData Feed URLs | | OdataLink provides a set of downloadable Excel Report templates which are linked to [[OData Feed URLs | OData Feeds]] of a demo company file. | ||
In order to replace the existing demo company data with your data in the report, replace the existing OData feed as a Data Source to your own [[OData Feed URLs|OData feed url]]. | In order to replace the existing demo company data with your data in the report, replace the existing OData feed as a Data Source to your own [[OData Feed URLs|OData feed url]]. | ||
| Line 10: | Line 11: | ||
= Steps = | = Steps = | ||
[[File:Excel_ODataFeed_URL.png|300px|thumb|right|Enter the OData | [[File:Excel_ODataFeed_URL.png|300px|thumb|right|Enter the OData Feed url]] | ||
To link your OData feed | To link your company OData feed with OdataLink standard report template, follow these steps. | ||
Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | Before beginning, ensure you have [[Copying the OData feed URL|copied the Consolidation OData Feed URL]], highlighted in the first image. | ||
# Open '''Excel''' on your desktop and select the '''Data''' tab. | # Open '''Excel''' on your desktop and select the '''Data''' tab. | ||