Where to view the backend table of the spend analysis dashboard in cloud cost management workspace?

[Lisa71]

Where to view the backend table of the spend analysis dashboard in cloud cost management workspace? I opened the cloud cost management workspace in UI builder, however the table is grey with "task", however I'm pretty sure the backend table of the dashboard is not task as task table doesn't have cost billing data. 

[Ankur Bawiskar]

@Lisa71 

did you try opening the record and see what comes in browser url?

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Lisa71]

This is what I viewed. The url doesn't contain table parameter, in the data source pop up window, I see the table is always "task", however it shouldn't as task doesn't have those columns displayed in the page like EA billing table. 

[Ankur Bawiskar]

@Lisa71 

not very sure then

[Robert H · Accepted solution]

Hello @Lisa71 ,

There are multiple tables involved.

For example, the data for the graph in the "Cloud Spend Analytics" tab is pulled from the sn_cld_spend_core_monthly_provider_agg_cost table, while the "Record view" list below is based on sn_cld_spend_core_monthly_aggregated_cost.

You can see the list of all tables with daily and monthly cost data by filtering for Application = Cloud Spend Reports Core AND Name Ends with "cost":

PS: How to find out which element of the Workspace is backed by which table:

For "Record view" it's relatively easy to find out, as the table is shown in the "Data" section when selecting the element.

For the graph it's a bit more difficult:

Regards,

Robert