In one of my reports, I have added a dynamic parameter. I have used Business View Manager for this purpose. I did the following steps:
1. Created data foundation on budgets table.
2. Created Business Element based on the above data foundation.
3. Created Business View on the above business element.
4. Created Cascading lov based on the above business view.
The LOV is working in the report but when I add filter in the foundation, it makes no difference. I want to add filter like:
budget-type is equal to "Active".
After adding the filter, it continues showing both active and inactive budgets.