Intelligent agg with ILANCESTORS
in Essbase
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
Tagged:
0