Symptoms
When you create a report from a model that has many key
performance indicators (KPIs), the report might not show all the KPIs
that are selected from a single table. You might see the following
error message:ORA-01792: maximum number of columns in a table or view is 1000
Causes
This is an Oracle limitation. An attempt was made to create
a table or view with more than 1000 columns, or to add more columns
to a table or view, which pushes it over the maximum allowable limit
of 1000. The unused columns in the table are also counted toward the 1000-column
limit.
Resolving the problem
To avoid this issue, plan and create a report with only
those KPIs that are needed. Rather than using all the KPIs from a
table.