Cost Intelligent Dashboards Quicksight Problem

0

I wanted to map the account ids to the account name. So, I edited the summary dataset with a new account map from the organization data table account map instead of the CUR table. Enter image description here

Then I refreshed my dataset and headed to the dashboard. Now I get the below error: Enter image description here

Please advise, will it be fixed after waiting a couple of hours? Or do I need to somehow manually force the changes or rebuild the dataset/analysis/dashboard?

Thank you in advance.

Ash
posta un anno fa591 visualizzazioni
2 Risposte
2

Best way to add account names from organization_data is by using this guide- https://wellarchitectedlabs.com/cost/200_labs/200_cloud_intelligence/cost-usage-report-dashboards/dashboards/code/0_view0/

Go over Option3 steps.

After you change account_map according to option 3:

  • On Athena- Run "select * from account_map" and validate that you can see data
  • On QuickSight -> DataSets -> summary_view -> Click on Edit DataSet and [1] validate its load correctly [2] click on Publish & Save button
  • On QuickSight -> DataSets -> summary_view -> refresh dataset
  • On QuickSight -> DataSets -> CUDOS Dashboard -> validate that you can see dashboard data
AWS
con risposta un anno fa
0

Most likely you have overlapping column names in organization_data and account_map datasets. Which columns you have organization_data dataset? If it's account_id, account_name mapping you can change account_map view to use organization_data and remove organization_data dataset in the summary_view join. As suggested above this document describes how to set up mapping https://catalog.workshops.aws/awscid/en-US/dashboards/foundational/cudos-cid-kpi/add-accounts In your case it's option 3 and as you can see it only requires change in account_map view, no changes required to QuickSight datasets

profile pictureAWS
ESPERTO
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande