Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Dynamic rule referencing a different account depending on frequency

IGMApr 16 2021

Hi,
I am trying to write a dynamic HFM rule which would reference a different account depending on frequency,
For Periodic View I'd like the account KD402450 to be divided by account KD402200 but for YTD view it should be divided by account KD402210. Is this possible? The following code does not seem to work for me - account KD402210 seems to be used for both frequencies.

Sub Dynamic_KDs(bLog)
HS.Dynamic "A#KD402310.V#Periodic = A#KD402450.V#Periodic/A#KD402200.V#Periodic"
HS.Dynamic "A#KD402310.V#YTD = A#KD402450.V#YTD/A#KD402210.V#YTD"
End Sub

This post has been answered by Jeo123 on Apr 17 2021
Jump to Answer
Comments