We have a master DB to store all of our clients Data on the server. But we
need to create Cubes and Dimensions individully for each client, which means
the client can see their data only.

We already have two choices:

1. Creating dimensions against the master DB and creating Cubes with
partitions to seperate clients' Data. But this way has two problems -- when
show the cubes with OWC10.Pivottable, all clients' data will be exposed in
dimensions to every client -- this could not be accepted. Moreover, how to
create a local cube against each partition?

2. Creating a set of sub-DBs from the master DB to seperate clients' data.

This two solutions are not good enough. Anybody has a better idea?

Thanks a lot in advance.

Yan