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.
Meant to reply to the post from Ioana not the original post.
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.
Hi Ioana, Thanks for the suggestion. Will that cube view still be restricted to max 12 dimensions? I need to see 16 out of the 18.
I would suggest using the FdxExecuteCubeView method where you build your Cube View, define all dimensions, and then create a data adapter - type method - where you call the FDX, so you will get extract the CV information in the layout you need, and you can also pass parameter values in there. I do not think the Cube View will get you to the desired display. Also, if you need to extract large datasets, this method is performance oriented.
Here is a good example of using FDX to extract CV data, and you can adapt it to your case: FDX Cube View Rule | OneStream Community
Thanks.
