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: 
2018 update: I was searching how to delete a row today and found that the functionality is added in openpyxl 2.5.0-b2. Just tried and it worked perfectly. 
Here's the link where I found the answer: <https://bitbucket.org/openpyxl/openpyxl/issues/964/delete_rows-does-not-work-on-deleting>

And here's the syntax to delete one row: 

```
ws.delete_rows(index, 1)

```

where: 
'ws' is the worksheet,
'index' is the row number, and
'1' is the number of rows to delete. 

There's also the ability to delete columns, but I haven't tried that.
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.