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
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.
...
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.
Hi Ioana,
This did work to have parameters drive the cube view. Unfortunately, since I put metadata in the POV to get as many of the dimensions in the report as possible I run into an issue that those dimensions will not allow relational filtering. For example: O#Top.Base does not work in POV and therefore I am limited to a single member of that hierarchy in the Cube View due to the column and row restriction of 6 each.
In order to get a proper view of the data I need to be able to see the base. Having users open this cube view multiple times to get all the Origin members does not work.
That being said is there a way to build up the data table and loop through origin members? Maybe something in Dynamic Dashboards that would allow me to add a cube view for each listed metadata member?