I've been playing with this function and I don't understand the support in AppStudio.
I have a test cube with three dimensions -- Period, Measure and Channel. I filtered out the CHANNEL.
I just use this formula in the spreadsheet.
=NOTEGET("MYSample";"LOADTEST";D7;C8;ReportObjects.CHANNEL.Text)
My expectation was either that the Channel dimension is ignored, so I always see the note whatever channel I select, or that I can leave the channel out of the formula. If I leave it out, nothing comes back. If I put it in, the cell note is only showed for the element "Indirect". I guess that the the first or last element in the physical dimension.
The oddest moment comes when I Choose "Direct" in the combobox and enter a cell note. It just vanishes. But when I switch to "Indirect" it reappears.