This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Y-T-D with fixed values

February 19 2013 at 5:48 PM
No score for this post
Jeff 
from IP address 12.70.211.195

In my db, I track calendar billing days, and those are hard-coded using the @ISMBR function. Jan-13 then = 22.5, Feb-13 = 20, etc.

I tried updating the formula to include YTD days so that, for example, Y-T-D(Feb-13) = 42.5 but Essbase does not like that.

Is there a way to assign a valid to a Y-T-D Billing Days, where Billing Days is a member name in the Account dimension.

I do have Jan-13 as a member in my Time dimesion, while Y-T-D is an active Dynamic Series Member. Perhaps that is why the ISMBR formula works with Feb-13 but not with Y-T-D(Feb-13).

I have not been to any Essbase training classes, just picked up what I know from the person who did it before me, so hopefully I have listed enough info for a reply.

Thank you for your time.

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Y-T-D with fixed values - Javier on Feb 19, 2013, 10:11 PM
    1. Y-T-D with fixed values - Jeff on Feb 20, 2013, 12:52 PM
      1. Re: Y-T-D with fixed values - Javier on Feb 20, 2013, 1:46 PM
        1. Y-T-D with fixed values - Jeff on Feb 20, 2013, 2:22 PM
          1. Re: Y-T-D with fixed values - Javier on Feb 20, 2013, 2:54 PM
            1. Re: Y-T-D with fixed values - Javier on Feb 20, 2013, 2:55 PM
     
  2. Re: Y-T-D with fixed values - Jake Turrell on Feb 20, 2013, 3:42 PM
  3.  

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.