Cloud Intelligence Dashboards issues with a reseller

Has anyone figured out how to get around the reseller issue with the CID? For those that don’t know when you go through a reseller the way AWS handles getting the reseller paid is usually through the EDP (Enterprise Discount Program) and giving them a larger discount. However, we have a EDP as well. This means that what I see in the CID is not what we pay, but what the reseller pays. Anybody happen to have a fix for the issue? We have looked at bill conductor as well, but I do not feel it meets the need.

Hi @Pete_Tyo and welcome to the QuickSight community!
I believe that creating a support ticket with AWS will be the best option for your case.

1 Like

I have engaged AWS several times. Everyone just points me to Bill Conductor. This will get me close, but I want on to the penny. Was hoping someone figured out some magic with QuickSight to adjust the EDP value. So say the EDP discount was 5 but its in the CUR as 10 I need to get it back to 5.

1 Like

Hi @Pete_Tyo,
While I don’t have much experience working with the CID dashboard, from my understanding, it is fully customizable. Maybe you could share some additional information on how you’re using; do you have an EDP discount field being used?
Have you tried creating a calculated field to set the discount as 5 instead of 10?

If you no longer need further assistance and were able to find a work around, feel free to share what worked for you here for the rest of the community.

Thank you!

Hi @Pete_Tyo,
Following up here to see if you had any additional questions or updates on this post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

Hi @Pete_Tyo,
You can follow this guide to remove discounts from the dashboard Workshop Studio. It shows general use case, but you can possibly adjust it to reseller specific discounts

1 Like

Yes I see this can remove the discounts from summary_view and resource_view tables. That is great it at least puts me back to public pricing, However I still have the issue of how to reflect our EDP. I am very limited in my knowledge of SQL statements. My thought would be can I create a SQL statement that when it sees a discount line it recalculates the value by leveraging the public price assuming it is in the line item.Also are all the tables for the CID and other advanced dashboards pulling from the above two tables only?

Hello @Pete_Tyo, @Yuriy, & @Brett !

@Pete_Tyo are you still working on this issue or were you able to find a workaround?

While I have never used CID myself it sounds like there is probably a field in one of the tables that could be filtered or calculated on to remove the extra discount. In the table that has the line item, do you see any identifiers for the reseller or EDP? Also, does it look like the difference in the discounts is consistent? You mentioned the discount you saw was 10 but it should have been 5, is it always that difference?

Trying to adjust the values… working on Athena case now to try and get the below working

, (CASE WHEN (“line_item_line_item_type” = ‘EdpDiscount’) THEN “line_item_unblended_cost” * .8259 ELSE 0 END) “testColumn”

Basically need to add that onto the large sql query that builds the summary_view… having issues. Sure seems like I can’t find any help with Cloud Intelligence Dashboards from AWS.

I know the change that needs to happend just can’t figure out how to make it work.

1 Like

Hey @Pete_Tyo,

When you try to add that logic to your query does it return or error or are the values it returns wrong?

Well I do not think the case statement will work… I need to actually modify the “line_item_unblened_cost” Case statement forces me to use a new column… which breaks everything.