Hi,

I've created about 10 partitions in a cube and set the same filter on each
of the partitions. I'm able to process all the partitions and the data looks
good when I browse the cube, but DrillThrough seems to work only with the
first partition.

The error I get on DrillThrough for the remaining partitions is:

"Unable to drill through. Data Source Provider Error. The column prefix
'dbo.Time_Dim' does not match with a table name or alias name used in the
query.;42000'"


Could this be a possible bug?

The filter I'm using in the partitions is on a time dimension table :
DatePart(year,"dbo"."Time_Dim"."Date") = 2004


I know I can work around this with views in MSSQL, but would like to resolve
this one way or the other.


Thanks,
Chumma.