Hello everybody,
i have an issue with the
Function SAPBEXsetFilterValue(intValue As String, Optional hierValue As String, Optional atCell As Range) As Integer
Filtering with cell atCell (if this parameter is missing, then the active cell is taken as the basis)
The internal filter value must be entered in the parameter intValue. Please note that this value can be displayed differently from the external value displayed in the filter cell. You can either use SAPBEXgetFilterValue or carry out the filter process once manually with the log book function switched on in order to determine the internal value for a known external value. The internal filter value is noted in the log.
Enter the parameter hierValue when dealing with a node of a certain characteristic hierarchy with the filter value.
"intValue = <blank>" means "do not filter anymore"
If no connection to a BW server exists the function starts a logon dialog.
The function produces a context error if atCell is not a filter cell.
My problem:
i would like to select inner nodes. With one node it is not a problem. I have just to use the technical name for the inner node as intValue. But I would like to select more than one node. I would like to filter 4 inner nodes with the SETBEXgetfilter command but it does not work.
i tried also to set them iteratively but when the second filtervalue is selected the first will be overwritten.
If i select more than one navigation panes to filter the nodes differently on a seperate navigation pane it also does not work because all navigation panes are connected and show the same.
Does anybody know how to filter more than one node in the same hierarchy. manually it works. So there should be a way to do that with VBA.
Thank you in Advance and kind regards,
Murat