You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Intelligent agg with ILANCESTORS

I have a data form with two sparse dimensions on the row (CC, Product). Groovy determines my edited members for both dims. I need to run an agg on save but would like it to aggregate intelligently so that it only aggregates up the dependent ancestors to optimize performance. Running AGG(CC,Product) is too slow. I tried this but it's not producing a correct aggregate value:

FIX(Budget_Request)
        FIX(@ILANCESTORS(@LIST("CC1","CC2")))
        	@ILANCESTORS(@LIST("Product1","Product2"));
        ENDFIX
        
        FIX(@ILANCESTORS(@LIST("Product1","Product2")));
			@ILANCESTORS(@LIST("CC1","CC2"));
        ENDFIX
ENDFIX

Data:

CC1->Product1 = 10
CC2->Product2 = 15

TotalCC->TotalProduct = 10  (This should be 25)


Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!