Home

Returns the given OLAP Cube with selected fields

GET
api/databases/{dbid}/analytics/olapcubes/{olapcube}
This request is used for getting data of the given OLAP Cube with selected fields. Fields of 'Measure" type should be requested as functions (Sum())
OLAP Cube data can be filtered (by using 'filter' parameter).

Request:

Argument Type Description
dbid GUID  The ID of the database
olapcube String  The name of the OLAP Cube
Query parameter Required Default Options Description
fields 1      Returns selected fields
filter       Sets filter
settings       Returns analytics data settings
skip       Returns data starting from the given item
top     Max 200  Returns the given number of data items

Response:

Content

Name Type Options Description
IsTooManyItems Boolean  Is too many result objects
Items Array of Object  Result object list

Request analytics data from OLAP cube Facts_TaskWorkTurnoverRegistry with selected measure fields Estimate:sum(Estimate) grouped by dimension fields State, Project.

Request:
  1. GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/analytics/olapcubes/Facts_TaskWorkTurnoverRegistry?fields=estimate:sum(estimate);state;project
  2. Accept: text/json
  3. Accept-Encoding: deflate
  4. Host: localhost:6496
  5. Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45
Response:
  1. Transfer-Encoding: chunked
  2. Content-Encoding: 
  3. Cache-Control: no-store
  4. Content-Type: text/json; charset=utf-8
  5. Date: Fri, 21 Dec 2012 16:15:34 GMT
  6. Set-Cookie: sid=20715d87-29dc-429e-9a86-4b3c60cd8a45; path=/;
  7. Server: Microsoft-HTTPAPI/2.0
  8.  
  9. {
  10.   "IsTooManyItems": false,
  11.   "Items": [
  12.     {
  13.       "estimate": 57.666666666663978,
  14.       "state": "96b07914-5358-41b9-99bc-17b3c7c7d4d8",
  15.       "project": "11111111-1111-1111-1111-111111111111"
  16.     },
  17.     {
  18.       "estimate": 102.4999999999997,
  19.       "state": "96b07914-5358-41b9-99bc-17b3c7c7d4d8",
  20.       "project": "e9ae7e7e-c935-4e7c-9d82-4ab829c3f6b9"
  21.     },
  22.     {
  23.       "estimate": 70.666666666666757,
  24.       "state": "96b07914-5358-41b9-99bc-17b3c7c7d4d8",
  25.       "project": "18a6b2ab-cc8b-4e38-b3f6-0641449919f6"
  26.     },
  27.     {
  28.       "estimate": 10.0,
  29.       "state": "ed944f90-e198-42a3-b009-233f0feef93d",
  30.       "project": "e9ae7e7e-c935-4e7c-9d82-4ab829c3f6b9"
  31.     },
  32.     {
  33.       "estimate": 18.5,
  34.       "state": "aac936c9-fc31-4c82-a8db-d961fca799cb",
  35.       "project": "11111111-1111-1111-1111-111111111111"
  36.     }
  37.   ]
  38. }