Hi,

there is a way to optimize the query executed by SSAS when we use referenced
dimensions and the materialized option?

I have 1 main dimension and 5 small dimensions connected to my fact table
through this main dimension
But SSAS execute a bad query and join multiple times the intermediate
dimension table in the query instead of doing only 1 join

select ....
i1.key1,
i2.key2,
i3.key3,
i4.key4
from fatctable
inner join intermediatetable i1 on k1 = k1
inner join intermediatetable i2 on k1 = k1
inner join intermediatetable i3 on k1 = k1
inner join intermediatetable i4 on k1 = k1

instead of:
select ....
i1.key1,
i1.key2,
i1.key3,
i1.key4
from fatctable
inner join intermediatetable i1 on k1 = k1

I don't want to change my source table by a view which do the job, I really
want to know how I can tell SSAS to do this job by himself.
In a dimension there is an option to process by attribute or by table, but I
have not found an equivalent option for the fact tables.

Thanks for your guides.

Jerome.