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.