Wordpress - oasisbiee.wordpress.com - oasisbiee
General Information:
Latest News:
The Hierarchical Data model implementation in the SQL Server Applications 4 Nov 2012 | 04:16 pm
The following article will describe the step-by- step approach on implementing the Seibel data modelling in the SQL Server database through the means of SQL Server Integration Services (ETL Tool) and ...
Report stitching in OBIEE Answers 11 Apr 2011 | 04:00 pm
Hi, In this topic, I would like to discuss on ‘how to perform report stitching in OBIEE Answers’. While I was working with a client, I got a pivot table report requirement. The actual report templat...
Solution for OBIEE Shared IBOT not modifiable Issue 1 Apr 2011 | 07:50 pm
A few weeks ago, I came across an issue in the IBOT. The issue is IBOT kept under the shared folder is not modifiable by the user; one of my end user from advanced user group created the IBOT and kept...
OBIEE Report Navigation Caption 18 Mar 2011 | 07:42 pm
Hi, In this topic, I would like to discuss on “how to include a navigation caption for a single report”. Benefits of Caption: Caption helps the user while they are navigating from one report to the...
Steps to handle Leap Year in OBIEE 16 Mar 2011 | 08:58 pm
Hi, Here I would like to share logic to get the total number of days for all the month in a year. In my previous project I got a requirement. For one of a column I need to get the total number of da...
OBIEE Pattern Matching 14 Mar 2011 | 09:38 pm
Hi, In this post I would like to share “how to perform pattern matching” in OBIEE. One of my clients wants to perform an aggregation on a dimension field and the source is fact table. This dimension...
OBIEE Date Features 10 Mar 2011 | 06:11 pm
Hi all, One of my clients wants to build OBIEE reports using the SQL Server data source. We created the data model, reports and started doing the testing. During our testing the OBIEE reports are ru...
Steps to avoid write back in OBIEE 9 Mar 2011 | 08:12 pm
Hi All, I would like to share my OBIEE knowledge to you all using this blog. I believe most of us have used filter based on results of another request in BI Answers. When filter based on results of a...