Analytics Resources: Insights, Best Practices,

Case Studies and More

close
20 Apr 2017

Dimension Specific Aggregation in Power BI

When dealing with facts and measures in any BI tool, you can set the a...

31 Aug 2014

eBusiness Suite and Oracle BI Applications Security

By default, an Oracle Business Intelligence installation is configured...

13 Feb 2014

Standard Date Dimension Build

The SQL Below generates a date dimension table where the DATE_WID is a...

10 Dec 2013

Scheduling OBIEE Reports with CRON

I recently got a request from a colleague to help them with scheduling...

27 Nov 2013
Data Modeling OBIEE 12c | 1 min read

Hide refresh button in No Results View

One of my colleague was designing the dashboard which has multiple rep...

07 Nov 2013
Data Modeling OBIEE 12c | 1 min read

OBIEE PDF Download Display having HTML tags

Problem: Answers to queries, when HTML tags are used while calculating...

30 Oct 2013
Data Modeling OBIEE 12c | 1 min read

Tooltip On Column Headers : OBIEE 11g

In one of our projects we had a requirement of putting tooltip on colu...

07 Sep 2013

Finding specific data in Oracle Database (GREP)

Imagine, there are a few tables in your schema and you want to find a ...

07 Sep 2013
Data Modeling OBIEE 12c | 1 min read

OBIEE 11g - Conditionally Formatting Different Number Columns

OBIEE 11g now allows you to set the data format of a column conditiona...

09 Feb 2011

Drill down in XCelsius/Dashboard Design

One of the most frequent questions asked, is about configuring drill d...

30 Jan 2011

Creating Maps with Oracle BI 11g - Initial Setup & Pre-Requisites

This week I'd like to highlight and address one of the major feature o...

16 Nov 2010
Data Modeling OBIEE 12c | 2 min read

OBIEE 11g : Master Detail Linking

With the release of OBIEE 11g, a number of new features and functional...

16 Nov 2010

Outer Joins in Universe (BusinessObjects)

Lets take a simple scenario. I want to generate a report that shows th...

11 Nov 2010

Is it my time yet ?

Over the last couple of weeks I came across several posts in the BOB B...

05 Nov 2010

How to perform YTD (or any Period to date) design in the Universe

Yet another post inspired by the BOBJ board. The idea is how to design...

03 Nov 2010

How to do Year Ago or Prior period type comparison in WEBI

Again a post inspired by the BOBJ board which talks about a generic re...

29 Oct 2010

How to setup report scheduling and report distribution for BusinessObjects

I came across this posting on the BOBJ board asking how to setup repor...

21 Oct 2010

How to deploy BusinessObjects in a distributed environment (BOE Federation)

Yesterday while talking to one of my shipping customers I realized tha...

16 Jul 2010
Data Modeling OBIEE 12c | 1 min read

OBIEE: The outer join challenge solved

The case: a. I am looking at spend by supplier, and as a user, I would...

23 Mar 2010

Building a static dashboard using XCelsius

BusinessObjects Xcelsius Enterprise 2008 enables you to transform Exce...