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 APRIL 24, 2018

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and later
Information in this document applies to any platform.

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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms