What must be true in order to apply the same breakdown to indicators using different facts tables?

To successfully apply the same breakdown to indicators derived from different facts tables, it is essential to configure a breakdown mapping for each facts table. This is crucial because each facts table may contain varying data structures, dependencies, and potential relationships. By establishing a breakdown mapping, you ensure that the breakdown is properly aligned with the specific attributes and metrics of each facts table, allowing for consistent reporting and analysis across them.

This alignment is necessary to maintain data integrity and analytical accuracy, as different facts tables may have their unique contexts or constraints. Without such mappings, applying a breakdown might lead to inconsistencies or misinterpretations of data, as the same categories or breakdown values could represent different things across different tables. Thus, configuring a breakdown mapping is fundamental to achieving a coherent and interpretable analytics framework across multiple data sources.