I use process in which I recreate hierarchy by attribute for certain dimension. I would say it is standard:
Code: Select all
cDimName = 'Customer';
sAttrName = 'Customer Group';
sBlankSubstitute = 'No Cust Group';
sRootName = 'All Customer Groups';
sHierName = 'Customer Group';
IF ( HierarchyExists ( cDimName , sHierName ) = 1);
HierarchyDestroy ( cDimName , sHierName );
ENDIF;
CreateHierarchyByAttribute( cDimName, sAttrName , sBlankSubstitute , sRootName );
So I was thinking about three solutions:Error: Prolog procedure line (74): Cost Plan Dimension Update Fail. Rule Is Invalid. Until rule is fixed
- turn off rules in prologue of the process and then turn them on in epilogue (is it possible?)
- finding function that recreates hierarchy by attribute that don't require using HierarchyDestroy before (using CreateHierarchyByAttribute without using HierarchyDestroy before returns error)
- creating my own alternative hierarchy based on attributes without using function CreateHierarchyByAttribute and just use HierarchyDeleteAllElements instead of using HierarchyDestroy before
I would appriciate any recommended logical approches to this issue
Regards,
Michal