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 ...
I believe since this is setup in a DM sequence doing TopEntity.Base,
@bk0615, will also need to set the variable in to the globals object so
other entities can refence the value.