I have a cube that has 2 dimension tables that are identical, other than the
name, Is there a way I can share the dimension data without having the
duplicate table data, when I point all the different key columns to the
same table the results in the fact table get all screwed up.... Can i create
a view of the dimension table that will act as my other dimensions???? or
is there a way to do this with shared dimensions?

TIA,
Scott

Analysis Services loads from a view as easily as it does from a base table.
--
Dave Wickert [MS]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI Practices Team
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"Scott Riehl" <scott_riehl (AT) remove (DOT) b-f.com> wrote

Hello,

if the table have the same format you can union them to create a
dimension

Best Regards,

Patrice
"Dave Wickert [MSFT]" <dwickert (AT) online (DOT) microsoft.com> wrote

You can create even with two (if) you needed id's for each fact table


"Patrice Lamarche" <Patrice_lamarche (AT) gco (DOT) ca.nospam> ñîîáùèë/ñîîáùèëà â
íîâîñòÿõ ñëåäóþùåå: news:OHT17KmIEHA.3376 (AT) TK2MSFTNGP09 (DOT) phx.gbl...