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: 
As far as I know openpyxl provides no way to delete rows. You may use [COM](https://sourceforge.net/projects/pywin32/files/pywin32/Build%20217/) instead, e.g.:

```
import win32com.client

filename = 'c:/my_file.xlsx'
sheetname = 'Sheet1'
xl = win32com.client.DispatchEx('Excel.Application')
wb = xl.Workbooks.Open(Filename=filename) 
ws = wb.Sheets(sheetname)

begrow = 1
endrow = ws.UsedRange.Rows.Count
for row in range(begrow,endrow+1): # just an example
  if ws.Range('A{}'.format(row)).Value is None:
    ws.Range('A{}'.format(row)).EntireRow.Delete(Shift=-4162) # shift up

wb.Save()
wb.Close()
xl.Quit()

```
```
openpyxl.worksheet.worksheet.Worksheet.insert_rows()
openpyxl.worksheet.worksheet.Worksheet.insert_cols()
openpyxl.worksheet.worksheet.Worksheet.delete_rows()
openpyxl.worksheet.worksheet.Worksheet.delete_cols()

```

Specific row:

```
ws.insert_rows(7)

```

Column range (same for row):

```
ws.delete_cols(6, 3)

```

From the [OpenPyXL documentation](https://openpyxl.readthedocs.io/en/stable/editing_worksheets.html)

(This is a 2018 feature, so remember to upgrade: python3 -m pip install openpyxl --upgrade)