Forum Discussion

kmd's avatar
kmd
Contributor II
21 hours ago

OS V9 Excel Add-in Parameters Feature

Hi all,

I've been playing with this feature for a bit and it would appear that if you've made a cube view connection to a CV that contains parameters based on "Member Dialog", those parameters don't seem to work as expected.

The resulting worksheet does create a space for those parameters but in the cell where you would select your member, there is no dropdown available to open and choose.  The cell is completely blank.  Upon refresh, I am prompted for those member dialog parameters but even the result I choose is not returned to display on the sheet.  Doesn't seem to be any issues if the parameter is based on a Member Filter.

Am I doing something wrong or is the use of Member Dialog parameters in Excel add-in simply not possible?  There is nothing in the existing documentation that I can find that discusses this.

Attaching a screen capture of the Excel results:

 

Cube View
Excel Add In
Parameters

1 Reply

  • kmd's avatar
    kmd
    Contributor II
    21 hours ago

    Adding to the above, when I refresh the sheet, the Member Dialog parameters DO come up in the prompt and behave as expected.  They just don't seem usable / recognized from the spreadsheet itself.