Hey all, I have a script that consolidates all the totals of one attribute into one of the organizations and zeros out the rest. The problem is that per usual, if the block doesn't exist, the calc doesn't run correctly. I'll give an example.

FIX((@DESCENDANTS("Company 19")
"Budget" = @SUM(@WITHATTR("Cost Center", "==", @attributesval("Cost Center")));
ENDFIX;

Example, I have ten organizations with the same cost center of 1000, 10-1000,11-1000...19-1000. I'd like to consolidate all of those amounts into the Company 19 amount. The problem is if the block isn't created for 19-1000 there's nothing I can do. Also, according to the calc above, "Budget" is dense so I can't use createblockoneq. We have loads of organizations, so I can't us the organization on the left side of the equation. Any idea? Can I run an if statement and set createonmissingblk on if there is an amount in one of the ten? I can't set createonmissingblk for everything because it will make the cube WAY too big.

Ideas?

I have had success using SET CREATENONMISSINGBLK ON;

Good luck,

Tim

The command "SET CREATENONMISSINGBLK ON" does work, but it creates way too many blocks. I'd only there are around 10,000,000 possible combinations, but only about 40,000 entries in the GL. I was curious if there was a conditional way to turn that on.

And If you use:

SET CREATEBLOCKONEQ ON ;

I have a dense member on the left, so that won't work either.

See Glenn's suggestion here:
http://forums.oracle.com/forums/thread.jspa?messageID=4014018

Note his comment that you will need to put the formula into a calc block to get it to work.

Regards,

Cameron Lackpour

Thanks so much!