You have a table in your custom schema in ADW and would like to create a dimension using Semantic Model Extensions. Which Fact tables can you join your custom dimension to?

• A. Only Custom Fact Tables
• B. Custom Fact and Out-of-the-Box Fact Tables
• C. Only Out-of-the-Box Fact Tables
• D. No Fact Tables Can Be Joined

Answer: (B)

In Semantic Model Extensions, you can connect a custom dimension to fact data from more than one source, as long as there is a valid join path defined in the semantic model. The correct idea is that you can join your custom dimension to both Custom Fact Tables and Out-of-the-Box Fact Tables. This mirrors how SME integrates your own schema with the standard analytic content, letting you analyze across your own metrics and the standard metrics shipped with the system. The joins rely on matching keys between the dimension and the fact tables, so as long as those relationships are properly defined, the dimension can be used with both kinds of facts. Limiting joins to only custom or only out-of-the-box would miss the ability to analyze across the full set of facts available.