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

Using Prompt in a Function with Multiple Selections?

Accepted answer
31
Views
1
Comments

We have a report requirement that a user should be able to select one or multiple parents (the "Departments") in the entity hierarchy and see the level0 descendants of the entity parents in the row of the report (the "Account Keys".) For example, the user wants to select Departments 03, 07, 12, 15 and see the bottom level Account Keys in the row associated with each parent they selected. Another user may want to select Departments 01, 06, 11, and 14. We are unable to built alternate hierarchies to meet this requirements, as the Department selections are very specific and constantly changing.

If I use the "Bottom" function with a prompt, I don't see the option to allow multiple selections in the prompt:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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