FAQ

Last Updated

August 2022

If you wish to provide feedback on this lab, there is an error, or you want to make a suggestion, please email: cloud-intelligence-dashboards@amazon.com

How do I setup the dashboards in an account other than my payer account or on top of multiple payer accounts?

This scenario allows customers with multiple payer (management) accounts to deploy all the CUR dashboards on top of the aggregated data from multiple payers. To setup the dashboards on top of multi payer accounts, please review multi-account setup deployment options and instructions.

I’m getting an error in QuickSight that is saying Athena timed out?

For very large CUR files, Athena may time out trying to query the data for summary_view. In Athena, find the summary_view view, click the three dots next to it and select show/edit query. Modify the following:

  • Request Athena DML query timeout increase via support case.
  • Or, adjust the granularity to monthly, by changing ‘day’ to ‘month’ in row 6.
  • Or, adjust the look back from ‘7’ months to desired time-frame in row 75.
  • In QuickSight, refresh your dataset.

I am getting the error StartQueryExecution operation: No output location provided. How do I fix this?

An output location is required either through the Workgroup result configuration setting or as an API input.

Click here to expand step by step instructions

How do I limit access to the data in the Dashboards using row level security?

Do you want to give access to the dashboards to someone within your organization, but you only want them to see data from accounts or business units associated with their role or position? You can use row level seucirty in QuickSight to accomplish limiting access to data by user. In these steps below, we will define specific Linked Account IDs against individual users. Once the Row-Level Security is enabled, users will continue to load the same Dashboards and Analyses, but will have custom views that restrict the data to only the Linked Account IDs defined.

Video Tutorial

Click here to expand step by step instructions

How do I fix the COLUMN_GEOGRAPHIC_ROLE_MISMATCH error?

When attempting to deploy the dashboard manually, some users get an error that states COLUMN_GEOGRAPHIC_ROLE_MISMATCH.

Click here to expand answer

How do I fix the ‘product_cache_engine’ cannot be resolved error?

When attempting to deploy the dashboard, some users get an error that states product_cache_engine cannot be resolved.

Click here to expand answer

This page will be updated regularly with new answers. If you have a FAQ you’d like answered here, please reach out to us here cloud-intelligence-dashboards@amazon.com.