OBIEE 11g|12c: Analysis Joining A Dimension And Fact Tables Using Subtotals On Microsoft SQL Server Fails With Error 'nQSError 16002'
Last updated on APRIL 24, 2018
Applies to:Business Intelligence Server Enterprise Edition - Version 184.108.40.206.150120 and later
Information in this document applies to any platform.
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.
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