Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Need to bring the entities selected in prompt to the header dynamically

In EPM Cloud Management Report, we have a specific need to bring the Entities selected in the prompt.

The Entity dimension is placed in a single column having Multi Select enabled. In order to sum the entities chosen in the prompt, we have added a formula column. Now, in the header, if I use the function MemberAlias as "MemberAlias("Entity", C(A), C(B)……), I'm able to achieve the ask. However, that is not dynamic and so we are looking for a dynamic solution to bring up multiple entities selected in the prompt to the header. Attached screenshot for your reference.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!