Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 5 Next »

REST API Overrides and Supporting OLAP Reports

OLAP REST API exposes set of endpoints in GET and POST method. AdhocReport is the endpoint that allows the user to run the OLAP reports by overriding the mentioned parameters. Both POST

and GET method supports the adhocReport endpoint. 
Payload parameters supported in the POST method are not all supported in the GET Method. For more information on the POST vs GET method of adhocReport, see the page ‘OLAP REST API POST Vs. GET
Mandatory parameters are Report name, Entity ID, Begin effective Date, and End effective Date. Other overrides like benchmark, Currency conversion, Grouping rule, Report rule, field rule, fields, date
type and security filter criteria are optional. 
Optional payload parameters supported in various OLAP reports.
Overrides applicable in OLAP REST API
#Report TypesBenchmarkCurrencyGrouping RulesReport and Field Rule
1Cash ActivityNoYesNoYes
2Cash BalanceNoYesNoYes
3Composite AnalysisYesYesNoYes
4Composite MonitorNoNoNoNo
5Entity and ClientYesYesNoYes
6Ledger ActivityNoYesNoYes
7Lot Level PositionsNoYesNoYes
8Lot Level ReconciliationNoNoNoNo
9Net Asset ValueNoNoNoNo
10Performance AnalysisYesYesYesYes
11Positions ReconciliationNoNoNoNo
12Positions ReportYesYesNoYes
13Security ReportNoNoNoYes
14Trade ReconciliationNoNoNoNo
15TradesNoYesNoYes

Note: Currency Conversion override on portfolios and benchmarks has different features. For more information on various features and details, see "OLAP REST API Interfaces’


  • No labels