adding members to AppShell's TIME dimension.

5.1 SP3 AppShell only comes with calculated TIME members 2005.TOTAL through 2008.TOTAL which I think is ridiculous. It's seems pretty straightforward to add future calculated time members because the TimeID can be properly sequenced.

My question is how does one add 1998.TOTAL, 1999.TOTAL, etc. with AppShell's existing TimeIDs? (I've already copied the FINANCE app to create my own EXPENSE app and now want to import members from BPC 4.2sp3 which contains historical data from 2000 through 2004.

Do I use UserTimeID property and process the TIME dimension? If so, what results should be expected? Will the app automatically update the TimeID property? (similar to how NewID column updates the ID in other dimensions?)

Should I just update all of the TimeIDs and have 1998.TOTAL start with 10000002.

or

Should I just add the new time members and have 1998.TOTAL start at say 09999960 (or whatever number is apporpriate) so that 2005.TOTAL remains 10000002?

Any help would be appreciated.

-Ara

Edited by: Ara Toroyan on Aug 14, 2008 6:28 AM

Edited by: Ara Toroyan on Aug 14, 2008 6:30 AM