Hi

We have a scenario where we have three different sales teams associated with
a client. In the Client dimension we have Team1Name, Team2Name & Team3Name. I
was thinking of creating a concatenated member in the dimension called
ConcatTeamName. We need to be able to write MDX that does one of the
following from RS2005. User multi-select a team and we display information
where the selected teams are in either of the teams or if that is not
possible a LIKE function on the concatenated team field. Any help would be
greatly appreciated.

Thanks
Peter

Hi Peter,

If the objective is to relate many teams to a given client, how about
using the many-many dimension feature of AS 2005, where an intermediate
measure group could be set up to relate a given client to many teams in
a Team Dimension? Then the multi-select of teams should be
straightforward.

http://msdn.microsoft.com/library/de.../en-us/dnsql90
/html/sql2k5snapshotisol.asp
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***