PBCS Period DImension and ASO dynamic calc
Summary
Anyway around no dynamic hierarchy in Period Dimension in PBCS?Content
Hi,
this is part #2 of this -> https://cloudcustomerconnect.oracle.com/posts/26d26d8176?commentId=539788
Having done the BSO calc formula and got it working in the Period dimension I then turn my gaze to the ASO formula.
Fairly simple piece of MDX later I think job done and having saved it to my Period dimension member I try to deploy it.
No, says planning, for ASO dynamic calc formula it must be a dynamic hierarchy, at which points my memory alarm bells start to ring as I remember a similar struggle with D-T-S for ASO and resorting to an alternative hierarchy with straight roll up having failed to resolve the issue.
0