(877) 456-7632 info@msxgroup.com
Message Boards
Register Latest Topics
 
 
 


Reply
  Author   Comment  
jfinnell

Registered:
Posts: 8
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?

Thanks!!
Rob.Diaz

Moderator
Registered:
Posts: 87
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:

TOT
     100
     101
     102

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
http://www.msxgroup.com
jfinnell

Registered:
Posts: 8
Reply with quote  #3 
Thanks Rob!
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.