RSSCategory: SQL

SQL Basics in 30 Minutes – Part 3

| April 29, 2011 | 0 Comments

Topic: SQL Basics in 30 Minutes – Part 3: Views and Stored Procedures.  Views, just like the word word itself, is a part of a whole. Look at the image on the left. You can see a partial ‘view’ of the earth. You don’t see the rest of the earth, though it exists. Just like that, […]

Continue Reading

SQL Basics in 30 Minutes – Part 2

| January 24, 2011 | 0 Comments

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

Continue Reading

SQL Basics in 30 Minutes – Part 1

| January 24, 2011 | 0 Comments

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, […]

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

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

Nested SQL, Derived Table in Business Objects Universe, Multiple joins between tables

| May 8, 2009 | 0 Comments

Though most of the time we deal with simple 1 to 1 join between tables, be it, inner or outer, sometimes relationships between two tables can be based on multiple columns due to the nature of business. I’ve faced many situations like this in my work.   For example: A sales area is determined by […]

Continue Reading