Hi,

I have Invoice Number Dimension from the fact table and using the "Fact
Dimension Relationship" but the Invoice Num Dim Can only use the first
partition table of the fact table.

How can I populate Invoice Num Dim from the rest of the partition tables? Am
I doing the right way of creating a degenerate dimension in SSAS 2005?

Thanks,
Noldz

Hi,

I have exactly the same scenario (quite common, I guess). My solution - both
dim and measure group are based on the save view (sel * from invoices, say).
You can use Fact Relationship without any problem with this setup.
Afterwards, create the partitions and specify the query (sel * from invoices
where year = 2006,...).

Hope this is what you wanted.

Best regards,
Radim