Pre-aggregated Hybrid Data copying twice

OSUBlakester
New Contributor II

When I use the Pre-Aggregated Member settings, it is copying the data twice.  I've tried multiple settings and multiple scenarios.

For example, I have tried just O#Top=O#Forms.  After I run the consolidation, there is data in both O#Import and O#Forms, doubled.

 

It also happens with multiple Dimensions.  I've tried O#Top=O#Forms,U5#Top=U5#PlanningLoad and the data is doubled in both Dimensions

 

1 ACCEPTED SOLUTION

OSUBlakester
New Contributor II

Nevermind, I see that you have to exclude the Base members of the Dimension you want to pre-aggregate!

View solution in original post

1 REPLY 1

OSUBlakester
New Contributor II

Nevermind, I see that you have to exclude the Base members of the Dimension you want to pre-aggregate!