How To: Consolidate Entity on Data Form POV

Summary:

This article stems from this Customer Connect Thread Option to have select POV from data forms — Cloud Customer Connect. It uses a Groovy rule to execute Consolidate on single Entity defined on POV.

Content (please ensure you mask any confidential information):

As documented in following link - Understanding Runtime Prompts

In FCCS seeded rules Entity RTP is of type Members. When Consolidate or Translate is associated with a Data Form and is expected to execute without Prompts, it does not do so because of Entity RTP type. This Groovy rule is used to work this around.

Prerequisites

Scenario, Year, Period and Entity dimensions must exist on POV or Page. They must NOT exist on row(s) or column(s).