CData Power BI Connector for AWS Data Management 2019 - Online Help
Questions / Feedback?

DimensionValues

CData Power BI Connector for AWS Data Management 2019 - Build 19.0.7362

Retrieves all available filter values for a specified filter over a period of time.

Table Specific Information

In order to use this view, the user must be authorized to use billing and cost services.

Select

The Dimension field is required in the WHERE clause. The connector will also process the filters below server-side, though collaborative query processing. The connector will other filters client-side, within itself. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false.

Server-Side Query Processing

Server-side filtering is supported on Dimension, Context, SearchString, and time period (StartDate - EndDate).

Filtering on a Date Range

StartDate and EndDate have limitations from the API such that StartDate cannot be older than a year before the current date, while EndDate cannot be set to a value after the beginning of the next month (wrong values will be automatically corrected by the connector). Both are required from the API, so if they are not specified in the query, values will be assigned to them as described below:

  • Only StartDate is missing: StartDate will get a value of one year before the EndDate. Considering the limitations mentioned before, the value will be eventually corrected by the connector.
  • Only EndDate is missing: EndDate will get a value of one year after the StartDate. Considering the limitations mentioned before, the value will be eventually corrected by the connector.
  • Both are missing: EndDate will be set at the beginning of next month. StartDate will be set one year before the EndDate.

Examples

The following query will be solved server side:
SELECT * FROM DimensionValues WHERE Dimension='AZ' AND StartDate > '01-01-2018'

Columns

Name Type Description
Value String The value of a dimension with a specific attribute.
Attributes String The attribute that applies to a specific Dimension.
Dimension String The name of the dimension. Each Dimension is available for different a Context.

Pseudo-Columns

Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.

Name Type Description
SearchString String The value that you want to search the filter values for.
StartDate String The start date for retrieving the dimension values.
EndDate String The end date for retrieving the dimension values.
Context String The context for the call to GetDimensionValues. This can be RESERVATIONS or COST_AND_USAGE.

 
 
Copyright (c) 2020 CData Software, Inc. - All rights reserved.
Build 19.0.7362.0