Workforce cube design help
We are buiding a EPBCS workforce cube for 10k employees across 6k jobs. In addition to these members in Employees and Jobs we have 3 custom dimensions with around 1000 lvl 0 members each.
Would this mean very slow calculations because of large number of sparse combinaions? Could some one help me with estimating what would be the run time for a rule that would run for all employees...Ex:"OWP_Process loaded data".
Also for each employee, there would be only member that is valid from each of the custom dimension. Would it be better to use the attributes instead of having them as dimensions? Is there a limit on the number of attribute members we create per one attribute dimension? I would potentially have 1000 attributes per each attribute dimension.