Problem and challenge came up recently to pull and set a multiple value parameter from OVD (or LDAP source) and set session variable (row-wise session variable to be specific) to be used by report writing. Well in OBI 10g, I usually have done that by using my custom LDAP table function to use along with [...]
Archive for the ‘Administration Tool’ Category
Alternative way to set multi-value LDAP parameters as row-wise session variables
Posted in Administration Tool, BI Server on January 6, 2012 | Leave a Comment »
Data level security on Logical Tables
Posted in Administration Tool, BI Server, Oracle BI Apps on April 22, 2011 | Leave a Comment »
The other day while working on data level security within OBIEE (BI Server), I found something very interesting I would like to share. While testing my data level security for various combinations of groups, I noticed that for one subject area I was not having my security filters applied. That should not and can not [...]
Use of Evaluate function for Analytics Function (Oracle)
Posted in Administration Tool on April 27, 2010 | 1 Comment »
In those rare instances, there is a necessity to utilize the EVALUATE function within OBIEE. Most cases the use is to utilize a database function that is not available, yet, by OBIEE; but, is available within the database reporting from. For example, an analytic function within Oracle. Use of the EVALUATE function will allow to [...]
Drillable logical columns
Posted in Administration Tool, Presentation Services on August 24, 2009 | Leave a Comment »
On a project recently, there arose an issue where logical columns that were not explicitly added to a hierarchy where suddenly drillable! What would cause that? Did someone change a property? After careful analysis, I found out that there are 2 things that will make logical columns (not explicitly set in a hierarchy level) become [...]
Migration Design of RPD From One Environment to the Next
Posted in Administration Tool on August 12, 2009 | 1 Comment »
Migration of OBIEE RPD from one environment to the next can be simple, just copy the RPD. But then one would have to manually open up the RPD afterwards in the target environment to change connection pool information, maybe AD server configuration and the list can go on. Pretty much each environment may necessitate changes [...]
OBIEE Config Parameters
Posted in Administration Tool, Presentation Services on June 16, 2009 | Leave a Comment »
Most of the configuration parameters that are available are not easy to find in Oracles documentation for either NQSConfig.INI and/or instanceconfig.xml (along with other config files for OBIEE). The params that do not show, that most developers I ran across do not know about, are defaulted to some value. I happen to have a document which [...]
