Hello all,
The title says much of it. I read that you can partition measure groups horizontally where each partition gets its own table. But I can't find any way to do this. When I create a measure group I need to chose one table. When I create a partition I need to choose from the table of the measure group.
Right now we the data split in multiple tables because of 'diagonal' measure sparsity. We end up have different measure groups with the same dimensionality pointing to each table. We thought we might gain in performance by having only one measure group as recommended by the BI tool.
Is it worth the trouble?
Not much info about this on the web either.
Thanks for your time.
Donald