Pages

Subscribe:
Showing posts with label BOE. Show all posts
Showing posts with label BOE. Show all posts

Tuesday, 6 March 2012

Business Objects Administration – Backup and Recovery

Hello BOOglers,
Backup and Recovery in Business Objects is going be the topic of discussion today.
A backup and recovery plan consists of making copies of data which may be used to restore the original content in the event of data loss. The plan aims to minimize the disaster effects on the daily operations so that the environment can resume critical business functions quickly.
As part of a BOE disaster recovery plan, an implementation of redundant servers in a backup system, which mirrors the primary system, can also be included. If the primary system goes down, still the disaster recovery system is available.
Backup process in Business Objects
We can always go with either Cold backup or hot backup based on the scenario.
Cold backupHot backup
Needs downtime as CMS, FRS will be stoppedNo downtime of the system
assures accurate system snapshot, since no transactions can occur during the backupCan’t be assured as accurate because users may still accessing the system.
Suitable for complete system backupSuitable for partial backup
What to backup?
It is always recommended to back up BusinessObjects system on a daily basis for all the below components unless otherwise they are modified.
  • CMS tables and Audit tables
  • File Repository Server
  • Database Connections
  • Custom applications (java/.Net code)
What to consider?
  • How often the backup needs to be taken on BO content?
  • How much time is taking to complete the backup process?
  • How long the downtime of the system if it is the cold backup?
Things to be ready before backup process
  • Ensure that there are no scheduled reports/Federation jobs running during the backup process time window.
  • Users must be communicated regarding the backup process so that they can plan their report schedules, etc.
  • For hot backup it is always suggested to run the Repository Diagnostic Tool to make sure the CMS and FRS are in sync.
Recovery process in Business Objects
Regardless of whether a cold or hot backup, recovery process should be simple and clear-cut. The high level sequence of steps to be followed for recovery process as specified below.
  • Stop all Business Objects services.
  • Restore the backup of the CMS and Audit database.
  • Configure the all the ODBC sources to point to the restored database and report source.
  • Restore the Input and Output File Repositories (FRS)
  • Start all Business Objects services.
If you are planning for a partial recovery you need to import the content to be restored from a BIAR file using Import wizard.
Thanks for reading!  Read More about  Business Objects Administration

Wednesday, 29 February 2012

Business Objects Content Management planning

Hi BOOglers,
Let us resume with Administration track once again with Content management planning in Business Objects. Hope this is going to be more interesting and helpful for the Administrators to start up with.
Content management plan is a collection of procedures used to manage Business objects work flow in a collaborative and manageable environment. This ensures who needs access to what. While planning for Business Objects enterprise system appropriate content management planning is an important factor. Because of lack of expertise and time we always end up with BOE environment which is not structured properly, as a result BOE environment will become more difficult to manage and maintain.
Below are simple measures to consider in order plan for our BI content.
  • Easy to understand the hierarchy and secure implementation
  • Ensure users only accessing documents which they interested and authorized to.
  • Efficient structure so users are able to search the info they need easily
  • Easy access to information in the system will increase effectiveness of using the system.
Points to be consider for the Content management Planning
1. Creating a folder structure and organizing objects
As a first and foremost step we need to segregate the BI content according to users who is going to consume the information. This will enable us to decide the folder hierarchy of the system.
For example, for set of reports to Marketing department, we will manage them in the Marketing parent folder. Then we have a subfolder called Marketing- Americas or Marketing-Asia Pacific where reports can further be separated.
2. Organize users by creating a Group/User structure
Now we need to organize user group structure that will allow access to BI content. This will be similar to the folder structure, in our example we will be having a Marketing group each further categorized basd on the region.
3. Set access levels for folders and objects
Next we need to establish the security access levels for folders and objects contained in our group/user structure. This is extremely critical as we may risk in setting inappropriate security access levels for our users. Determining the needs of our users will help us establish who needs access to what folders and objects within the system. For example only users of the Marketinggroup can access the Marketing folder based on their functional roles.
Custom access levels created for each functional user group is depicted as below.
And finally this is how security is applied on Folder at Group level.
4. Creating corporate categories and assigning objects
The advantage of categories is that it will help the uses to search and access the reports that are appropriate to them. This can be configured according to uses requirement.
For example, the Marketing department user search for reports that are specific to vendor evaluation,
Even if the vendor related reports managed across different folders, we can create a separate category called Vendor management and group the corresponding reports in the Vendor management category. As a result the user not necessarily needs to go to every folder and search for the required report. They can simply access the category with which they authorized to access with.
In the below screen though the reports Marketing Dashboard and Sales Dashboard physically exist in Marketing and Sales folders respectively, still they can be accessed from Vendor  Management category.
The above are the initial steps that we can take to create a planned content management system with which we can end up with success.
I look forward to your inputs and feedback. Thanks for reading!