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

 Return to Index  

Try this

April 13 2012 at 10:53 AM
No score for this post
Alan Hutchins 
from IP address 80.169.116.4


Response to CapEx Database Design Queries

 

There are several ways you could do this, 2 of the more simple ones are as follows:

1 - Create a status dimesnion with your 3 members - but that could have some downside if you need to get a project cost total

2 - alternatively, set up a sub-group in the accounts dimension called "Project Status", and update the project Status each month by loading a 1 against the correct status (ignore the other states.

This will allow you to see when and how long each project was Active, and identify the "complete" and "closed" month as well.


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

  1. Smart List - John A. Booth on Apr 14, 10:17 PM
  2.  
 Copyright © 1999-2014 Network54. All rights reserved.   Terms of Use   Privacy Statement  

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.