Tag: BO

What is Business Views?

| April 9, 2010 | 0 Comments

> What the heck is Business Views?? That’s what I said to myself when I saw Business View Manager for the first time! So, don’t worry if you haven’t used Business Views or are just found out about it. It’s pretty straight forward and easy. I learnt it in 15 minutes basically, simply by trying […]

Continue Reading

Auto Restart BO Servers with a Batch job and Schedule it

| December 25, 2009 | 1 Comment

Video walkthrough (all the way at the bottom): How to automate Business Objects’ Services/Servers in Central Configuration Manger so that they restart every night, every week or however you’d like to schedule them. Topics Covered: 1) Creating a batch job to restart any/all Business Objects Services 2) Scheduling the batch job according to the need of your environment Business […]

Continue Reading

How to Retreive List of Objects from an Universe

| December 22, 2009 | 1 Comment

Visual walkthrough: How to extract list of all Objects, Conditions, Hierarchies, Tables, Joins, Contexts and Parameters from an Universe using Designer. Topics Covered: 1) Exploring the Print/PDF Options of the Designer 2) Saving universe as PDF to get the list of all desired details of that universe Steps: [1] Once you have your universe opened, go to […]

Continue Reading

How to create Custom LOVs in Business Objects Universe Dimensions

| October 8, 2009 | 1 Comment

Video walkthrough– How to Create and or Edit Custom List Of Values (LOVs) in Dimensions of Business Objects Universes. Topics Covered: 1) Creating and Editing Context based Custom LOVs 2) Sneak peak at how Business Objects actually generates all Dimensions’ List Of Values Scenario: You have 35 Customers which is tied to a “Customer” dimension. […]

Continue Reading

Migrate Universes from Development to Production

| August 16, 2009 | 0 Comments

Universe Migration steps: This is one of the ways to migrate a universe from Development to Production universe if you want to keep them consistent and identical. We’ll use a generic example: X and Y are the same universe in different environments-Development and Production respectively. It’s always best practice to archive all universes that need […]

Continue Reading

Stored Procedure in WebI Reports Part 3

| June 27, 2009 | 0 Comments

Image walkthrough: Stored Procedure with Parameters / Prompts in WebI Reports [1] We are starting with this WebI report which was created with a simple stored procedure, in Part 2: That stored procedure just returned 2 columns. Now, we are going to work with a stored procedure with 2 input parameters, aka ‘prompts’ (in WebI). […]

Continue Reading

Scope of Analysis and Custom Hierarchies

| June 25, 2009 | 1 Comment

Video: Demystifying Scope of Analysis and Custom Hierarchies on Business Objects XI Universes and WebI / DeskI reports. The terms “Scope of Analysis” and “Custom Hierarchies” sound so complex and sophisticated that one would think that wow… Business Objects got some very advanced (and awesome) features. I, of course do not deny that these are amongst […]

Continue Reading

Stored Procedure in WebI Reports Part 2

| June 25, 2009 | 0 Comments

WALKTHROUGH: Using Stored Procedure in WebI reports on Business Objects EN XI R2 (SP3) This is a follow up of Part 1 where we went through the prerequisites of enabling stored procedure queries on WebI. We have a simple Stored Procedure called “uspGetStates” – which is intuitive and does exactly what the title says – […]

Continue Reading

Stored Procedure in WebI Reports on BOE Part 1

| June 24, 2009 | 1 Comment

How to use Stored Procedure on Web Intelligence (WebI) reports on Business Objects XI R2 ? I found the following info in Bob forum and elsewhere on the net. STEPS: Applicable to universes that are built with ODBC or OLEDB connections. [1] Locate the ODBC.SBO or OLEDB.SBO files [2] Usual Location: DRIVE:\BusinessObjects Enterprise 11.5\win32_x86\dataAccess\connectionServer\ DRIVE […]

Continue Reading

On the fly Case Statements in Web Intelligence Reports

| June 16, 2009 | 1 Comment

Problem: Due to having a little flaw in the data (in database) duplicate rows are being produced in (WebI) reports. (1) Solution: Use CASE statements > 122 Unique WorkItem subtypes One of the the WorkItem SubTypes has a duplicate ‘Problematic Payment – Overage’ ‘Problematic Payment – Overage’ One with and an extra space. In the […]

Continue Reading