I would like to ask if anyone ever had this problem: My database only stores one months of data. To enable longer period trending I would like to prevent the “Overwrite” of old data (at “Refresh” ) with new data in the Reported so that longer trands can be displayed end to end… Has anyone ever tried to do this? Is there a trick to do this or failing all this does BOb Version 6.0 make it possible?
Playuser 
(BOB member since 2003-09-15)
Hi,
Is it a condition that the refreshed report must ber saved in repository with the same name?
Is it ok if you refresh the report and then save the refreshed report with some different name.
Jignesh Shah 
(BOB member since 2004-03-31)
hummm
I don’t think it is possible in a normal way. Bo reports aims is not storing datas (it’s database goal)
so, if you want to display this datas on bo, you must have it in database.
With 6.1.x, you can duplicate data
A good way could be at month M, duplicate the query 01 then you will have query 01 (and his microcube) and query 02 (duplication of query 01 with the same microcube)
and you make this query 02 no-refreshable
at month m+2, you refresh query 01 and you wtill have month data with query 02 etc etc
is that you want ?
bernard timbal 
(BOB member since 2003-05-26)
You might be able to achieve that using VBA/SDK, look here for starters.
Andreas 
(BOB member since 2002-06-20)
Thank you all. I guess the answer is another Microsoft Access!
Playuser (BOB member since 2003-09-15)