@Technical Talks Ka Pitara ( TTKP )
MicroStrategy | Business Intelligence | Tableau | Power BI | Datawarehouse
#TTKP #MTKP #mstr #Microstrategy #latestvideos
The general goal of reporting on data in Intelligent Cubes is to create reports that are linked to a published Intelligent Cube. Dynamic sourcing makes Intelligent Cubes more accessible by allowing regular reports to automatically access published Intelligent Cubes that can satisfy the data requirements of the report.
This can improve the performance of reports, which get executed against an Intelligent Cube, without having to manually find and select the Intelligent Cube that fits the analysis of the report. If the data requirements for the report change, or cannot be satisfied by an available Intelligent Cube, the reports automatically access the data warehouse to return the required information
Features that prevent reports from using dynamic sourcing
Consolidations or Custom groups
Query Builder or Freeform SQL reports cannot use dynamic sourcing.
AND NOT or OR NOT logical operators
Metrics that use passthrough functions such as ApplySimple. Alternatively, facts can be defined using passthrough functions such as ApplySimple. These facts can then be used to create metrics, which can be used on reports that can support dynamic sourcing.
Freeform MDX metrics. On reports based on MDX data sources, these are analogous to metrics with passthrough functions.
Metrics that use facts with extensions or degradations
Data marts
Report as filter used in the report filter etc.
16 окт 2024