Skip to main content
July 25, 2023
Solved

Pre-aggregated Hybrid Data copying twice

  • July 25, 2023
  • 1 reply
  • 0 views

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

 

Best answer by OSUBlakester

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

1 reply

OSUBlakesterAuthorAnswer
July 25, 2023

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