check WHERE clause in LTS of your dimension in your BMM Layer.
I Checked it.but i dont see any logic there.
Are you using level-based hierarchy or parent-child?
Get your physical SQL by change log level to 2 in the OBIEE Admin Tool and verify which filters where applied
Yes, I am using level based hierarchy.
when I check the logical it's showing in where clause as ISLEAF(logic).
any guess where those filters applying.
If you create a new analysis adding only that single hierarchical column do you still have the filter in the query?
Sometimes reports contains some filters / logic which is in the XML but not visible anymore in the criteria tab...