How to increase or decrease the maximum number of column or fields to allow for a query?

Modified on Mon, 17 Sep 2018 at 04:20 AM

BI Connector has an initial setting to allow upto 25 columns or fields when extracting OBIEE data.  If you need to extract more fields, use the following instructions:

1. Open “ODBC Administrator” and click on “Configure” button of the DSN created for connecting Tableau with OBIEE.

2. Click on Advanced Settings Icon to open the advanced settings dialog box.

3. Modify “Maximum number of columns for Extract” edit box.

4. Click OK and Close BI connector Dialog box.