Try thisApril 13 2012 at 10:53 AM
No score for this post
|Alan Hutchins |
from IP address 22.214.171.124
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.
- Smart List - John A. Booth on Apr 14, 2012, 10:17 PM