The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Gert_VCC's avatar
Gert_VCC
New Contributor III
1 year 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
EGalanzovsky's avatar
EGalanzovsky
Icon for OneStream Employee rankOneStream Employee
1 year ago

Hello Gert,

QuickView can not read parameters, but QuickView can read XFBR.

So you can not pass the parameters into XFBR bt you can call XFBR without passing the parameters.

XFBR(Workspace.VCG_STP_Blend.VCG_STP_Blend.ParamHelper, GetSelectedEntity)

But that one does not work

XFBR(Workspace.VCG_STP_Blend.VCG_STP_Blend.ParamHelper, GetSelectedEntity, SelectedEntity=|!cv_SelectedEntity!|)