Hello,
I'm trying to sum up a calculated amount using Row Column Intersection and I cannot get it to work properly. I'm using Rows Override in order to sum up these calculated amounts (also using r...
I don't want to make a new UD8, because I don't really know how to do that
Investing in learning how to build DynamicCalc accounts/Flows/UDs will reap big dividends. It's not very hard either. Start from this link and go forward for a couple of pages.
I don't want to make a new UD8, because I don't really know how to do that
Investing in learning how to build DynamicCalc accounts/Flows/UDs will reap big dividends. It's not very hard either. Start from this link and go forward for a couple of pages.
So I was able to get it to work after some tinkering, but now I cannot figure out how to roll up those amounts into the parent I created. I made it set to Is Consolidated and ran a force consolidate but that didn't end up working. I compared it to a flow dimension parent, which I thought was the closest example I could use and it pretty much mirrors it identically.
Dynamics don't aggregate "naturally" like stored accounts, and IsConsolidated has no effect - because there is no number stored, ever, against those accounts/flows/uds. BUT the good news is, now you know how they work, you can simply create your own additions in another UD:
Alternatively, if you're after the sum of base Entities, you can "simulate" consolidation in another dynamic (typically on a U8) containing a call to api.Functions.GetEntityAggregationDataCell:
All of this, like CVC/CVR, will execute at report running time, i.e. for every user every time they look at the related Cube View. If you find this is slow, or you know the CV is executed a lot, it would be better to actually store those calculations, with formulas assigned to a Pass (which is executed during Calculation/Consolidation). That would make aggregation easier, but the rule is a bit more difficult to write, and I'd recommend to take some class first.
Another approach: if your calculations are all simple multiplications, it might be easier to:
create a new parent and copy the original members as children (you can do it with None too)
set the Aggregation Weight for each child, in Relationship Properties, to the factor you're multiplying by:
In this way, the parent will contain the aggregation of the original child values multiplied by their individual Aggregation Weight factor, i.e. (Child1 * AW1) + (Child2 * AW2) + (Child3 * AW3) etc.