tag:blogger.com,1999:blog-5650243067310933543.post7118070591891973494..comments2024-03-19T06:34:04.641+01:00Comments on BI Future Blog: SSAS: Selecting facts with different dimensionalityHennie de Nooijerhttp://www.blogger.com/profile/04946694074745643589noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-5650243067310933543.post-14859774996993741482011-11-02T15:03:05.628+01:002011-11-02T15:03:05.628+01:00Thnx Greg, In my next blogpost about this subject,...Thnx Greg, In my next blogpost about this subject, i'll explain the solution you propose. It's already finished and i'm gonna publish this in a couple of days.<br /><br />HennieHennie de Nooijerhttps://www.blogger.com/profile/04946694074745643589noreply@blogger.comtag:blogger.com,1999:blog-5650243067310933543.post-51493730349301552012011-11-01T16:29:12.728+01:002011-11-01T16:29:12.728+01:00Good post. Just be aware that a materialized refer...Good post. Just be aware that a materialized reference dimension is going to cause a join between SQL tables when you process your partition. It's often better to change your SQL fact table and include TypeDimKey, populating it once during the ETL.Greg Gallowayhttp://www.artisconsulting.com/blogs/greggallowaynoreply@blogger.com