This content has been marked as final. Show 5 replies
If you are using Hyperion Planning or Essbase then I tend to use the concept I picked up from the add-on modules for Hyperion Planning (CapEx & Workforce) where they use a Dynamic Calc member in the database called 'Cal TP_Index' / 'Fisc TP_Index'.
Formula for 'Cal TP_Index' is:
For 'Fisc TP_Index' you simply restate the above replacing Jan with whatever your first fiscal accounting period is, Quarters and YearTotal also need to change, i.e. if you year runs April - March (common in the UK) then Apr = 1, May = 2, Mar = 3, Q1 = 6, Q2 = 9, YT = 3 etc...
Hope this helps
I don't think so, I think that the IfThen function would be your only possibly chance but this is limited in FR from memory, I think you can only evaluate numeric conditions and return numeric true/false results.
I can understand you not wanting to add to your db but it really isn't difficult, and as it is 'dynamic calc' (assuming your Accounts dimension is dense) it doesn't add real overhead to performance.
Hope you get it sorted