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:
Business Intelligence Server Enterprise Edition - Version 11.1.1.7.150120 and laterInformation 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |