I just stumbled into a new OBIEE blog by Jeff McQuigg – it’s not really new, i think he’s in the process of moving it from IT Tool Box. Jeff is one of the top experts in OBIEE / Siebel Analytics world. I suggest you take a look – http://greatobi.wordpress.com
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
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. “
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. “
If you want to see correct calculations – then a BI Server Restart might be required after you change Aggregation Rule for a column from SUM to AVG (or in any way).
I noticed that problem on Grand-Total calculations – it just wouldn’t perform correct aggregation for the column after RPD change in online mode (with Aggregation Rule – Default).
After services restart, OBIEE would perform correct grand-total aggregation.