Probably Passing Custom UD8 on Drilldown
I have a source cube view that has a column for actuals, budget, and then actuals versus budget.
Actuals versus Budget is just a simple GetDataCell(CVC(Co1) - CVC(Col2)). However, there's a need f...
Forum Discussion
**Original Title Should Be Problem Passing Custom UD8 on Drilldown**
I've discovered a solution but still hoping maybe someone has an idea on something that's simpler / more elegant.
My solution is to add the U8:TestUD8 tag to each component within the GetDataCell and the Member Filter itself. Example: U8#TestUD8:GetDataCell(U8#TestUD8:S#Actual - U8#TestUD8:S#Budget). So I'm basically doing the CVC(Col1) - CVC(Col2) but I'm doing it explicitly with the original column criteria. Then on drilldown the cube view Member Filter is XFBR and returning a different calculation depending on what, if anything, the UD8 is.
It's working but I'm going to have to have a separate UD8 for all of my variance (and variance %) columns as well as separate cases within an XFBR rule to return how to drilldown depending on what the selected UD8 was. So probably 20+ instances for our use case (versus budget, versus actual, % columns for both, periodic, YTD, etc.). It seems clunky but it's functioning correctly.