What do I do when I get the warning that the analysis has more columns than selected?

Here's what to do when you see the warning that your analysis: "...has more columns than selected. Remove the unused columns from the analysis else visualization may not show correct data."

The attributes that you use in your visualization must use all of the columns in your Oracle Transactional Business Intelligence (OTBI) analysis. If you can't use all of 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.