Skip to main content
C
CarlosAlvear
November 20, 2024

block consolidations from a specific Cube View using technical parents

  • November 20, 2024
  • 1 reply
  • 0 views

Dear all,

 

Is there a way to block the consolidations if a technical parent is picked? There's a CubeView having the entity tree in rows and consolidation levels in columns. I'd like to only block all consolidations that have a technical parent (this would just polute the database). Is there a code example that could do this?

Thank you for the help.

Best regards,

Carlos

1 reply

H
Henning
November 21, 2024

Hi, if I understand your requirement correctly, you can do this without any code by using the Is Consolidated setting on your technical parent entity by setting it to False:

From the documentation (Entity Dimension) :

Is Consolidated

  • True: The data from the children of this entity are consolidated, which results in the entity equaling the total of its children. 

  • False: The data will not be consolidated. The use case to set the Is Consolidated property to False is to use the parent entity strictly for grouping purposes. Also, it can help with consolidation performance times, because the consolidation will not be performed at the parent entity. 

 


Henning_1-1732175150356.png

 

 

Terms & ConditionsAccessibility statement