Line Chart Visual Discrepancy between Quicksight UI and Web Service - Getting Error

Hi Team,

When I am trying to creating line chart visual from quicksight UI it allows me to add drill down (ie, hierarchy) for axis, color and small multiples but when I try to create the same use web service API it give me below error, is there something I am missing.

Error - ‘definition.sheets.1.member.visuals.9.member.lineChartVisual.columnHierarchies’ failed to satisfy constraint: Member must have length less than or equal to 2 (Service: AmazonQuickSight; Status Code: 400; Error Code: ValidationException; Request ID: cd7117dc-21e5-4188-9d0c-0780e0873abb; Proxy: null):

UI -

Please note, I have created one sample on quicksight UI, extracted json using SDK and tries to created it again using API with different analysis name but it gives me above mentioned error. Is there any different between Quicksight SDK vs Quicksight UI?

Let me know if you need any additional information.

Any quick help will be appreciated.


Hi @anshul1243,

Have you tried the LENIENT mode as the ValidationStrategy when using the CreateAnalysis API? It is an option to relax the validation that is required to create and update analyses, dashboards, and templates with definition objects. When you set this value to LENIENT, validation is skipped for specific errors.

Did this answer your question? If so, please help the community out by marking this answer as “Solution!”. Thanks!

If it doesn’t solve your problem, I would recommend filing a case with AWS Support where we can dive into the details so that we can help you further. Here are the steps to open a support case. If your company has someone who manages your AWS account, you might not have direct access to AWS Support and will need to raise an internal ticket to your IT team or whomever manages your AWS account. They should be able to open an AWS Support case on your behalf. Hope this helps!

@Thomas Thank for your quick response.

Could you please guide me where can I find the field to set, I am using Quicksight SDK 1.12.530 version, at this level class didn’t find any such option.

Let me know if I am doing anything wrong here.

@anshul1243, you would need to update to a newer version of the SDK (1.12.571 being the latest version) to see that new option. There, you will find the ValidationStrategy within the CreateAnalysisRequest (AWS SDK for Java - 1.12.571), not within the AnalysisDefinition. Hope this helps.

@Thomas, Thanks for your quick response