For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!
Hi All, As part of our daily ETL, Restructure cube job will be executed from EPMA command which is a scheduled using cronjob. Usually, this job gets completed in less than a minute. However, now it is consuming around 15 minutes to finish. This scenario is happening intermittently. I would like to understand the possible cases which will cause this. Please advise.
NOTE: I knew that any change to dense dimension will run the restructure longer. So, I have checked it and the there was no changes made to the dense dimension which is ACCOUNT.