How I can make a rule less slow

Mar 26, 2026 11:34AM

Hi all,

I’m experiencing a performance issue with the following rule, which is taking a very long time to run:

SET UPDATECALC OFF;

SET AGGMISSG OFF;

SET EMPTYMEMBERSETS ON;

FIX ("FCCS_No Movement", "FCCS_No Intercompany", "FCCS_Periodic",

@Relative ("Custom3", 0),

@REMOVE (@Relative ("3TC00000", 0), @List ("0405014", "0405016", "0405036", "0407001", "0407002", "0407003", "0407004", "0407005", "0407007", "0407008", "0407013", "0407014", "0407015", "0407016", "0407017", "0407018", "0407020", "0407021", "0407022", "0407023", "0407031", "0407041", "0407049", "0407050", "0407051", "0407055", "0407060", "0407061", "0407062", "0407063", "0405001", "0407006", "0407009", "0407019", "0407037", "0407099", "0403008", "0405012", "0405022", "0405026", "0405032", "0405033", "0406009", "0422003")),

@Relative ("3AMTI000", 0),

@REMOVE (@Relative ("3ALT0000", 0), @List ("0413007", "0413008", "0413009", "0413010", "0413013", "0413021", "0414005", "0414006", "0417005", "0417006", "0510007", "0510008", "0510010", "0512003", "0512008")),

@REMOVE (@Relative ("Custom1", 0), @List ("No Custom1", "CC033", "CC034", "CC036", "CC037", "CC038", "CC039", "CC040", "CC041", "CC042", "CC043", "CC047", "CC996", "CC997", "CC998", "CC999"))

)

FIX ("ALLOC1")

CLEARDATA "FCCS_Supplemental Data";

FIX (@REMOVE(@Relative("Custom2", 0), "No Custom2"))

"FCCS_Supplemental Data" (

IF ("FCCS_Managed Data"->"No Custom2"->"No Custom4"->"GRP_MAN" <> #MISSING)

Hyperion Essbase (MOSC)

How I can make a rule less slow

Howdy, Stranger!

Category Leaderboard

Top contributors this month