Personal News

I moved on to a new project in NYC. This explains my lack of the posts. It’s an exciting new project that I’m not able to share anything about publicly. But hopefully, I’ll be able to share some more new tips and hints. There’re so many new OBIEE bloggers now. I wonder what’s the reason the OBIEE web arena is becoming so competitive :-) Also, I’ve lost interest for posting on OTN for time being. Good luck all

How to generate Line Bar Combo chart with stack in OBIEE?

Might be useful for someone who’s stuck trying to figure out how to mimic an existing report.


To generate Line Bar Combo chart with stack:

-Go to BI Answers and set the columns needed on criteria tab and go to results
-Click on Add view >chart view
-Use line bar combo chart type, select two columns for Y Axis and one metric for line. Select chart type as 2D stacked.
-To have the stack effect, on criteria tab, use the same measure columns few times separately with separate filter (Edit Formula>Insert filter >then select filter from saved filter). For example select two amount sold columns with two filters, one for country=country1, and the other country=country2 like
FILTER(“Sales Facts”.”Amount Sold” USING (Customers.Country = ‘Canada’))
FILTER(“Sales Facts”.”Amount Sold” USING (Customers.Country = ‘Brazil’))
-Select both the filtered measured amount sold columns for Y-Axis.
-Select the column for overlay column for which line graph is needed. “

ADSI Groups in OBIEE (LDAP)

This is official – you can’t get groups from ADSI! Hopefully, this can help someone who’s battling management in the beginning of the project. Sometimes Oracle salespeople are overly optimistic and provide an impression that OBIEE can do everything. But I’ll let it be a theme of another post.

Here’s the full text below:”

I am able to login to Analytics web using my Acitive Directory credentials. However, I need to be able to assign permissions to my self. How do I do that? Do I create an Analytics group named the same as an Active Directory group and assign permissions to the Analytics group?

Customer is able to login to Analytics web using my Acitive Directory credentials. However, he wants to assign permissions to my self. How do I do that? Do I create an Analytics group named the same as an Active Directory group and assign permissions to the Analytics group?

Resolution
After understanding the requirements of the customer it was determined that it is not possible to retrieve the Group name the way customer is trying.

Customer is trying to retrieve GROUP value from member of attribute.

memberOf attribute is an array which has multivalues for example

Here is an example:
CN=Siebel Administrator,OU=People,DC=d1,DC=us,DC=ts
memberOf=CN=Group Policy Creator Owners,CN=Users,DC=d1,DC=us,DC=ts
memberOf=CN=Domain Admins,CN=Users,DC=d1,DC=us,DC=ts
memberOf=CN=Enterprise Admins,CN=Users,DC=d1,DC=us,DC=ts
memberOf=CN=Schema Admins,CN=Users,DC=d1,DC=us,DC=ts
memberOf=CN=Administrators,CN=Builtin,DC=d1,DC=us,DC=ts

We do not support retrieving group dynamically for LDAP/ADSI validation.
I have logged Bug No# 5714777 as an Enhancement Request to support this feature.
Only way to retrieve the group name is to create an attribute “xyz” in ADSI and then populate with xyz:webadmin;siebeladmin then you can map it to Group variable. “