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 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!