Hi,
I have Fact Dimension Relationship on my cube, my concern is that the source of the dimension (Invoice Number) is just the 1st Partition of the cube. Should I only use a single partition on my cube to use the Fact Dimension Relationship?
What is the best practice to implement a Fact Dimension Relationship on a partitioned cube?
Thanks,
Renold
If you decided to build your fact dimension based on the same table as your partitions are, you should create a view joining all paritition tables and base your fact dimension off that view.
Otherwise the fact dimension is only going to show the invoice numbers that appear only in the first partition table.
Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
No comments:
Post a Comment