Hi,

I am trying to create partitions on a cube in AS 2005. The
cube has 2 dimensions each with 3 levels ( attributes) and about 6
measures. I wanted to create partitions using query binding so that I
have partition for each month ( Time dimension is one of the dimensions
I have).

I was just using a simple select that included all dimensions and
measures with a where clause for each month, this just keeps giving me
a syntax error. If I look at the sql generated by AS 2005 at run time
it has a few sub - selects. I am confused can anyone please shed some
light on this.

I have built this cube in AS 2000 and then migrated it over to AS 2005.


Thanks