Home

Returns the details of the given filter item of the given dimension table

GET
api/databases/{dbid}/metadata/analytics/dimensions/{dimension}/filteritems/{filteritem}
This request is used for getting information about filter clauses available for the given entity-type.

Request:

Argument Type Description
dbid GUID  The ID of the database
dimension String  The name of the analytics dimension table
filteritem String  The name of the filter item

Response:

Content

Type name Description
Object 

Request:
  1. GET api/databases/ec5a34c2-7062-4be7-ade9-c15acefcdbb8/metadata/analytics/dimensions/Dim_TimeKey/filteritems/Year
  2. Accept: text/json
  3. Accept-Encoding: deflate
  4. Host: localhost:6496
  5. Cookie: sid=8d9210b3-5f3c-4db1-8038-748f67531bea
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 15:01:53 GMT
  6. ETag: "634916866010755264"
  7. Last-Modified: Fri, 21 Dec 2012 09:36:41 GMT
  8. Server: Microsoft-HTTPAPI/2.0
  9.  
  10. {
  11.   "Name": "Year",
  12.   "ClauseChangedMask": {
  13.     "Value": 7,
  14.     "Title": "All"
  15.   },
  16.   "Removed": false,
  17.   "IsSimpleFilterItem": true,
  18.   "IsBigString": false,
  19.   "BigStringLitePropertyName": null,
  20.   "IgnoreCase": false,
  21.   "GroupingItem": false,
  22.   "TargetName": null,
  23.   "IsKey": false,
  24.   "ValueType": "Nullable`1",
  25.   "ReadOnly": false,
  26.   "EnumName": null,
  27.   "Hidden": false,
  28.   "FieldFormat": "yyyy",
  29.   "MaskType": null,
  30.   "EditorName": "",
  31.   "DurationMode": {
  32.     "Value": 0,
  33.     "Title": "None"
  34.   },
  35.   "MinValue": null,
  36.   "MaxValue": null,
  37.   "clauses": [
  38.     {
  39.       "ClauseType": 0,
  40.       "OperandCount": 1
  41.     },
  42.     {
  43.       "ClauseType": 1,
  44.       "OperandCount": 1
  45.     },
  46.     {
  47.       "ClauseType": 2,
  48.       "OperandCount": 1
  49.     },
  50.     {
  51.       "ClauseType": 3,
  52.       "OperandCount": 1
  53.     },
  54.     {
  55.       "ClauseType": 4,
  56.       "OperandCount": 1
  57.     },
  58.     {
  59.       "ClauseType": 5,
  60.       "OperandCount": 1
  61.     },
  62.     {
  63.       "ClauseType": 6,
  64.       "OperandCount": 2
  65.     },
  66.     {
  67.       "ClauseType": 7,
  68.       "OperandCount": 2
  69.     },
  70.     {
  71.       "ClauseType": 16,
  72.       "OperandCount": 1
  73.     },
  74.     {
  75.       "ClauseType": 17,
  76.       "OperandCount": 1
  77.     },
  78.     {
  79.       "ClauseType": 14,
  80.       "OperandCount": 0
  81.     },
  82.     {
  83.       "ClauseType": 15,
  84.       "OperandCount": 0
  85.     }
  86.   ]
  87. }