How to avoid “Distinct” in OBI analysis

As you know, by default, OBI reports doesn’t display duplicated records in the analysis. The reason for such behavior it’s that OBI it’s the analytical tool, not a query tool. The main “Use Case” scenario for OBI, as well as any other Business Intelligence tools, it’s when a business user starts their data analysis from higher levels of data and drill down to the details. If for one fact, several fact values are related to the same dimension values (i.e. several amounts for one client), it will aggregate the values and show only one row.

Continue reading “How to avoid “Distinct” in OBI analysis”


How to prevent browser caching on OBIEE client side

It’s a short story why I always use HTTP Server in my OBIEE installations.

I spent some time last week looking into a bug in the browser cache. The symptoms of this bug are as follows: users can see irrelevant data on dashboards, and F5 isn’t working to refresh data on the dashboard.

Continue reading “How to prevent browser caching on OBIEE client side”