How to Migrate Personal Folders in BO

Video (slideshow) walkthrough: How to migrate specific User Folders (BO XIR2) or Personal Folders (BO 3.1 +) using Import Wizard.

Topics Covered:
1) Creating custom group and assigning desired users to the custom group
2) Migrating using Import Wizard


A problem I faced when migrating from XIR2 to 3.1 is that when I wanted to migrate specific users' or specific department's users' favorite folders. Import Wizard would only allow me to select a group, and not individual users. So, I decided to create a custom group in CMC and assign specific users or specific departments (i.e. groups belonging to those departments) to this custom group. Now, the Import Wizard would let me select this custom group to migrate, and I'd have total control over it. I can decide whether I put 1 user in this group from CMC or 100. Short video below quickly goes over the steps. Enjoy!

SQL Basics in 30 Minutes - Part 2

Topic: SQL Basics in 30 Minutes - Part 2: We'll dive into CREATE command. We'll 'Create' Tables, Temp Tables, Table Variables and Variables. We are going to 'Insert' data into this table (INSERT INTO) and we'll occasionally 'DROP' the tables.

Advertisement:

Buy SQL Books from Amazon.com

SQL Basics in 30 Minutes - Part 1

Topic: SQL Basics in ~30 Minutes - Part 1: Visual demonstration of Select, From and Where clauses in SQL Server 2005. I've created a little table in Excel so beginners can visual these SQL commands. 

Business Intelligence and SQL go hand to hand. You cannot be an expert BI Consultant without knowing SQL proficiently. Sure, in a large enterprise scenario, BO Admins and Architects for example may never need to type a single SQL query, but you are not likely going to be a confident consultant. In the world of BI, SQL is your best friend!

This part 1 is for absolute beginners. I didn't wan't to jump into creating tables and stuff, and thought maybe it'd be helpful for the beginners to kind have most of the important commands in one short video series. I am going to cover few more important SQL commands in the next 2 videos including Create (Tables), Insert Into, Views and more.



Advertisement:

Buy SQL Books from Amazon.com

Quick steps to recover BO content from Backup

Steps to recover Business Objects objects, including all types of Reports and Universes, from Backup. (look for a better, more detailed version in BO Admin guide)


You always have the following 2 components in a BOXI environment: CMS Database and Filestore folder. We'll call the current/present versions CMS_DB and Filestore. 


1) Stop all BOXI services from CCM.


2) Get a copy of CMS_DB from yesterday or whenever you had a proper working BO environment, from where you could retrieve your lost objects; rename it to CMS_Backup. System Admins or DBA will get you this. Place CMS_Backup in any DB server. 


3) Rename your current Filestore folder to Filestore_Current. 

4) Get a copy of the Filestore folder from the same date as you got your CMS_DB backup in #2; put this in the same directory where you have Filestore_Current. 

5) Create a Data Source X (ODBC or whatever u guys use) and point to CMS_Backup.

8) Point CMS (service) from CCM > CMS > Configuration > using X to CMS_Backup. 

9) Start CMS, Input File Repository, Output File Repository. BO will act as if it's in the past; we'll call this BO Historic. 

10) Start Import Wizard and Import your lost objects. Source BO > Destination BIAR > browse and pick your Reports, Universe, etc from this BO Historic > BIAR them. 

11) STOP all BO services

12) Rename Filestore (which is really from Filestore folder from backup) to Filestore_Backup. 

13) Point CMS to your CMS_DB using the existing Data Source. 

14) Start ALL BO services. 

15) Import your lost objects from the BIAR file to present environment. Import Wizard > Source BIAR > Destination BO > Automatically Rename blah blah blah > done.

BO 3.1 Deployment Part 2 - Installation

Video Walkthrough: Steps to perform the initial installation, including pointing the BOE 3.1 installation to existing CMS and Audit databases, deploying TomCat and IIS web servers, introduction to Server Intelligence Agent and a quick glance at the 3.1 CMC.

BO 3.1 Deployment Part 1 - ODBC

This is the beginning of the series of videos that will cover a complete deployment of Business Objects R 3.1 in VM Windows 2003 environment with SQL Server 2005. 

Video Walkthrough: Assuming your DBA (or you) will create the 2 databases for a BO 3.1 deployment, we will start off with the creation of ODBCs pointing to these DBs, which are of course a CMS database and an Audit database. 

Universe LOVs are bad for your health

Well, it's bad for the health of the environment. And if your BO environment is not healthy, you'll be bugged constantly by users--'...oh this report is so slow...ohh, the dates don't load up properly...ohh, Business Objects is acting weird...' and so on. Ring a bell? :) And thus, you too will be sick; sick and tired of complaints and not knowing what the heck is up in your environment.


Topic Intro: Properly designing Universes so that unnecessary LOVs do not get associated with objects.

Video Walkthrough: We're gonna go over the basic steps required to identify objects that should not have LOVs associated with them and how to proactively avoid the problem from universe by disassociating the LOVs options in objects' properties.