Hyperion Planning (MOSC)

MOSC Banner

HOW TO CLEAR DIRTY BLOCKS IN HYPERION PLANNING USING BUSINESS RULE

edited Nov 8, 2016 4:00AM in Hyperion Planning (MOSC) 5 commentsAnswered

Hi gurus,

I want to clear blocks that were created with accident. First of all, we  combinations with a number "1":

FIX(@relative("Alquileres",0),@relative("UOR",0),"Formulado")

"IN001"=1;

ENDFIX;

After that we empty this blocks using this command:

FIX(@relative("Alquileres",0),@relative("UOR",0),"Formulado")

"IN001"=#Missing;

ENDFIX;

We noticed that database increase as doble size. Finally we decide to use this command:

FIX("Formulado")

CLEARBLOCK EMPTY;

ENDFIX;

But the database size did not reduce.

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