If possible email me chandran.gangadharan.b (AT) bayer (DOT) com

I need to create a bunch of msft analysis server
cubes - one for each 'cube role'
from an existing cube - how do i 'query'
to find
the roles in the cube -can i do this from dts- if so can u give
me pointers on where i should start-steps to follow
( query the cube for roles and then build one cube for each role')-
if possible
i dont want to purchase any additional product like
'localcubes'.

More info -
i have built the first cube with all the info - and now need to give each
rep only info each of them need- i want to automate this process- so the
process- queries the roles - build a s cube one for each role - is there a
bookthat may have useful info- where do i start- i have 'nt yet figured out
how to execute the 'create cube statement'- i know how to build it from
analysis services using the wizard but dont know how to use/execute the
'create cube syntax'-

thanks,