Understanding the implementation of value based hierarchy (parent-child) in OBIEE 11G

Hello As we all know, from 11g onwards, the feature of implementing value based hierarchy is available. There are several great articles out there that explains the steps of such implementation in 11G, therefore I am not going to repeat these things. What I want to talk about is more of a concept of value based hierarchy implementation, which will hopefully answer the questions that a lot of beginners reading about this topic may have as such "How do I know the right table structures for this type of hierarchy?" As we know, employee dimension...

Read More

Navigating between reports and dashboards when there is no common fields to pass parameters

Hello All Today I want to talk about navigating between reports and dashboards. As we all know, this feature can be done in 11G through action frameworks, this allows us to click on any particular value of the actionlink defined column and navigate us to another dashboard page (BI Content if we choose it in the actionlink) and the value we clicked previously will be filtered. This is a pretty standard feature that has been part of OBIEE product...

Read More

Calling Javascript function from OBIEE dashboard

Hello again This time I am going to show how to call javascript function from OBIEE dashboard. The script can be written and saved in the common.js file located in: OBIEE_Folder/user_projects/domains/bifoundation_domain/servers/bi_server1/tmp/_WL_user/analytics_11.1.1/7dezjl/war/res/b_mozilla/common.js I have written a simple script as the follow and I saved it in the bottom of the common.js file: // MY Stuff function obi_popup() { alert("Hello...

Read More