Forum Discussion

bmcwilliams's avatar
bmcwilliams
New Contributor
2 days ago

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 from our business partners to be able to drill down into the variance for Entity.Base (source cube view is just Entity).

My original attempt (Attempt #1) was to create a DynamicCalc UD8 to take S#Actuals - S#Budget but we have a handful of custom Accounts (A#) that aren't playing well with this approach.  However, for the accounts that do work the drilldown is working perfectly.

My next attempt (Attempt #2) was to create a non-DynamicCalc UD8 (TestUD8) and keep the GetDataCell column on the source cube view but tagged :U8#TestUD8.  The problem I'm running into with this method is that the TestUD8 isn't getting passed to the linked cube view?  And I don't know why?  I have Attempt #1 and Attempt #2 side-by-side on the same cube view and Attempt #1 will pass the custom UD8 to the linked cube view but Attempt #2 just passes None.

95% of the source cube view can be successfully drilled down on but it's the Variance column that's giving me fits.  Hoping someone can give me some guidance.

Cube View

1 Reply

  • bmcwilliams's avatar
    bmcwilliams
    New Contributor
    2 days ago

    **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.