LIMITATION:
The ability to drill outside the filter criteria defined in the Intelligent Cube is not available as the report will only allow you to drill within the filter criteria.Dynamic sourcing may be used as a workaround in order to be able to drill outside the Intelligent Cube filter criteria as explained in the below Strategy Tutorial example.
WORKAROUND:
The requirement is to find out if a report hitting an intelligent cube can dynamically source data from the data warehouse if the filter condition is changed. Here is a scenario:
This will allow users to create reports that use the Intelligent Cube and also hit the data warehouse when the Intelligent Cube does not contain the requested information.