XFBR CubeViewHelpers passing dimension question

Dan_Welcheck
New Contributor

Hello Community,

I have an issue, hopefully someone has a solution.

I started with this article:

https://blackdiamondadvisory.com/library/breaking-up-is-easy/

to try to get a grid/chart that some users want.

My problem is I’m trying to get it set up for so for the current year it shows two rows, one for Actual and one for Forecast, but only shows data for actual up to a selected period and only shows forecast for the periods after the selected cut off.  I’m trying to do that by selecting the U8# of “data” or “None”

 

Here’s what my rows look like:

Dan_Welcheck_0-1724790442358.png

 

Dan_Welcheck_1-1724790442359.png

 

Here’s my column as it pertains to these two rows (using overrides for the prior year rows, which work fine)

Dan_Welcheck_2-1724790442360.png

Here’s the function which I think is working,

Dan_Welcheck_3-1724790442366.png

 

The issue is trying to pass the scenario in my XFBR.  Everything I tried is passing “Actual”.  I tried CVScenario, PovScenario, MFScenario (this one failed).  How do pass the specific cell or row’s scenario for consideration in a column CubeViewHelper depending on which row is being evaluated?

Thanks for any guidance that can be provided.

0 REPLIES 0