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: 
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.
There are lots of reasons why openpyxl doesn't provide this possibility but you might be able to work something out based on this snippet:
<https://bitbucket.org/snippets/openpyxl/qyzKn>

Otherwise have a look at xlwings for remote controlling Excel without having to mess with COM.