OBIEE 11g|12c: Analysis Joining A Dimension And Fact Tables Using Subtotals On Microsoft SQL Server Fails With Error 'nQSError 16002' (Doc ID 2374199.1)

Last updated on OCTOBER 17, 2019

Applies to:

Symptoms

You are creating an analysis against MS SQL Server data source.

You have a dimension table named 'Transaction Type' with  two columns, a code and description.
The Transaction Type table is joined by the code column to the fact table. 

If you create a report on transaction code and units sold, you are able to sub total on code and grand total for the report.  The SQL is only reporting off the fact table.

If the report is is modified to include transaction description, the report displays code, description and quantity. The SQL now includes the transaction type table.

Subtotals can be created  on code OR on description OR grand total the report, but if I report  combination of all three, then the analysis errors with:

 nQSError:16002 Cannot obtain number of columns for the query result.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.