I have around thirty companies.

My initial approach has been building 30 cubes. Each cube has one measure "Periodic". They can independently process their cubes from each other. The virtual cube is adding 30 time the measure "Periodic" to a new calculated member "Period Values". This approach works fine.

Despite of the quality of the drill through option, my client really wants to have this enabled. Since drill through doesn't allow you to drill through on a calculated member (of course), I have a serious problem. The only way I see is changing my approach by going back to one huge cube, which has of course other disadvantages! But then I'll have one (non-calculated) measure "Period Values" that can be used to drill through.

Does anybody has a good alternative?

Regards,
Jeroen

Have you looked into partitioning?

"J. Nathalia" <anonymous (AT) discussions (DOT) microsoft.com> wrote

virtual cube is adding 30 time the measure "Periodic" to a new calculated
member "Period Values". This approach works fine.
on a calculated member (of course), I have a serious problem. The only way I
see is changing my approach by going back to one huge cube, which has of
course other disadvantages! But then I'll have one (non-calculated) measure
"Period Values" that can be used to drill through.

@Erin

I'm using the standard edition.... not the Enterprise editio

Rgds
Jeroen