Why am I getting the error that no data is available when I create a visualization from an OTBI analysis for Oracle Sales in the Redwood User Experience?

If you're getting the error Can't generate visualization. The criteria used for your visualization doesn't return any data, then check if you can view the data in the analysis results. If you're getting this error along with a banner that tells you that your analysis: "...has more columns than selected. Remove the unused columns from the analysis else visualization may not show correct data.", then make sure the analysis and your visualization use the same columns.

The attributes that you use in your visualization must use all the columns in your Oracle Transactional Business Intelligence (OTBI) analysis. If you can't use all the columns in the visualization, go back to the analysis and remove the unused columns.

For example, a bar chart can support 2 dimensions, 1 metric, and you can have 1 filter attribute. If a report has more than 4 columns ( 3 dimensions and 1 fact), then you'll see this warning.

Visualizations can't show up correctly if the data in your analysis is aggregated or calculated with more columns than chart can support.