local_phone(877) 456-7632 local_post_officeinfo@msxgroup.com
Message Boards
Sign up Latest Topics

  Author   Comment  

Posts: 10
Reply with quote  #1 
As I thought I was being smart in changing my main rollup from individual segments to ranges I inadvertently deleted several of my segments from the entire database! UGH!

Since we backup each night I want to use last night's backup to restore the database. Can you give me step by step instructions to do it? I didn't know if the process included steps in Forecaster or if it was just a SQL function.

Part 2 of my question is...is it possible to change my existing rollup to ranges OR do I have to create a new main rollup?


Posts: 88
Reply with quote  #2 

There is nothing you need to do within Forecaster to work with the backup - it is a SQL Server process. Once your database is restored to the backup, you should be able to log into Forecaster as usual and it will be as if you hadn't made any changes.

As for changing your rollups to ranges... you should be able to create the ranges where you need them. However, since Forecaster doesn't allow you to have the same codes in a rollup  more than one time, you'll need to remove the posting-level items from the rollup, then you can add the range that encompasses them.

So, if you have a summary that has something like:


and you want to change that to be a range, you would delete the posting items, 100,101 and 102.  Then insert a new range under 'TOT' which is the range of 100 to 102. 

You can also create a brand new rollup if you want to do this separately and leave the other rollups intact.  When you've got it all set, you can decide whether to remove the old rollup or not.

I hope this helps. MSX Group is here to help you with all of your Forecaster needs, so if you need assistance, please contact us!

Rob Diaz
MSX Group

Posts: 10
Reply with quote  #3 
Thanks Rob!
Previous Topic | Next Topic

Quick Navigation:

Easily create a Forum Website with Website Toolbox.