[nQSError: 14020] None of the fact tables are compatible with the query request

[nQSError: 14020] None of the fact tables are compatible with the query request 

Recently, I ran into this issue. lets see what the reason behind this: 

Scenario: 

  I have "Demo2" BMM Layer created from BISample Schema: Here is the BMM layer 

I have a Product Hierarchy created. Now I am providing the content level for the Logical Table Source.

In the above pic, I have selected the Bottom most level 'Product Name' as aggregation content. And for the Fact, I have selected the topmost level 'Product total' as its aggregation content.

 Now after saving the RPD &the report in dashboard throws error: 

Here, we are getting the error: 

[nQSError: 14020] None of the fact tables are compatible with the query request . 

The issue was at the Aggregation Content Level.The Correct Settings are (for the issue mentioned above)  

 Now in the Dashboard :

The drill down too works now.

 The issue was with choosing inappropriate content level for aggregation. Even for the corresponding dimensions we have to choose the content level at the lowest level of the hierarchy. 

This is applicable for both Conformed & Non-Conformed Dimensions.

OBI 11g Column Permission Setting: PROJECT_INACCESSIBLE_COLUMN_AS_NULL

In Oracle BI 10g, If a column is hidden from a user and when the User logs in there would be an error.

To fix this error, we have to change the parameter  PROJECT_INACCESSIBLE_COLUMN_AS_NULL in NQSConfig.ini

In Oracle BI 11g,  the parameter value is set to ‘YES’ :

[SECURITY]

DEFAULT_PRIVILEGES = READ;  

PROJECT_INACCESSIBLE_COLUMN_AS_NULL = YES;  # default is no

# Note that the paths below should be relative to the instance

# config directories if specified.  e.g.,

# $(ORACLE_INSTANCE)/config/OracleBIServerComponent/<instance_name>

#IGNORE_LDAP_PWD_EXPIRY_WARNING = NO;     // default is no.

New Features for Oracle BI EE11 g Release 1 (11.1.1.6)

New Features for Oracle BI EE11 g Release 1 (11.1.1.6)

1)      Ability to Limit and Offset Rows Returned:   You can use the FETCH and OFFSET clauses to constrain the number of rows returned by the SELECT statement and to offset the returned rows by a given number. Both clauses are optional and can be used together, or independently.

2)      Identify Query Candidates with Oracle BI Summary Advisor:   If you are running Oracle Business Intelligence on the Oracle Exalytics Machine, you can use the Oracle BI Summary Advisor feature to identify which aggregates will increase query performance. Summary Advisor intelligently recommends an optimal list of aggregate tables based on query patterns that will achieve maximum query performance gain while meeting specific resource constraints.

3)      Integrate the Administration Tool with a Third-Party Source Control Management System:   As an alternative to using a MUD environment, you can choose to save your repository in MDS XML format and integrate the Administration Tool with a third-party source control management system.

4)      Streamlined MUD Merge Process:  Repository developers using a multi-user development (MUD) environment can now merge and publish changes in a single step, rather than merging local changes and then publishing changes as two separate steps. They can also perform subset refreshes to perform incremental local merges with the master repository.

5)      Automated Repository Patching Process:  You can now use an option in the patch rpd command-line utility to enable automated patching without prompting for user input. In addition, new patching-specific rules are applied during patch merges.

6)      Support for Aggregate Persistence in a Cluster

7)      FIRST_PERIOD and LAST_PERIOD Time Series Functions:  You can now use the FIRST_PERIOD and LAST_PERIOD functions to compute the first and last value of an expression using the chronological key rather than the primary level key.

8)      Ability to Print the Physical and Business Model Diagrams:  You can now use Print Preview and Print to view and print the Physical and Business Model Diagrams in the Administration Tool.