Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

Re-posting my question here because it might be more appropriate than the Planning forum

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 a bit 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


Howdy, Stranger!

Log In

To view full details, sign in.

Register

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