BI4.2 SP3: Make 3 Prompts mandatory if above 4 prompts are left blank.

[Former Member]

Dear Experts,

I am new to SAP BI, we have 8 prompts in our universe which are prompted to users, 7 of them are cascading LOV's while rest is free text. Only one of them is set as mandatory in report by un-checking the optional check box as mentioned below:

Our requirement is that from 8 of the optional prompts, from first 5 any 1 has to be mandatory while from rest 3 only 2 should be mandatory.

Kindly note 1 prompt is not created in Universe and that its in report only, if needed can be created in universe.

Thanks.