Version 2021

Dynamic Sourcing

No PostgreSQL specific customizations were made for this feature.

To ensure fast response time to report queries, MicroStrategy enables dynamic sourcing of Intelligent Cubes. With dynamic sourcing, MicroStrategy OLAP Services checks the contents of a report data request and compares it to all existing Intelligent Cubes. If one of the existing Intelligent Cubes can act as the data source, the report automatically sources data from that Intelligence Cube rather than retrieving the information from the data source. 

Intelligence Server analyzes the structure of the report as well as its filtering criteria to determine if a query can be directed to an existing Intelligent Cube. The result is a dramatic performance improvement for reports and ad hoc queries. Dynamic Sourcing provides a dramatic shift in user analysis. Without bounds to a limited aggregate of data, users on the MicroStrategy BI platform are free to navigate the entire data warehouse for comprehensive analysis. 

You can enable dynamic sourcing at the project or cube level.

In the Dynamic Sourcing area, use the Make Intelligent Cubes available for Dynamic Sourcing options to enable or disable dynamic sourcing for the Intelligent Cube:

  • To enable dynamic sourcing for the Intelligent Cube, select Enabled.
  • To disable dynamic sourcing for the Intelligent Cube, select Disabled.
  • To specify that the Intelligent Cube inherits its dynamic sourcing behavior from the project settings, select Use Default Project-Level Behavior.

In the Dynamic Sourcing area, use the Allow dynamic sourcing even if outer join properties are not set options to determine if reports can connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined:

  • Enabled: Select this option to allow reports to connect to Intelligent Cubes using dynamic sourcing even when some outer join properties are not defined. This can cause incorrect data to be returned in scenarios when outer joins would be helpful.
  • Disabled: Select this option to prohibit reports from connecting to Intelligent Cubes using dynamic sourcing when some outer join properties are not defined. Selecting this option avoids the possibility of displaying incorrect data in reports.

See KB36667: Best practices for Dynamic Sourcing in MicroStrategy for more information.