Home Forums SQL Server 2005 Business Intelligence Complex and weird requirement : multi-customers Datawarehouse RE: Complex and weird requirement : multi-customers Datawarehouse
Daniel Bowlin
SSC-Dedicated
Points: 34566
More actions
June 5, 2013 at 11:47 am
#1621445
I think this is more or less the way I would do it as well. The one caveat that I see is customer level security will have to be designed carefully. The last thing you want is for customer B to see some data from Customer A on one of their reports.