Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Workforce cube design help — Cloud Customer Connect
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

Workforce cube design help

Accepted answer
23
Views
5
Comments
edited Jun 16, 2020 3:31PM in Planning 5 comments

Content

Hi Experts,

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.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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