Difference between revisions of "Consolidation OData Feed"
| Line 5: | Line 5: | ||
They assist with the consolidation process by removing the need to append data from multiple data files into one table in Power Query. | They assist with the consolidation process by removing the need to append data from multiple data files into one table in Power Query. | ||
For the most part, the [[Endpoints]] access via a consolidation | |||
== Differences in the Consolidation OData Feed == | |||
For the most part, the [[Endpoints]] access via a consolidation odata feed work the same as those for individual [[Data Files|data files]]. Both include a DataFiles fields including a DataFileID. | |||
There are some slight differences, however. | |||
The Consolidation OData feed includes additional [[Function Endpoints|'''Functions''']]. These functions are present for functions that include IDs as parameters, such as BudgetID, TrackingCategoryID, etc. Since IDs are specific to a single [[Data Files|Data File]], an additional DataFile parameter must be included. These specialised functions are those whose name ends with the word DataFile (e.g. BudgetAmounts vs BudgetAmountsDataFile). | |||
| Line 11: | Line 18: | ||
== OdataLink Report Templates require Consolidation OData Feeds == | == OdataLink Report Templates require Consolidation OData Feeds == | ||
Standard OdataLink Report | [https://odatalink.com/templates/ Standard OdataLink Report Remplates] we create are typically designed and require '''Consolidation''' OData Feeds to extract data as they make use of the [[#Differences in the Consolidation OData Feed|specialised functions mentionned in 'Differences in the Consolidation OData Feed']] | ||
Since Consolidation feeds are available for both '''single-organisation''' and '''multi-organisation accounts''', using Consolidation feeds in the standard templates ensure that they are '''compatible''' with all accounts. | Since Consolidation feeds are available for both '''single-organisation''' and '''multi-organisation accounts''', using Consolidation feeds in the standard templates ensure that they are '''compatible''' with all accounts. | ||
Using any OData feed other than '''Consolidation''' OData Feed can result in errors while refreshing the Standard report template. | |||
Revision as of 18:19, 12 November 2024
Overview
Consolidation OData Feeds are specialised feeds that allow you to pull data from multiple data files assigned to the model as a single feed.
They assist with the consolidation process by removing the need to append data from multiple data files into one table in Power Query.
Differences in the Consolidation OData Feed
For the most part, the Endpoints access via a consolidation odata feed work the same as those for individual data files. Both include a DataFiles fields including a DataFileID.
There are some slight differences, however.
The Consolidation OData feed includes additional Functions. These functions are present for functions that include IDs as parameters, such as BudgetID, TrackingCategoryID, etc. Since IDs are specific to a single Data File, an additional DataFile parameter must be included. These specialised functions are those whose name ends with the word DataFile (e.g. BudgetAmounts vs BudgetAmountsDataFile).
OdataLink Report Templates require Consolidation OData Feeds
Standard OdataLink Report Remplates we create are typically designed and require Consolidation OData Feeds to extract data as they make use of the specialised functions mentionned in 'Differences in the Consolidation OData Feed'
Since Consolidation feeds are available for both single-organisation and multi-organisation accounts, using Consolidation feeds in the standard templates ensure that they are compatible with all accounts.
Using any OData feed other than Consolidation OData Feed can result in errors while refreshing the Standard report template.
Enable Consolidation OData Feed for a Model
Consolidation OData Feed must be enabled in order to be used.
Please refer to Enabling access to the Consolidation OData Feed for the model to enable Consolidation OData Feed.
Related Topics
Key Words
Consolidate
Consolidation OData Feed
Consolidation End Points
Consolidate Xero Organisations
Consolidate MYOB Companies
Consolidate multiple data files