Archiving Historical Object Instances in Business Objects
I like to answer the really good and broad-focused emailed questions through articles on this site. The following is one such emailed question:
In Business Objects is there any way to archive historical object instances?
We need to keep objects for several years, but don’t want to keep so many objects available on the server as we are running out of space on our server. We only want to keep a years worth available to the users. We want to keep only a few of them and rest of the instances be archived. The instances are of all kinds.. Microsoft Excel, txt, Crystal, pdf…etc
BIAR File Backup
One of the cleanest ways to backup almost anything in Business Objects XI is to use a BIAR file backup (Business Intelligence Archive Resource, pronounced by most like the word “beer”). In Business Objects XIR2 this is easily accomplished using the Import Wizard tool. Essentially you set the source to be your source environment and the target to be the new BIAR file. Then you proceed to select the objects you desire to backup and don’t forget to check the checkbox for instances if you want to retain them.
BIAR files are compressed and they are generally not usable without Import Wizard. If you desire to restore a report from the BIAR file backup then you must be prepared for some consequences. Restoring from BIAR file backups will NOT create new instances of your objects unless you specify these options in Import Wizard (use MERGE and have duplicates renamed), otherwise your newer objects could get overwritten. Often, it is a safer idea to have a sandbox environment to which you restore the files you want. Please not you can pick and chose the objects you want, but the instances are an all or nothing option only.
Import Wizard Tricks
If you are familiar with Import Wizard there are some cool things you can do with it. For example, you can set the source and destination to the same environment and you can use the MERGE option (with rename duplicates) to create identical copies of your objects. Also you could use it to move copies to another “archive” environment.
Working the File Repository System
If you have played with Business Objects XI’s FRS at all then you know that it is a huge pile of sub-folders and finding a specific document is like finding a needle in a haystack. I recommend against trying to access the file directly as this will consume much time and it will usually be difficult to keep track of which document is which.
Scheduling Non-BO Delivery
As instances are created you could schedule them for delivery to email, FTP, or UNC (file shares). This may not be preferable for various reason, but I thought I should add it.
Really, these are the only archive methods that I have used or experimented with. Please leave any comments of other methods that you have successfully used. The question above is from a real person who needs our help.



[...] Archiving in Business Objects – Instances – BIAR File – Import … [...]
I have been looking looking around for this kind of information. Will you post some more in future? I’ll be grateful if you will.
Julian:
I am a reader of your site for sometime. I love it. It really helped me at my work.
Quick question regarding this BIAR. Creating a backup of Universes to BIAR file will still retain Universes’ CUID am I right?
Say for example, I create a BIAR of Universe1. I have made changes to Universe1 and want to go back to old copy. I can delete the Universe1 and bring it back from BIAR, this should not in anyway affect my reports am I right?
Thanks in advance.
Bala
Thanks for the feedback! Glad you find it useful!
If I were you I would NEVER delete a universe that has any reports attached to it. The better option would be restore from the BIAR file and let the CMS handle the replacement completely. If you have doubts that it restores correctly you could always add a comment or something to the description of the universe version you wish to replace and then after replacement verify that the comment ha disappeared (since it is not in the BIAR file back-up).
If you do this then, yes, the CUID should be restored exactly as it was and all reports bound to the replaced universe should continue to be bound to it (since the CUID remains identical). Test it out, of course this is the best way to ensure you handle things properly and you can have confidence in the procedure and backup.
Thanks, Julian
Hey Julain,
I found this Website really interesting and distinct in the depth of information you provide.
I have a couple of questions on top of this article.
I have specific requirements to archive my reports for fixed number of years. After this, say 5 years, does any BO tool has capability to automatically purge the report from Repository. The Users should not be able to view any instance older than 5 years through InfoView.
Also we want to retain some instances which might be required for Auditing purposes. A 10 year old report may be requested by Auditors, which should not replace any other existing report, and to be removed once it’s purpose is met. We believe a Document managment tool can only help.
Any inputs from you on the BO front will be much helpful for us.
Thanks in advance !!
Hey Ram,
Interesting requirements. There is a time expiration for instances. This is set in number of days in CMC at the folder section. In BO XI 3.1 it seems that number 999999999 is acceptable, but I didn’t test to see if it actually works.
I am not sure if BO XI 3.1′s Life Cycle Management tool will archive your instances (through version control). Therefore, your best bets are BIAR file backup (include the instance option) or open that desirable instance and save it to a protected folder with a unique name identifying the nature of the instance.
Please remember that instances are not treated the same as reports so even tools like Import Wizard and LCM will not really give you individual, specific instance access.
I hope this helps. By the way, thanks for the positive feedback on the site! Julian
Hi,
Regarding BIAR file, I am using Import Wizard to take the backup of CMS on regular basis. What?????? Import Wizard for backup?????
Yeah, I have to because apparently that’s the only way to reproduce any report or universe which is mistakenly deleted by users. Yes, I can use last days file stores since they are backed up but that would require full restore. Import Wizard gives flexibility to choose at object level.
Q1: Is there any other mechanism to perform backup and still be able to restore specific objects?
Q2: I have to manually run the Import Wizard daily and provide the same parameters again and again. Is there a way to schedule it providing parameters somehow? (capturing the user input could be an idea but really not sure if it would work fine, or even how it would work)
Ideas please!
Thanks,
Oace
To the best of my knowledge…
Q1: No, sorry.
Q2: Nope, but you might be able to get some macro recording application to be able to do it for you. I am not sure.
Sorry, I really hope I am wrong, but I have asked the same questions of others and received these answers.
Hi Julian,
I have some questions.
Environment: BOXI R2, Oracle 10G
How to save all the instances of a scheduled report at once?
In public folder there are few reports which are scheduled each day in pdf format.
Now if you want to save a particular instance to your desktop you would click on history tab –> open that particular instance and save it.
But I wanted to know if there is any way to save all the instances at once. (If you have about 30 report instances for a month.)
The main aim of doing this is to backup all the pdf report that are generated each day.
As far as I know there is no native BO tool or functionality that will do that. For the future you could have them delivered to a file share or FTP server (or even MS SharePoint site). If you just had to have something to meet this need I would suggest looking into the SDK, but I have never done such a thing. Sorry, wish I had better news, maybe someone else has a suggestion.
Julian,
First of all thank you so much for sharing the Info. which is very helpful in my work.
I have a question regarding the BIAR file.we take backup on every week. all of sudden one user raised the concern saying i have lost all my Favourite and Personal fodlers reports are missing. than we have realized that, her name got changed after her marriage. Ex:
Gartner Ina married a short time ago and changed her lastname from Thomas to Gartner.
Since them she can’t login into BO.
The error says: “Accountinformation not recognized: The Active Directory-Authentication could not log you in. Contact your
Systemadministrator, to check, if you are assigned as a member of a valid group and try again.
Markus Fischer advised us to create a new windows profil, which we did. But it didn’t help to solve the problem.
Do you have any solutions?
Thank you So much..
All that comes to mind is to the user exactly as the user’s name is in AD. To be honest, I have never used AD authentication, so I would not value my input very highly on this topic. On the topic of this article, a BIAR file backup of the user’s old account is a good idea before you start messing around with things.
Julian,
First of all thank you so much for sharing the Info.
I need to take backup of all my users groups, reports and universe from BOXIR2 to BOXIR3.1
Please suggest me the best way to proceed????
Is the above thing is possible with a BIAR file??????
Hi Ram, if you are asking me should you take a BIAR file backup using Import Wizard prior to migrating/upgrading your system from XI R2 to XI 3.1 then I would recommend it. However, be careful that you do so in batches of 1 GB or less. BIAR files can become useless if they are too large. I can’t recall the magical size limit, but you must test each BIAR file after creation to see if it looks good.
If you are asking if you can use a BIAR file to migrate from one version to another, I am not certain that this is supported by SAP-BO. I have tested it just a little and it seems to work, that is to say you can import a BIAR file in XI 3.1 that was created using XIR2. Right now, I don’t have more information that this. If you choose this method of migration I suggest you test, test, test.
Please provide me help regarding instances of webi reports.
I want to know when the reports are created ?
ON refresh or scheduling?
Hi vivek, good question. An instance of a report is created at the moment you create a recurring schedule of a report; this is a special instance as it cannot be opened. Regular instances are created at the refresh of a scheduled report, whether the refresh and delivery are successful or not.