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 ‘BI Server’ 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 »
OBIEE 11G error: No more than 1 hierarchy from the same dimension…
Posted in BI Server on July 15, 2011 | Leave a Comment »
Thought some developers may find this useful and save time trying to work around, fix or look for answers. Users of the latest OBIEE 11g release 11.1.1.5 may get this error going against OLAP source systems. State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from [...]
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 [...]
ORA-32036, WITH clause and STAR_TRANSFORMATION_ENABLED
Posted in BI Server, Oracle BI Apps on April 21, 2011 | Leave a Comment »
Its been a very, long time since I posted. And for just cause, as I have been very busy working OBIEE and OBIA projects. I have noted down along the past year interesting finds which I will post in the coming months. Of which, I will begin with an issue I came across using Oracle [...]
