genarating or building multiple olap cubes

[sunil]

i wan to know that is there a way by which we can build multiple olap cubes
and can schedule them on the basis of the time specified by the user. any
help will be appreciated

 

[Kurt Verhaegen]

Sunil,
The creation can be done via the PWA admin interface.
The scheduling is only 1 OLAP cube at the time. We use SQL DTS and created
packages which will update the other OLAP cubes which we first created via
PWA admin enterprise options.
Hopes this helps.
Grtz Kurt

 

[sunil]

thanks for the suggestion, but i actually want to handle all this through asp
programming by providing a custom interface to enter the name and start time
for number of cubes and then the utility should be able to generate the
specified cubes at the specified time.
thanks again
sunil