• In Kimball Group Reader, on page 339, they talk about "Multi-Enterprise Calendar Dimensions" which is what I believe you are trying to implement.  In the Kimball example, they have a Base Calendar Dimension, with 1 row per day in it, then there is a Snowflake Calendar Subdimension as an outrigger, which has 1 row per day per Organization in it, thus the Subdimension has a higher cardinality than the base dimension and needs to be filtered to query it properly.

    In your example, DimDate looks like it is the 1 row per day table, and DimCalendar is the multiple rows per day table, so you need some kind of key or code in DimCalendar to be able to filter it based on which of your many Corporate Calendars you wish to represent for a given report or cube.  How do you distinguish different corporate calendars in the DimCalendar table?