Ownership percentages are relationship (parent/child) specific. Your
formula currently only runs on base and local, which is not relationship
specific. You will need to pass a specific parent in for the entity you
want the ownership value for. The ap...
If it helps, I have a client with this design/similar issue with
sparsity and around 75k members in UD1 with no performance issues on
drill downs in excel/app. The key is to make sure you have suppression
on before drilling down on a quick view/cubev...
In addition to other responses, I would consider a simple 2 cube
approach (TopEntity cube and BaseEntity cube). In the TopEntity cube,
you have a can have a summary UD1 dimension that stops at
TotalCostCenter. In the BaseEntity cube, you can extend U...
It sounds like you are missing entity assignments. Make sure you are
assigning the entities to the workflows you are locking if you want to
prevent data changes after a workflow gets locked. If you need to lock a
portion of the entities data and not ...