Forum Discussion

Gert_VCC's avatar
Gert_VCC
New Contributor III
2 years ago

Can you use Parameters with the Excel Add-in or in Spreadsheet

I am trying to build a quick view where the Member Filter refers to a parameter but E#|!prm_Entity!| produces this error in Excel: #ERROR - The member filter contains unresolved parameters.   ...
Excel Add In
Ioana's avatar
Ioana
New Contributor III
2 years ago

Hi Gert,

To my knowledge, Quick Views require the member name. However, if you prefer working in Excel, you can import a Cube View into the worksheet that includes that parameter. While it's not as flexible as a Quick View for ad hoc analysis, the Cube View within the worksheet allows for the use of dynamic parameters.