Thursday, December 8, 2022

Querying Data Via XMLA API Calls

I use Postman to test calls
Here is example text for the body
Select Non Empty CROSSJOIN(Children(Product),CROSSJOIN({[Profit]},{[Qtr1],[Qtr2]} )) on 0 FROM [Demo].[Basic] Where ([Actual]) Provider=Essbase;Data Source=EssbaseCluster-1DemoBasicTabTupleFormatData
Here was the result looks like, not as easy to parse as normal REST request but still doable

Querying Data Via XMLA API Calls

I use Postman to test calls Here is example text for the body Select Non Empty CROSSJOIN(Children(Product),CROSSJ...