Tweet |
Monday, 31 August 2015
Toggling the database in OBIEE 11g at runtime
Monday, 8 June 2015
Using Internet Explorer to customize OBIEE 11g UI
Tweet |
This blog talks about a shortcut to achieve the objective.
Sunday, 7 June 2015
OBIEE Hack: Putting prompts in file names
Tweet |
This blog talks about a hack to achieve this in OBIEE.
Sunday, 24 May 2015
Understanding OBIEE RPD - Chapter 1
Tweet |
This is the first article in this series and we will be talking about the scenario where we pull columns from 2 different physical sources and 1 common dimension in the same analysis.
Sunday, 3 May 2015
Making OBIEE 11g Evaluate function dynamic
Tweet |
This article talks about a method to handle this requirement.
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 database resources.
It is possible that some user might be selecting a huge date range resulting in the problem at the database. So the trouble in this case might be the filters put by the user and not the Analysis itself.
Saturday, 28 March 2015
Installing OBIEE 11g Client tool on Windows 8
Tweet |
The certification matrix for OBIEE version 11.1.1.7.0+ is in the following location and it does not include Windows 8.
http://www.oracle.com/technetwork/middleware/bi/bi-11gr1certmatrix-ps6-1928219.xls
It means that installing OBIEE 11g client on Windows 8 is not supported by Oracle. I got a mail from Oracle to explicitly call it out.
This blog talks about a way to to install admin tool on Windows 8 machine.
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 dashboard to see the pages in it.
Since the requirement is strange so will be the solution.
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 hide a report using these conditions, this blog talks about a process to use conditions on sections to implement a 3 way decision rather than just a boolean (true/false) decision.
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 display 'Y' in a column if the value was a number and display 'N' if it was a character string.
Labels:
ASCII,
numbers and character seperation,
OBIEE 11G
Subscribe to:
Posts (Atom)