Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

ASO Time Balance QTD YTD

edited Jan 28, 2019 9:28PM in Essbase 4 comments

Content

Hello, 

Using Version 11.1.2.3, and some of the Account members tagged as TB Last and rest are None.  Now we need to have the QTD and YTD functionality without adding a new dimension. 

I tried making Period dimension Dynamic and adding formulas for Jan YTD, Feb YTD, Mar YTD  but when I try to save the outline it says some of the account members are using time balance so the the Period dimension needs to be Stored. 

what would be the best solution? to add a new dimension like view or remove the Time balance from the accounts and add UDAs like TB_Last, TB_Average and then have member formulas for YearTotal, Q1...Q4 and add formulas for YTDs and QTDs.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!