Vishal's blog
Monday, 28 May 2018

Variable names starting with numbers

›
Tweet The long weekend gave me the chance to finally write a blog post. I will try my best to be more frequent with posting new content...
17 comments:
Friday, 14 April 2017

OBIEE 11G RPD bypass using Private Variable Columns

›
Tweet We had a requirement where the user wanted to be able to get into the tool and change his formula and also wanted the change to b...
3 comments:
Sunday, 19 March 2017

OBIEE 11G: Setting multiple values to Presentation Variables through goURL and conditional filtering

›
Tweet I am writing this blog after a loooooong gap and I can tell you that it is worth the wait. In this blog, we discuss about the pro...
11 comments:
Saturday, 31 December 2016

The neo-MUD tunnel for OBIEE 11g automated RPD deployment

›
Tweet Ok call me a geek for writing this blog on new year's eve, I dont care :-P. I can tell you that this blog is totally worth it...
2 comments:
Sunday, 7 August 2016

OBIEE 11g: Outer join in the Physical Layer now possible

›
Tweet We know that we can perform outer joins in OBIEE in the Logical Layer. The problem with this mechanism is that it is not possible...
4 comments:
Saturday, 12 March 2016

Issue in using EJB Actions in OBIEE 11.1.1.9

›
Tweet This blog is less about a solution and more about an information. If you have written an EJB that uses a obiee report saved in ...
4 comments:
Monday, 7 March 2016

Migrating application roles in OBIEE 11g

›
Tweet My last article talked about a maintenance and hassle free mechanism to implement security. The article moved the security archi...
3 comments:
Sunday, 14 February 2016

Maintenance free security implementation in OBIEE 11g

›
Tweet This blog talks about a hassle free mechanism of OBIEE security implementation with almost zero overhead. We will first look at ...
2 comments:
Monday, 31 August 2015

Toggling the database in OBIEE 11g at runtime

›
Tweet We have a replication and the primary database server. Replicating the data takes some time so the replication server is usually ...
2 comments:

Oracle VM file sharing with Windows host

›
Tweet This article talks about the process to share files between Oracle VM and windows host.
Monday, 8 June 2015

Using Internet Explorer to customize OBIEE 11g UI

›
Tweet We recently had a requirement that the button sizes in OBIEE had to be increased. The reasoning was that the users of some of the...
2 comments:
Sunday, 7 June 2015

OBIEE Hack: Putting prompts in file names

›
Tweet Users often have the requirement to have the selected prompt values suffixed to the name of the exported file. This blog talks a...
12 comments:
Sunday, 24 May 2015

Understanding OBIEE RPD - Chapter 1

›
Tweet The most skilled task in the world of Oracle Business Intelligence is to design and code the RPD. While we are all aware of the g...
3 comments:
Sunday, 3 May 2015

Making OBIEE 11g Evaluate function dynamic

›
Tweet We know that we can use the evaluate function to call any function stored on the database and pass arguments to it. What if we ha...
6 comments:
Sunday, 29 March 2015

OBIEE 11g query tracking mechanism

›
Tweet We had a requirement of tracking a query fired from OBIEE. This was to help us find out the Analysis that consume the most databa...
4 comments:
Saturday, 28 March 2015

Installing OBIEE 11g Client tool on Windows 8

›
Tweet OBIEE 11g client tool is not certified with Windows 8.  The certification matrix for OBIEE version 11.1.1.7.0+ is in the followi...
7 comments:
Sunday, 22 March 2015

OBIEE 11g dashboard pages outside of a dashboard

›
Tweet We had a strange requirement. The user did not want the dashboard to be published and he hated the fact that he had to expand the ...
1 comment:
Sunday, 15 March 2015

3 way switch in OBIEE 11g

›
Tweet While we all know about using conditions on sections in a dashboard, and while we all have used presentation variables to show or ...
3 comments:
Sunday, 22 February 2015

Seperating numbers from characters in OBIEE 11g

›
We had a requirement in which the a column had either pure numbers such as 123 or pure alphabets such as QWED. The requirement was to displa...
Friday, 12 December 2014

Easy method to create BIP 11g reports on top of OBIEE dashboards

›
This blog talks about a quick way to create BIP reports on top of OBIEE dashboards.
3 comments:
Wednesday, 26 November 2014

Active directory configuration in OBIEE 11.1.1.7

›
We will learn about configuring Active Directory (AD) for OBIEE 11.1.1.7 today.
1 comment:
Sunday, 31 August 2014

Non Standard SQL in BIP 11g - Dynamic query implementation

›
SQL query is often used as a data source in BIP and often we have a requirement in which we have to use one table when the user selects a ce...
2 comments:
Friday, 29 August 2014

Increasing width of Multiselect in OBIEE 10g

›
I was recently involved in a project implementation on OBIEE 10g. The dashboard had a multiselect and the values in the prompt were huge. T...
2 comments:
Saturday, 9 August 2014

Privilege to see hidden objects in OBIEE 11g

›
My client wanted to hide some of the reports from the users and release them at a later date. The however wanted a set of users to have the...

Smart Tables in OBIEE 11g

›
This article introduces the concept of Smart Tables in OBIEE. I call them 'Smart' because these tables have the ability to produce...
Friday, 8 August 2014

Skipping schedule in BI Publisher 11g

›
This is an awesome feature in BI Publisher 11g but I do not hear a lot of noise about it so let me create some. I'm talking about Even...
2 comments:
Tuesday, 5 August 2014

Drill-able hierarchical charts in OBIEE 11g

›
This is a discovery more than a solution. OBIEE 11g lets us use Hierarchical column as dimensional attributes for charts.
3 comments:

Formatting levels of a hierarchical column in OBIEE 11g

›
I had a requirement to indent the levels in a hierarchical column. The solution isn't really innovative but I thought of sharing this b...
2 comments:
Saturday, 26 July 2014

Capturing Environment Variables in Oracle APEX

›
 This post focuses on the E nvironment variables as they are vital in coding conditional statements .
1 comment:
Wednesday, 23 July 2014

String aggregation in OBIEE

›
In the BI world, we talk about measures and aggregation but we don't talk a lot about string aggregation. String aggregation is about c...
1 comment:
Sunday, 20 July 2014

Using DB Link in OBIEE

›
This blog talks about the process to use DB Links on OBIEE.
Saturday, 19 July 2014

Using BIP parameters in OBIEE dashboards without creating prompts

›
This is a simple trick that presents the process to have a parametrized BIP report in OBIEE without the need to create new prompts in OBIEE...
Monday, 3 February 2014

Ways to create Matrix report in Oracle APEX

›
This is another one of those articles where I pick a topic from the sample chapter of my book and share with you. Some of the other discus...
11 comments:
Friday, 31 January 2014

Consuming OBIEE 11g Web Services using Java

›
We will talk about consuming OBIEE 11g webservices using Java in this article. My previous articles have been about consuming webservices u...
7 comments:
Monday, 23 December 2013

Creating ReForms in Oracle APEX

›
Let me begin by defining a ReForm . A ReForm is an amalgum of Reports and Forms and has the DNA of both. This discussion not only presents ...
2 comments:
Monday, 16 December 2013

Data Densification in Oracle APEX

›
Data is often stored in sparse form and business often wants to see data in a more organized and explicit fashion. Report developers workin...
Thursday, 12 December 2013

Creating dynamic breadcrumb chains in Oracle APEX

›
This article is borrowed from one of the topics of my book ( http://www.packtpub.com/oracle-apex-4-2-reporting/book ) on Oracle APEX 4.2 r...
2 comments:
Wednesday, 13 November 2013

Tracking the running reports in OBIEE 11g

›
  I faced a rather strange but relatively simple requirement a few days back. The client had employed a resource to refresh the sessions p...
2 comments:
Thursday, 3 October 2013

Sangam 2013

›
Just read about  http://www.sangam13.info/ .The event has been cohosted by AIOUG and India OAUG Such events are indeed rare and fe...
Wednesday, 25 September 2013

ESRI map with Google map and map viewer in APEX

›
This article is in continuation of my previous work on Oracle Map Viewer/Map Builder and Oracle 12c database. This article demonstr...
2 comments:
Saturday, 14 September 2013

My take on using Mapviewer with Oracle 12c and Google maps API

›
Map viewer is a kool technology and I wanted to write about it for a long time.  Let me first chalk the steps that we will follow. ...
16 comments:
Friday, 30 August 2013

Description of my book on Oracle APEX 4.2 reporting

›
Oracle APEX 4.2 reporting is designed to bring the best of the reporting world for intermediate –advanced readers. The book is available ...
1 comment:
Thursday, 11 July 2013

My upcoming book - Oracle APEX 4.2 reporting

›
I have finally finished writing my book on Oracle APEX reporting. The book will be  is now available at  www.packtpub.com/oracle-apex-4-2-r...
9 comments:
Sunday, 23 September 2012

Creating Download Utility using PLSQL

›
Let me start this article with an apology for not posting an article in such a long time. I have been involved in writing a book and it is...
Friday, 8 June 2012

Coding different page layouts in a single rtf template and the importance of Contexts in BI Publisher

›
The requirement was to generate an output in statement page size or in legal page size, depending on a parameter value. Since the paramete...
2 comments:
Saturday, 2 June 2012

Sorting outer group based on inner group in BI Publisher

›
I spent almost a day to implement a grouping and sorting requirement and after all that brain storming I found that the requirement can ...
Wednesday, 23 May 2012

Formatting time in BI Publisher

›
This article describes a mechanism to format time in BI Publisher. Let me explain with an example I have a XML file with the followi...
3 comments:
Tuesday, 1 May 2012

OBIEE performance improvement tips

›
My 1st article in this blog was about OBIEE repository tuning and this article is an extension to it. This article is inten...
6 comments:
Friday, 27 April 2012

Using custom transformations in BI Publisher 10G

›
Out of all my posts on BI publisher, this one is my personal favorite. The article describes a mechanism to use any custom function in B...
21 comments:
Friday, 9 March 2012

Creating reports in Excel using OBI server

›
This article describes a mechanism to create reports in excel using the relations established in Oracle BI Server. We can leverage BI ser...
5 comments:
Thursday, 8 March 2012

SQL developer data modeler for OBIEE developers

›
I haven’t extensively worked on data modeling but I saw this kool feature of sql developer data modeler. It gives you a relational pictu...
3 comments:
Wednesday, 29 February 2012

Creating Applications in OBIEE using DAD

›
OBIEE is a great business intelligence tool but it is a one way highway. Users can use OBIEE to see the intelligence in the data but what i...
Thursday, 23 February 2012

Folding table in Oracle using unpivot function

›
In this post, I am unsing unpivot function to change the arity and cardinality in the result. mXn table is used to get pXq result such t...
Saturday, 18 February 2012

Installing SSL enabled APEX 4.1 with development environment and APEX Listener on Weblogic and standalone

›
This article presents a way to set SSL enabled APEX 4.1 on weblogic using APEX listener. The final part shows the process to configure st...
2 comments:
Tuesday, 14 February 2012

Silenced writeback using webservices - part 2

›
Happy Valentine's day to all :) This is the 2 nd part of the series in which I am using webservies to writeback. In my previous arti...
5 comments:
Saturday, 11 February 2012

Silenced writeback using webservices - part 1

›
This article presents an alternate way to do write back in OBIEE. I call it silenced because this doecs not involve the creation of text bo...
4 comments:
Saturday, 14 January 2012

Pivotal performance improvement in OBIEE

›
<p><br><br>&am...
2 comments:
Friday, 6 January 2012

Freedom to format in OBIEE

›
I’m finally back to my blogging business J. This article deals with the usual OBIEE business of formatting. OBIEE gives a lot of formatting...
5 comments:
Friday, 9 December 2011

Book review - Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting

›
Below is a review of Oracle BI Publisher 11g-A Practical Guide to Enterprise Reporting, written by Daniela Bozdoc and ...
Friday, 21 October 2011

Making OBIEE web service friendly

›
I know that I am obsessed with web services, but this is my final article in the series dealing with web services.
2 comments:
›
Home
View web version

About Me

My photo
Vishal Pathak
Kentucky, United States
I am an Oracle BI developer and like blogging about the things that I have learned in my career. My expertise is in Oracle APEX, Oracle BI Publisher, OBIEE, PL SQL and BPEL
View my complete profile
Powered by Blogger.