Hi guys,

I want to add partition dynamicaly in one cube and each partition should
use each fact table and process that partition using ActiveX script.

for example.

partition Fact table Dimension

March2005 factTable_March2005 Gender,Year,Age
April2005 factTable_April2005 Gender,Year,Age
May2005 factTable_May2005 Gender,Year,Age

if anybody have a soln pls send it to me.

Thanks in advance,

Kanz.
Kan_kl (AT) yahoo (DOT) co.in








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

Your best bet if you don't want to write code is to use the partition manager
tool from the toolkit. It allows you to create multiple partitions and point
them to different fact tables. Another great thing about it is that it
dynamically sets the slice for the partitions based upon the level you set.

If you don't mind writing code, you can use DSO to do this. There are
samples provided with the install of AS the show you how to create partitions
and point to fact tables and set slices, etc...


"kannan k" wrote: