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?
