Hyperion Essbase (MOSC)

MOSC Banner

Using maxl Clearing particular region of data taking more time than original data load

edited Aug 2, 2017 5:00AM in Hyperion Essbase (MOSC) 8 commentsAnswered

I Have a maxl script which basically peforms below operations:

1.Clear the specific region of data

2.Loads data into cube with buffer id

Maxl statement for Clear region:

alter database cubename .dbname clear data in region 'Crossjoin({([Scenario])},{Descendants(Member)})' physical;

The above statement is executing almost 50mins in production environment, whereas it is comparatively higher than our original full data load.

Please advise why the clear region statement alone taking much time??Thanks in advance!!!

Regards,

Lakshmi.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center