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

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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