I'm encountering a bizarre issue creating an interactive report against a view with 138 columns.
- When I create an interactive report against the view of Type 'SQL query' using SELECT * FROM [view_name], the IR is generated with 132 columns.
- When I create an interactive report against the view of Type 'Table/View' and choose the view from the drop-down list, the IR is generated with 132 columns.
- When I create an interactive report against the view of Type 'SQL query' and provide a query where all 138 columns are listed explicitly in the SELECT list, the IR is created with 138 columns.
What the heck is going on here?
The view shows 138 columns in object browser.
The SELECT list with the columns explicitly listed was built from a PL/SQL function I made to grab the columns from metadata about the view... so there's no possibility that the query introduced bogus columns.