how to add dimensions attribute in Mondrian without hierarchy.
I want to filter on a specific column of dimension attribute.


Dim> User
Hierarchy
id
name
.
.
.
.
isdeleted

I want to get records of all users which are not deleted in dimension and isdeleted flag in the Hierarchy