Folks,

Herez the query u can notice that the aggregate function call too many
nodes to look into.
Can u tell me how ths query can be optimized.

WITH MEMBER [HospiceUnits].[CONDITION1] AS 'AGGREGATE({[Clients with
groups and teams].[VistaCare, Inc.].[Atlanta
Metro].[ATHENS-GA].[EASTTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta Metro].[ATHENS-GA].[UNK],[Clients
with groups and teams].[VistaCare, Inc.].[Atlanta
Metro].[ATHENS-GA].[WESTTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[ATLANTA-GA].[A_SMITHTEAMA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[ATLANTA-GA].[A-DEBORAHTHOMAS],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta Metro].[ATLANTA-GA].[TEAM],[Clients
with groups and teams].[VistaCare, Inc.].[Atlanta
Metro].[ATLANTA-GA].[TEAMA-E_L_BOWDEN],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[ATLANTA-GA].[TEAMB-CARRIE],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[ATLANTA-GA].[TEAMB-M_MARCUS],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[DOUGLASVILLE-GA].[A-AMYSMITH],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[DOUGLASVILLE-GA].[A-STACYBENNETT],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[DOUGLASVILLE-GA].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[C_NESBITT-PEACH],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[GREEN-AL],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[GREEN-JULIE],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[GREEN-LYNN],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[GREEN-MARTHA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[GREEN-RHONDA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-BRENNAN],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-CAROLYNN_],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-DONNA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-MARTHA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-PAT],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[GREENVILLE-SC].[PEACH-RHONDA],[Clients with groups and
teams].[VistaCare, Inc.].[Atlanta
Metro].[LAWRENCEVILLE-GA].[SOUTHTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[AMARILLO-TX].[BLUE],[Clients with
groups and teams].[VistaCare,
Inc.].[Central].[AMARILLO-TX].[NORTH-BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[AMARILLO-TX].[NORTH-RED],[Clients
with groups and teams].[VistaCare, Inc.].[Central].[OKLAHOMA
CITY-OK].[UNK],[Clients with groups and teams].[VistaCare,
Inc.].[Central].[PLAINVIEW-TX].[BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[PLAINVIEW-TX].[NORTH-BLUE],[Clients
with groups and teams].[VistaCare,
Inc.].[Central].[PLAINVIEW-TX].[NORTH-RED],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[PLAINVIEW-TX].[RED],[Clients with
groups and teams].[VistaCare,
Inc.].[Central].[PLAINVIEW-TX].[SOUTH-BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[PLAINVIEW-TX].[SOUTHBLUIE],[Clients
with groups and teams].[VistaCare,
Inc.].[Central].[PLAINVIEW-TX].[SOUTHRED],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[PLAINVIEW-TX].[SOUTH-RED],[Clients
with groups and teams].[VistaCare,
Inc.].[Central].[PLAINVIEW-TX].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Central].[SAN ANGELO-TX].[BLUE],[Clients with
groups and teams].[VistaCare, Inc.].[Central].[SAN
ANGELO-TX].[RED],[Clients with groups and teams].[VistaCare,
Inc.].[Central].[SAN ANGELO-TX].[UNK],[Clients with groups and
teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[ADMITTEDBYDENISEHAMPTO],[Clients with
groups and teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[ADMITTEDBYMBARNHEISEL],[Clients with groups
and teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[ADMITTEDBYMSMALLWOOD],[Clients with groups
and teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[ADMITTEDBYWHARGRAVE],[Clients with groups
and teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[ADMITTEDBYWHITHARGRAVE],[Clients with
groups and teams].[VistaCare, Inc.].[Central].[TULSA-OK].[TU],[Clients
with groups and teams].[VistaCare,
Inc.].[Central].[TULSA-OK].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Dallas Metro].[DALLAS-TX].[BLUE],[Clients
with groups and teams].[VistaCare, Inc.].[Dallas
Metro].[DALLAS-TX].[GREEN],[Clients with groups and teams].[VistaCare,
Inc.].[Dallas Metro].[DALLAS-TX].[MARYANN],[Clients with groups and
teams].[VistaCare, Inc.].[Dallas Metro].[DALLAS-TX].[UNK],[Clients with
groups and teams].[VistaCare, Inc.].[Dallas
Metro].[DALLAS-TX].[WEST],[Clients with groups and teams].[VistaCare,
Inc.].[Dallas Metro].[DENTON-TX].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Dallas Metro].[FORT
WORTH-TX].[DEB&ANNIE],[Clients with groups and teams].[VistaCare,
Inc.].[Dallas Metro].[FORT WORTH-TX].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Dallas Metro].[GREENVILLE-TX].[PINK],[Clients
with groups and teams].[VistaCare, Inc.].[Dallas
Metro].[GREENVILLE-TX].[PURPLE],[Clients with groups and
teams].[VistaCare, Inc.].[Dallas Metro].[GREENVILLE-TX].[UNK],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[BLOOMINGTON-IN].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[CINCINNATI-OH].[EASTTEAM1],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[CINCINNATI-OH].[EASTTEAM2],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[CINCINNATI-OH].[PCC],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[CINCINNATI-OH].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[CINCINNATI-OH].[WESTTEAM1],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[CINCINNATI-OH].[WESTTEAM2],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[COLUMBUS-OH].[TEAMA],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[COLUMBUS-OH].[TEAMB],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[COLUMBUS-OH].[TEAMC],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[COLUMBUS-OH].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[BARB],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[EVANSVILLE-IN].[EAST],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[EASTTEAM],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[EVANSVILLE-IN].[GWEN],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[KATHY],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[EVANSVILLE-IN].[KATHYH],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[LADONNA],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[EVANSVILLE-IN].[SANDI],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[SUE],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[EVANSVILLE-IN].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[EVANSVILLE-IN].[WEST],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[BLUE(OLDNW)],[Clients with groups
and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[GOLD],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[N_E],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[N_W],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[NE],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[NW],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[PURPLE],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[RED],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[S],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[S_E],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[S_W],[Clients
with groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[SE],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[INDIANAPOLIS-IN].[SW],[Clients with
groups and teams].[VistaCare,
Inc.].[Midwest].[INDIANAPOLIS-IN].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[II-A_WILLIAMS],[Clients with groups and teams].[VistaCare,
Inc.].[Midwest].[NEW ALBANY-IN].[KRISTIBYRDTEAMIII],[Clients with
groups and teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAM1KRISTIBYRD],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAM1MELIAROBERTS],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAM3LAURASTIVERS],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIBOBBIJOCLARK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIB0BBIJOCLARK],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW ALBANY-IN].[TEAMIII],[Clients
with groups and teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIIANGELAWHITE],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIIANNEWATSON],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIIDOROTHYRILEY],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIILAURASTIVERS],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIIRHONDAGRANT],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIISUSIEWYATT],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIIZEONAMCGUIRE],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIJAMIEMITCHELL],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIIRANDYHENSLEY],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMIMELIAROBERTS],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW
ALBANY-IN].[TEAMISHANEKESSINGER],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[NEW ALBANY-IN].[UNK],[Clients with
groups and teams].[VistaCare, Inc.].[Midwest].[TERRE
HAUTE-IN].[TEAMA-LORRERN],[Clients with groups and teams].[VistaCare,
Inc.].[Midwest].[TERRE HAUTE-IN].[TEAMB_L_DAUGHTERYRN],[Clients with
groups and teams].[VistaCare, Inc.].[Midwest].[TERRE
HAUTE-IN].[TEAMC],[Clients with groups and teams].[VistaCare,
Inc.].[Midwest].[TERRE HAUTE-IN].[TEAMC-BEV],[Clients with groups and
teams].[VistaCare, Inc.].[Midwest].[TERRE
HAUTE-IN].[TEAMC-DAWN],[Clients with groups and teams].[VistaCare,
Inc.].[Midwest].[TERRE HAUTE-IN].[TEAMC-TIAWHITFORDRN],[Clients with
groups and teams].[VistaCare, Inc.].[Midwest].[TERRE
HAUTE-IN].[TEAMD-VICKI],[Clients with groups and teams].[VistaCare,
Inc.].[Midwest].[TERRE HAUTE-IN].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[ALBUQUERQUE-NM].[UNK],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[DENVER-CO].[PINK],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[DENVER-CO].[PINK3],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[DENVER-CO].[PINK4],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[DENVER-CO].[PINK6],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[DENVER-CO].[PINKTEAM6],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[DENVER-CO].[PURPLE],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[DENVER-CO].[PURPLE1],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[DENVER-CO].[PURPLE2],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[DENVER-CO].[PURPLE5],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[DENVER-CO].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[CENTRAL_DEBW],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[CENTRAL_DEBZ],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[CENTRAL_KELLYG_],[Clients with groups
and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[EAST_JEANNE],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[EAST_JULIE],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[EAST_JULIE_],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[EAST_JULIEB_],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[EAST_MARYO_],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[EAST_PATTY],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[NORHT_DEBZ],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[NORTH_DEBWOODS],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[NORTH_DEBZ],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[NORTH_KEVIN],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[NORTH_PATTY],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[NORTH_SANDY],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[NORTH_SARAHW],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[NORTH_SARAWADE],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_JULIE],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_JULIEBURK],[Clients with groups
and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_MARY],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_MARYO],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_MARYO_],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SOUTH_ROBERT],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SUNCITY_CHRIST],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SUNCITY_CINDA],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[SUNCITY_CINDAM],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[SUNCITY_LIZ],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[WEST_],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[WEST_CINDAMURPHY],[Clients with groups
and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[WEST_KELLY],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[WEST_KELLYG_],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[WEST_LINAN],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[PHOENIX-AZ].[WEST_MARYT],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[PHOENIX-AZ].[WEST_SUEW],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[RENO-NV].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[SUN CITY-AZ],[Clients with groups
and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[ADRIENNE_VICKIEJ],[Clients with groups
and teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[BOB],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[BOB_JANA],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[CENTRAL],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[DEBBIED_],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[DEBBIED_RED],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[DEBD_],[Clients with groups and
teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[ELIZABETH_RED],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[JAN],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[JAN_GREEN],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[JANA],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[JANA_GREEN],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[JANL_],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[JANL__],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[LEIGH],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[MICHELLE],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[RED],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[TERRI_RED],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[TERRIG_],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[TERRIG_GREEN],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[TERRIMC_RED],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[TERRIR_RED],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[VICKI_RED],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[VICKIEM_],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[VICKIM_],[Clients with groups and
teams].[VistaCare, Inc.].[Mountain].[TUCSON-AZ].[VICKIM_RED],[Clients
with groups and teams].[VistaCare,
Inc.].[Mountain].[TUCSON-AZ].[VIKKIJ_RED],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[A_DARRYL],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[ANNMARIE],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[B_ELLEN],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[B_JEANNE],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[B_MARIANNE],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[B_PEG],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[C_JO],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[C_TINA],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[CAROLYN],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[CHRISTINE],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[DARRYL],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[DEBBIE],[Clients with groups and
teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[DEBBIESUTHERLAND],[Clients with groups
and teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[ELLEN],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[ELLEN&ALYSON],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[ELYSSA],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[JEAN],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[JEANNE],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[JO],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[JO-ANNE],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[JOHASSAN],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[JUNE],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[KAREN],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[MARGE],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[MARIANNE],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[MARYANNE],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[MAUREEN],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[MICHAEL],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[PEG],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[BOSTON-MA].[SANDRA],[Clients with
groups and teams].[VistaCare,
Inc.].[Northeast].[BOSTON-MA].[TINA],[Clients with groups and
teams].[VistaCare,
Inc.].[Northeast].[PHILADELPHIA-PA].[PHILA_B],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[PHILADELPHIA-PA].[TEAMA],[Clients
with groups and teams].[VistaCare,
Inc.].[Northeast].[PHILADELPHIA-PA].[TEAMB],[Clients with groups and
teams].[VistaCare, Inc.].[Northeast].[PHILADELPHIA-PA].[UNK],[Clients
with groups and teams].[VistaCare, Inc.].[South
Texas].[AUSTIN-TX].[SANMARCOS-LEAPFROG],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[AUSTIN-TX].[UNK],[Clients with
groups and teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYOU],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[CORPUS CHRISTI-TX].[BAYOUTEAM],[Clients with
groups and teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYOUTEAM(CHRISTINERN)],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYOUTEAM(JOANRN)],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYOUTEAM(PAULINERN)],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYTEAM],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[CORPUS CHRISTI-TX].[BAYTEAM(ROB)],[Clients with
groups and teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BAYTEAM(SHANNONRN)],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[BEACHTEAM],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[CORPUS CHRISTI-TX].[BEACONTEAM],[Clients with
groups and teams].[VistaCare, Inc.].[South Texas].[CORPUS
CHRISTI-TX].[UNK],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[HOUSTON-TX].[HOUSTON],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[HOUSTON-TX].[UNK],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREEN],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--DIANALILJEDAHL_R_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAMDIANALILJEDAHLR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--DIANALILJEDAHLR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--PATTIWAGNERR_N_],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM-PATTIWAGNERRN],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--PATTIWAGNERRN],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM-RAYHOOKERR_N_],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--RAYHOOKERR_N_],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM-RAYHOOKERRN],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--RITAWELLINGTONR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--RITAWELLINGTONR_N>],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM-RITAWELLINGTONRN],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--SALLYHENSELYR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--SALLYHENSLEYR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--SHIRELYHIGDON],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM--SHIRLEYHIGDONR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM-SHIRLEYHIGDONRN],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[GREENTEAM---STEVEMCKEER_N_],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[RAYHOOKERR_N_],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[KERRVILLE-TX].[UNK],[Clients
with groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOW],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--ANGELACOLSTONR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM-ARLIECHRISTYR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--ARLIECHRISTYR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--BARBARASONNIERR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--DIANALILJEDAHLR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--KELLYBARKERR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM-PHYLLISMILLICANR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--PHYLLISMILLICANR_N_],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[KERRVILLE-TX].[YELLOWTEAM--STEVEMCKEER_N_],[Clients with groups
and teams].[VistaCare, Inc.].[South Texas].[SAN
ANTONIO-TX].[BLUE],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[SAN ANTONIO-TX].[BROWN],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[SAN
ANTONIO-TX].[GREEN],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[SAN ANTONIO-TX].[ORANGE],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[SAN
ANTONIO-TX].[PURPLE],[Clients with groups and teams].[VistaCare,
Inc.].[South Texas].[SAN ANTONIO-TX].[RED],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[SAN
ANTONIO-TX].[SANMARCOS-LEAPFROG],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[SAN ANTONIO-TX].[UNK],[Clients
with groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN__KASW_SESCC_RBDECLINED],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_AFSW_KBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_AWSW_RWSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BBSW_ACSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BMSW_KTSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BMSW_KTSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BMSW_KTSCC_EHDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BMSW_MWSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_BMSW_MWSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CCSW_CBSCC_JW],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CCSW_KBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CDECSW_KBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CGSW_ACSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CGSW_CBSCC_JWUPSTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CGSW_NTSCC_JWUPSTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_CJSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_DSSW_CBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_DSSW_KBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_DZSW_MWSCC_HL],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_CBSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_CBSCC_JW],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_CBSCC_JWARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_CBSCC_JW-ARCHANGLESTEAM],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_KTSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_NTSCC_JW],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_FSSW_NTSSC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_GHSW_KTSCC_EH_ROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_GHSW_KTSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_GHSW_KTSCC_JWROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_GHSW_RWSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_GHSW_RWSCC_EHROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_HRSW_ACSCC_RB],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_HRSW_KTSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_HRSW_KTSCC_EHHHAX3],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_HRSW_RHSCC_BE_DE-ROADRUNNER],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_HRSW_RHSCC_BE-DECLINED],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JPSW_RHDECLINEDSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JPSW_RHSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JPSW_SESCC_DEROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JPSW_SESCC_RB-DECLINEDROADRU],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JTSW_RHSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_JTSWRHSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_ACSCC_BE-DECLINEDHUBTEA],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_ACSCC_BEROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_ACSCC_EHHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_ACSCC_RB],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KASW_SESCC_EH-HUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KHSW_NTSCC_JWUPSTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_KWSW_KBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LMSW_KTSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LMSW_MWSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LMSW_MWSCC_EHDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LMSW_MWSCC_HLDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LSSW_CBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LSSW_CBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LSSW_KBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LSSW_KBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LTSW_MWSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LYMSW_ACSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LYMSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_LYNSW_ACSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_MCSW_KB],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_MCSW_KBSCC_DE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_MLSW_MWSCC_HLDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_NHSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_ACSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_ACSCC_EH-HUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_ACSCC_RBHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_ACSCCBEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_ACSSCC_EHARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_CBSCC_JWARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PBSW_RWSCC_JWUPSTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PHSW_ACSCC_RBHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_KTSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_KTSCC_EHDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_EHDREAMRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_HL],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_HL-DECLINEDDREAMT],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_HLDREAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_HLDREAMTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_MWSCC_HLL],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_PNSW_SESCC_HL],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_RDSW_KBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_ACSCC_EHHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_ACSW_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_KTSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_KTSCC_EH],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_SESCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SBSW_SESCC_RB],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_ST-BSSW_ACSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_STSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_STSW_ACSCC_RB],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_STSW_ACSCC_RB-HUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_STSW_MWSCC_JW-DREAMTEAM],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SUESW_SESCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_SWSW_CBSCC_DEARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TBSW_CBSCC_JWARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TBSW_KBSCC_DEDECLINEDARCHANG],[Clients with
groups and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TBSW_KBSCC_DENARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TBSW_KBSCC_JWARCHANGELS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TBSW_RHSCC_EHROADRUNNERS],[Clients with groups
and teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TJSW_ACSCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TJSW_ACSCC_EHHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RN_TJSW_SESCC_BEHUBTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RNLM_SW_ACSCC_BE],[Clients with groups and
teams].[VistaCare, Inc.].[South
Texas].[TEMPLE-TX].[RNPBSW_CBSCC_JWHHTEAM],[Clients with groups and
teams].[VistaCare, Inc.].[South Texas].[TEMPLE-TX].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[AANGELA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[A-ANGELA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[A-ANGELAJAMESRN],[Clients with groups
and teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[AETTA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[A--ETTA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[AJENNY],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[ASHERRY],[Clients with groups and
teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[A---SHERRYSTEWART],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[ASONJA],[Clients with groups and
teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[ASONYABRADSHAW],[Clients with groups
and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[B-CYNTHIA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[BMELISSAB],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[BMELISSABLANKS],[Clients with groups
and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[BMELLISSAB],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[BPAULA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[B-PAULA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[BSUZY],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[BTAMMIE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[CDANA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[C-DANA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[CERICA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[C-ERICA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[CMARYBETH],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[CMICHAEL],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[C-MICHAEL],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[C-MICHAELDEHNER],[Clients with groups
and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[D-DEBORAH],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[DDEBRA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[D-DEBRA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[DJOSIE],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[D-JOSIE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[DMARTI],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[DMARTY],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[DTALINA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[DTAMI],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[D-TBERRY],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[SUZYRAINEY],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[COLUMBUS-GA].[TEAM1],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[COLUMBUS-GA].[TEAMB-PAULA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[GRIFFIN-GA].[TEAMA],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[GRIFFIN-GA].[TEAMB],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[GRIFFIN-GA].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[BLUE-KATHY],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[BLUE-KAY],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[BLUE-LINDA],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[BLUE-LINDABUTTS],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[GREEN],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[GREEN-JAYNE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[GREEN-LORI],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[PURPLE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[PURPLE-],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[PURPLE-BRENDALYN],[Clients with groups
and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[PURPLE-CINDI],[Clients with groups and
teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[PURPLE-RUSSELL],[Clients with groups and
teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[PURPLE-VERONICA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[RED],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[RED-BILL],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[MACON-GA].[RED-CARLTON],[Clients
with groups and teams].[VistaCare,
Inc.].[Southeast].[MACON-GA].[RED-EDNA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[NEWNAN-GA].[TEAM1],[Clients with
groups and teams].[VistaCare,
Inc.].[Southeast].[NEWNAN-GA].[UNK],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX CITY-AL].[A_DEE],[Clients
with groups and teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[A_DELL],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[A_EL],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[B_LORIE],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[DEE],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[DEE_SANDY],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[DELL],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX CITY-AL].[EL],[Clients
with groups and teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[GINGER],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[KRISTI-B],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX CITY-AL].[LORIE],[Clients
with groups and teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[MARK],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[MARK-B],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[RACHAEL],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[PHENIX CITY-AL].[REBA],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[PHENIX CITY-AL].[SANDY],[Clients
with groups and teams].[VistaCare, Inc.].[Southeast].[PHENIX
CITY-AL].[WANDA],[Clients with groups and teams].[VistaCare,
Inc.].[Southeast].[SAVANNAH-GA].[SV],[Clients with groups and
teams].[VistaCare, Inc.].[Southeast].[SAVANNAH-GA].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[BLUETEAM-KRISTEN],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[BLUETEAM-LENA],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[BLUETEAM-MARYKAY],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[BLUETEAM-VICKI],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[BLUETEAM-WENDY],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[REDTEAMBECKY(B)],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[REDTEAM-JANET],[Clients with groups
and teams].[VistaCare,
Inc.].[Southwest].[CARLSBAD-NM].[REDTEAMLYNN],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[CARLSBAD-NM].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[CLOVIS-NM].[GREEN_CLOVIS],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[CLOVIS-NM].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[HOBBS-NM].[BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[HOBBS-NM].[BLUE-CAROLYN],[Clients
with groups and teams].[VistaCare,
Inc.].[Southwest].[HOBBS-NM].[GREEN_CLOVIS],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[HOBBS-NM].[LILAC],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[HOBBS-NM].[RED],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[HOBBS-NM].[WHITE],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[HOBBS-NM].[WHITE-MONTYNE],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[BLACK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[BLACK1],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[BLACK2],[Clients
with groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[BLUE],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[BLUE#1],[Clients
with groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[BLUE1],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[BLUE2],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[RED],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[RED1],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[RED2],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[UNK],[Clients with
groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[WHITE],[Clients with groups and
teams].[VistaCare, Inc.].[Southwest].[LUBBOCK-TX].[WHITE1],[Clients
with groups and teams].[VistaCare,
Inc.].[Southwest].[LUBBOCK-TX].[WHITE2],[Clients with groups and
teams].[VistaCare,
Inc.].[Southwest].[ROSWELL-NM].[ROSWELL-IDG],[Clients with groups and
teams].[VistaCare,
Inc.].[Southwest].[ROSWELL-NM].[ROSWELL-IGD],[Clients with groups and
teams].[VistaCare,
Inc.].[Southwest].[ROSWELL-NM].[ROSWELLTEAM],[Clients with groups and
teams].[VistaCare,
Inc.].[Southwest].[ROSWELL-NM].[ROSWELLTEAM-TAMMY],[Clients with groups
and teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[AMBERLARSEN],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[BARBARAMATHIS],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[BRIGITTESIMMONS],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[CHANDASEITER],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[CHERYLROWE],[Clients with
groups and teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[DEBBIE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[ELIZABETHTANNER],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[JACKIEBROWN],[Clients with
groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[JANICESMITH],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[LANIEAGN],[Clients with
groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[LANIEGAN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[LEANNJACKSON],[Clients with
groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[MARCIAVINCENT],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[NANCYTRAPNELL],[Clients with
groups and teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[RACHEL],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[RACHELLEONARD],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[ROBYNEPEABODY],[Clients with
groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[SANDYMORTON],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[TROYPANCHUK],[Clients with
groups and teams].[VistaCare, Inc.].[Utah].[LEHI-UT].[UNK],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LEHI-UT].[VICTORDEAN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LOGAN-UT].[LOGAN],[Clients with groups
and teams].[VistaCare, Inc.].[Utah].[LOGAN-UT].[LOGANCBGHRS],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[LOGAN-UT].[PBJBAS],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[LOGAN-UT].[RLRS],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[AMYJ__JALEAN_CLAUDE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[AMYJ__LIZ_CLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[AMYS_DESIREEBRUCE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[CYNTHIA_DAN_DESIREE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[CYNTHIA_DESIREE_CLAUDE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[CYNTHIA_LIZ_MIKE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[CYNTHIACHRISMIKE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[ELAINE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[EMILY_CHRISTINE_DAN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[ERIN],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[ERIN_DESIREE_CLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[ERIN_DESIREE_DAN],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[ERIN_JALEAN_CLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[HOLLY_CHRIS_MIKE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JANNA_CHRISTINE_DAN],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANIIE_BRIDGETTE_BRUCE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANNIE_BRIDGET_BRUCE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANNIE_BRIDGET_DAN],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANNIE_BRIDGETT_BRUCE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANNIE_BRUCE_BRIDGET],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JEANNIE_CHRISTINE_DAN],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JENNIFER_MARY_BRUCE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[JENNIFERBRIDGETBRUCE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[KIM_DESIREE_BRUCE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[LEISHALIZCLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[LESLIE_CHRIS_MIKE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[LESLIE_DESIREE_MIKE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARCI_DESIREE_DAN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[MARCI_LIZ_CLAUDE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARCIDESDAN],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARCIE_JALEAN_CLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARCIE_JALEAN_CLAUDE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARCIJALEANCLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[MARIE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARIE_CHRIS_MIKE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARIE_CLAUDE_DESIREE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[MARIE_DAN_DESIREE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARIE_JALEAN_CLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARIE_JALEANE_CLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MARIIE_DAN_DESIREE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[MEGAN],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MEGAN_DESIREE_CLAUDE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[MEGAN_DESIREE_DAN],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MEGAN_JALEAN_CLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[MEGANCHRISTINECLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICHOLE_DESIREE_DAN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[NICHOLEBRIDGETDAN],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLED__BRUCE_BRIDGET],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLED__CHRISTINE_DAN],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLED__DESIREE_DAN],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLED_CHRISTINE_DAN911],[Clients with groups
and teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[NICOLET_],[Clients with
groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLET__CHRIS_MIKE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLET_CHRIS_MIKE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[NICOLET_DESIREE_MIKE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[SARABRIDGETMIKE],[Clients
with groups and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPH],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPH_DESIREE_CLAUDE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPHANIE_DESIREE_CLAUDE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPHANIE_JALEAN_MIKE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPHANIE_LIZ_BRUCE911],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPHANIEDESIREECLAUDE],[Clients with groups
and teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[STEPHANIELIZMIKE],[Clients with groups and
teams].[VistaCare,
Inc.].[Utah].[OGDEN-UT].[TIFFANY_CHRIS_MIKE],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[OGDEN-UT].[UNK],[Clients with groups
and teams].[VistaCare, Inc.].[Utah].[SALT LAKE
CITY-UT].[CONNIEWINERITER],[Clients with groups and teams].[VistaCare,
Inc.].[Utah].[SALT LAKE CITY-UT].[DEEHORN],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[SALT LAKE
CITY-UT].[ERICADIXON],[Clients with groups and teams].[VistaCare,
Inc.].[Utah].[SALT LAKE CITY-UT].[HOLLIWILMETH],[Clients with groups
and teams].[VistaCare, Inc.].[Utah].[SALT LAKE
CITY-UT].[JENHOROWITZ],[Clients with groups and teams].[VistaCare,
Inc.].[Utah].[SALT LAKE CITY-UT].[JOHNROBISON],[Clients with groups and
teams].[VistaCare, Inc.].[Utah].[SALT LAKE CITY-UT].[UNK],[Clients with
groups and teams].[VistaCare, Inc.].[Utah].[SALT LAKE
CITY-UT].[VICKIFOX]})' MEMBER [return_date].[datecond] AS
'AGGREGATE({[1999].[1999 Quarter 4].[1999 December],[1999].[1999
Quarter 4].[1999 November],[2000].[2000 Quarter 1].[2000
February],[2000].[2000 Quarter 1].[2000 January],[2000].[2000 Quarter
1].[2000 March],[2000].[2000 Quarter 2].[2000 April],[2000].[2000
Quarter 2].[2000 June],[2000].[2000 Quarter 2].[2000 May],[2000].[2000
Quarter 3].[2000 August],[2000].[2000 Quarter 3].[2000
July],[2000].[2000 Quarter 3].[2000 September],[2000].[2000 Quarter
4].[2000 December],[2000].[2000 Quarter 4].[2000 November],[2000].[2000
Quarter 4].[2000 October],[2001].[2001 Quarter 1].[2001
February],[2001].[2001 Quarter 1].[2001 January],[2001].[2001 Quarter
1].[2001 March],[2001].[2001 Quarter 2].[2001 April],[2001].[2001
Quarter 2].[2001 June],[2001].[2001 Quarter 2].[2001 May],[2001].[2001
Quarter 3].[2001 August],[2001].[2001 Quarter 3].[2001
July],[2001].[2001 Quarter 3].[2001 September],[2001].[2001 Quarter
4].[2001 December],[2001].[2001 Quarter 4].[2001 November],[2001].[2001
Quarter 4].[2001 October],[2002].[2002 Quarter 1].[2002
February],[2002].[2002 Quarter 1].[2002 January],[2002].[2002 Quarter
1].[2002 March],[2002].[2002 Quarter 2].[2002 April],[2002].[2002
Quarter 2].[2002 June],[2002].[2002 Quarter 2].[2002 May],[2002].[2002
Quarter 3].[2002 August],[2002].[2002 Quarter 3].[2002
July],[2002].[2002 Quarter 3].[2002 September],[2002].[2002 Quarter
4].[2002 December],[2002].[2002 Quarter 4].[2002 November],[2002].[2002
Quarter 4].[2002 October],[2003].[2003 Quarter 1].[2003
February],[2003].[2003 Quarter 1].[2003 January],[2003].[2003 Quarter
1].[2003 March],[2003].[2003 Quarter 2].[2003 April],[2003].[2003
Quarter 2].[2003 June],[2003].[2003 Quarter 2].[2003 May],[2003].[2003
Quarter 3].[2003 August],[2003].[2003 Quarter 3].[2003
July],[2003].[2003 Quarter 3].[2003 September],[2003].[2003 Quarter
4].[2003 December],[2003].[2003 Quarter 4].[2003 November],[2003].[2003
Quarter 4].[2003 October],[2004].[2004 Quarter 1].[2004
February],[2004].[2004 Quarter 1].[2004 January],[2004].[2004 Quarter
1].[2004 March],[2004].[2004 Quarter 2].[2004 April],[2004].[2004
Quarter 2].[2004 June],[2004].[2004 Quarter 2].[2004 May],[2004].[2004
Quarter 3].[2004 August],[2004].[2004 Quarter 3].[2004
July],[2004].[2004 Quarter 3].[2004 September],[2004].[2004 Quarter
4].[2004 December],[2004].[2004 Quarter 4].[2004 November],[2004].[2004
Quarter 4].[2004 October],[2005].[2005 Quarter 1].[2005
February],[2005].[2005 Quarter 1].[2005 January],[2005].[2005 Quarter
1].[2005 March],[2005].[2005 Quarter 2].[2005 April],[2005].[2005
Quarter 2].[2005 May]})' MEMBER [Measures].[Questionsatisfiedcount] AS
'([Measures].[Q4] + [Measures].[Q5])'

SELECT {[Measures].[Qcount],[Measures].[Mean],
[Measures].[Questionsatisfiedcount],[Measures].[QSum],[Measures].[StdDev]}
ON COLUMNS,
NonEmptyCrossjoin( filter([Question].[Question Descr].members,
[Measures].[Qcount] > 0)) ON ROWS
FROM [Cube_Scale_Questions] where
([HospiceUnits].[CONDITION1],[return_date].[datecond] )

You don't want to manually list out all the leaf level members if you
can avoid it as this is bypassing the built-in aggregations in the cube.

With the time dimension you can do the following:

MEMBER [return_date].[datecond] AS
'AGGREGATE({
[1999].[1999 Quarter 4].[1999 December],
[1999].[1999 Quarter 4].[1999 November],

[2000],

[2001],

[2002],

[2003],

[2004],

[2005].[2005 Quarter 1],

[2005].[2005 Quarter 2].[2005 April],
[2005].[2005 Quarter 2].[2005 May]})'

I can't tell if you can do a similar thing with the [HospiceUnits].
[CONDITION1] member as I cannot tell if you are excluding and members
from this set, but hopefully you can employ a similar technique. If you
have gone to the trouble of designing aggregations the above syntax is
more likely to use them.

You will also get better performance if you can more uniquely identify
your members. ie [Date].[Year].[2000] is better than [2000] as the query
parser does not have to traverse all the dimensions and levels looking
for a member with a name of [2000].

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <1132119985.738768.310310 (AT) g47g2000cwa (DOT) googlegroups.com>,
ypavankumar (AT) gmail (DOT) com says...

darren,

The members used in aggregate function are varying in nature & if for a
level all members are available then iam using the logic which u have
mentioned with regard to time dimension. But when even 1 member is less
then i cannot use that method. I need to aggregate entire member list.
This is when the query takes time more than 1 min to execute.
Any other optimization techniques are available with the same.

Thanks,
Pavan




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

I cannot think of too much else you can do, AS2k can struggle a bit when
you start to go outside of the hierarchies.

If you are only excluding a few members you could look into using the
except() function.

You could also look into using "Execution Location=3;Default
Isolation Mode=1" on your connection string to try and force as much of
the query to be resolved on the server to prevent excess metadata being
transferred to the client

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <#UMYf6C7FHA.3760 (AT) TK2MSFTNGP14 (DOT) phx.gbl>, hellopavan2003
@yahoo.com says...