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
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.
