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

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.