I am facing an issue when using the parameter in where condition of the top-level views.
The query is hierarchical and has five levels.
I created a parameter for the top-level view for a key element "key_id" that is used to join several tables. Then, I used this parameter key_id in the where clause of the top-level view as key_id = '1234'. In the second level of the hierarchy, there are four views where the corresponding key id is used in the join of these views. When I checked the delegated queries, it pushed this parameter down to 3 out of 4 views (in where clause) except for one view.
Tried to refresh, rename, drop, and recreate this particular view to make sure it is not a refresh issue, but nothing helped. Please suggest how else I could debug and fix this issue.