Data null when filtering a Reporting API call by an AWS Service

Products

• CloudHealth

Issue/Introduction

Filtering should be done at the service level, not the service category level.  You can think of the AWS Service Category as a roll up sum of the composite AWS Services. 

Resolution

A good way to understand the structure of AWS Service vs Service Category is to look at the services filtering in the CloudHealth Platform, which only filters by one categorization (AWS Services).  Let's look at one grouping in particular:

​

AWS Lambda - Direct is the parent (-1 level), and Lambda - Compute and Lambda - Request are the children.  The API Names for these three are:

- aws_lambda_d

- aws_lambda_function_compute_time 

- aws_lambda_function_request

If we filter using the parent aws_lambda_d, our data returned is all nulls.  We actually need to do our filtering based on the children (filters[]=AWS-Service-Category:select:aws_lambda_function_request,aws_lambda_function_compute_time).

Filtering for just the children on a request that has an AWS-Service-Category dimension will get both of the children as expected, but the parent nest will also be populated.  The parent totals can be retrieved in this manner.