Question: I want to filter a dimension on its properties.  

My Dimension consists of various categories with parent Leaf-categories. Each Category has an online status (true or false). Within the dimension I define the property "is\_online".
Now I want to filter the category-tree by status `[is_online] = true`

My current MDX is:

```
SELECT
  FILTER(
    [Categories].allmembers,
    [categories].CurrentMember.properties("is_online") = 'true' 
  ) on 0
FROM [Cube]

```

I get this error:

```
Property(): the property 'is_online' was not found

```

Does anyone know a solution? My Version of IcCube is V 5.1.6

[Dimension & Property definition](https://i.stack.imgur.com/ItsyW.png)

Answer: 
May be for someone next code will be useful:

```
index_row = []

# loop each row in column A
for i in range(1, ws.max_row):
    # define emptiness of cell
    if ws.cell(i, 1).value is None:
        # collect indexes of rows
        index_row.append(i)

# loop each index value
for row_del in range(len(index_row)):
    ws.delete_rows(idx=index_row[row_del], amount=1)
    # exclude offset of rows through each iteration
    index_row = list(map(lambda k: k - 1, index_row))

```
One of the reasons I found is you are initializing the value of i to 1 every time the loop is running make it as follows: 

```
i=1
for row in ws.iter_rows():
    if row[i].internal_value() == None:
        ws.Rows(i).Delete()
    else:
        i + 1

```

Rest can answer after observing the full code.