Forum Stats

  • 3,851,489 Users
  • 2,263,988 Discussions
  • 7,904,739 Comments

Discussions

HFR prompt

Hyp_26
Hyp_26 Member Posts: 5
edited Sep 6, 2018 1:03AM in Planning and Budgeting

Hi,

In an HFR report, I have Entity dimension in column. Entity selection is based on a prompt.

Display of Entity is based on following criteria:

1. If Parent entity is selected in prompt, show all base members of that parent.

AND/ OR

2. If base member is selected then show base member itself.

I tried using base function but it doesnt work for #2. Can we accomodate above 2 using a single prompt? Any idea? Thanks.

Thanks.

Tagged:
User_O0UR8

Best Answer

  • Avinash Bhuma
    Avinash Bhuma Member Posts: 150
    edited Sep 6, 2018 12:33AM Answer ✓

    Hi,

    While selecting prompt for company choose Descendants of Prompt for Entity (Inclusive). It will work and don't forget to take inclusive because when you select base member( where it doesn't have any child) so 2006 error will pop out, choosing Inclusive will solve your problem.

    User_O0UR8

Answers

  • Avinash Bhuma
    Avinash Bhuma Member Posts: 150
    edited Sep 6, 2018 12:33AM Answer ✓

    Hi,

    While selecting prompt for company choose Descendants of Prompt for Entity (Inclusive). It will work and don't forget to take inclusive because when you select base member( where it doesn't have any child) so 2006 error will pop out, choosing Inclusive will solve your problem.

    User_O0UR8
This discussion has been closed.