Hi All,

How can i partition the cube dynamically? Whenever the new year starts,
the new parttion of cube should be created.


Regards,
Hash

do you use SSAS2005?
use the AMO API or create an XML/A script

you can find some samples on the web

for example:
http://www.microsoft.com/technet/pro...std.mspx#ECCAG



"Hash" <harshal.patil (AT) sify (DOT) com> wrote

Hi Hash,

Following this steps would help you.

1. Design the cube with default partition.
2. Whenever you want to have a new partition copy the above partition
3. On new partition set a slice for year.

All the above could be automated using DSO.

Regards,

Sriram
Hash wrote:

hi
I have the SAS2000. How to do this for partitioning of cube.

From
Harshal



Jeje wrote:

You refer to "Incremental Updates" from BOL. There is a sample script adding
new partition.

Write your new partition name instead of temporary name. And exclude Merge
part.

Ohjoo


"Hash" <harshal.patil (AT) sify (DOT) com> wrote

with AS2000 you can use the DSO API
you'll find some samples to use it and create partitions

"Hash" <harshal.patil (AT) sify (DOT) com> wrote

Hash,

There is a great example in the SSIS sample application which does exactly
this. Basically, it uses a SQL view which contains logic that tells the
package which partitions should exist and what some of the metadata for each
partition is (i.e. SQL, partition ID, etc.).

This should get you where you need to be.

Thanks,
Todd

"Hash" <harshal.patil (AT) sify (DOT) com> wrote