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))

```
This script iterates through all worksheets in the workbook and delete rows in list "rows\_to\_delete". Be sure to remove any table formatting before running the script. In other words, you want to convert your table to a normal range first.

```
import openpyxl
rows_to_delete = [None, '', ' ']
for i in wb.sheetnames:
    print(f'Now in sheet: {i}')
    ws = wb[i]
    # loop each row in column B
    column_b = range(1, ws.max_row)
    for i in reversed(column_b):
        if ws.cell(i, 2).value in rows_to_delete:
            print(f'Deleting Row: {ws.cell(i,2).row}')
            ws.delete_rows(ws.cell(i,2).row)

```