Hi there,
I'm looking for a way to dymically pass on the selected slicer name from a cell in Excel on to a cube function:
CUBERANKEDMEMBER("ThisWorkbookDataModel";Slicer_KSt;COLUMN(A1))
As it is possible to pass variables to the mdx-strings with "&..ExcelCellReference..&", this doesn't seem to work with slicer identifications. They simply appear as textstrings in the formular and work as CUBESETS if hardcoded, but all aproaches I've tested so far in order to fetch that value from a cell in excel fail (cell references of any sort, named range: mostly return #NV).
Any idea would be gratefully appreciated!
Thanks