Missing blocks for customized CTA calculation
Summary:
We created a customized calculation in insertion rule 30 to calculate the CTA accounts per client request. These CTA accounts use UDA "CTA" to mark them, and the actual EOP accounts are in the CTAalias table. However, the blocks are not created automatically. We are currently manually loading zeros for the missing blocks, but the process is cumbersome due to the client's numerous alternate entity hierarchies. Is there a better way to automate this process?
This is a DSO cube, and the account is a sparse dimension. It seems we need to find the CTA amount in the parent currency and send it to the entity currency. Even if we want to manually write zeros to the intersection, we don't know which insertion point to use.
Tagged:
0