Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
The ability to create multiple time dimensions without duplicating tables.
In SSAS models, it is possible to create as many time dimensions as required by the context of the date (for example, order date). Each new date dimension inherits a key corresponding to the key of the fact table. With SSAS, I end up with multiple time dimensions without having to duplicate the relational data in my dimensional model.
Is this possible?
You can manage multiple time dimensions depending on the number of relationships between the fact table and the dimension table. Like virtual dimension tables in the warehouse.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.