I have two time dimension: createdDate and OrderDate, which both use table
tblTime. However, the cube editor shows only one table join with the fact
table. Is it ok? Or I need to create another table (same as tblTime) so each
time dimension use different table?

Create two views. Load each dimension from its own view.
This allows additional flexibility around differences between them, e.g. the
"Order" calendar may not be exactly the same as your manufacturing calenday.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"nick" <nick (AT) discussions (DOT) microsoft.com> wrote