Venkatakrishnan J

One of the few things that we have been working on recently is in creating some BI EE accelerators/utilities that Oracle BI customers/partners can use alike for facilitating faster & smoother BI EE implementations. We as a company have been implementing BI EE for a while now at

In this blog post, we shall see how to overcome two common issues that we would typically face after upgrading to 11g. The solutions for both the issues are straight-forward but i thought it made sense to have a separate posting for this due to the common nature of both

BI EE 11g, like 10g provides ability to customize the End-User Interface through 3 methods. They are 1. Styles 2. Skins 3. XML Messages Like 10g, the procedure described in the 11g documentation to customize the UI using the above 3 methods is not correct. Fortunately, Oracle has come out

One common requirement when it comes to any software is in properly handling the network, ip and host name related changes. For example, moving servers from one domain to another, or cloning instances can all trigger these network related changes. BI EE 10g can quite easily handle the host-name related

BI EE 11g introduces a new API for Systems Management called BI Systems Management API. This API has multitude of uses especially at places where complete automation/control of resources/system deployment is required. This API uses the Java JMX MBeans to expose the functionality externally. BI EE 11g Enterprise

As i had explained in my previous post here [https://www.rittmanmead.com/blog/2010/08/24/oracle-bi-ee-11g-parent-child-hierarchies-differing-aggregations/] , Parent Child Hierarchies introduced in BI EE 11g are much more flexible in terms of handling aggregation of measures when compared with a Level Based Hierarchy. In this blog post, we shall

In the last 2 training days event that we ran in Atlanta and Bangalore, we showed a demo of how the BI EE 11g security works. One common question that we got out of both the events was how do we use 10g model security in 11g. Though the BI

As i had mentioned here [https://www.rittmanmead.com/blog/2010/08/17/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/] , one of the most important features of BI EE 11g is the ability to do ETL kind of Lookup functions directly from Repository. In the Training Days event that we ran in London & Atlanta recently,

As Mark had mentioned here [https://www.rittmanmead.com/blog/2010/10/24/obiee-11gr1-security-explained-working-with-the-default-security-configuration/] , one big change in BI EE 11g is the adoption of OPSS or Oracle Platform Services Security Model as a framework for security in BI EE. In BI EE 10g, integration with external LDAP security had

BI EE 11g now provides true multi-dimensional navigation/analysis support. This multi-dimensional analysis is supported for almost all the data sources that are supported by BI Server for reporting. Today we shall how BI EE 11g works on Microsoft SQL Server Analysis Services 2008. There is no explicit MSAS 2008

BI EE 11g like 10g supports report to report navigation. BI EE 11g also passes down the parameters from one report to the other provided the column & presentation table names match (same as 10g). But in 11g now, we have the ability to use Hierarchical Columns. Lets see how

If you had looked at our presentation last year in Open World [http://www.rittmanmead.com/files/OOW2009_Essbase_and_OBIEE_Integration_Deep_Dive.pdf] (and also a couple of blog posts prior to that), we had shown how to go about implementing Vertical Fragmentation in BI EE 10g. There

As Mark had blogged about here [https://www.rittmanmead.com/blog/2010/07/12/obiee-11gr1-support-for-ragged-skip-level-value-based-hierarchies/] , a very important new feature of the BI EE 11g is the ability to support ragged & skipped hierarchies in a normal level based hierarchy. Though it does look straight-forward in terms of functionality and

BI EE 11g introduces a new function called EVALUATE_ANALYTIC that can function ship analytic functions from Answers back to the database. In 10g we had EVALUATE which could function ship only normal functions. Analytic functions were not supported. But with 11g, Analytic Functions are supported as well. Though the

As mentioned in my blog posts here [https://www.rittmanmead.com/blog/2010/08/17/oracle-bi-ee-11g-lookup-tables-sparse-and-dense-lookups/] and here [https://www.rittmanmead.com/blog/2010/08/20/oracle-bi-ee-11g-reporting-on-clobs-lookups/] , ability to do lookups in the repository opens up a lot of possibilities to solve different reporting use cases that were otherwise not

One significant feature as mentioned here [https://www.rittmanmead.com/blog/2010/09/13/oracle-bi-ee-11g-action-framework-integration-with-external-applications/] in BI EE 11g, from the perspective of Action Framework, is the introduction of the BI Web Services for SOA. Till 10g, BI EE had good support for web services but the nature of the

As mentioned in the blog entry yesterday, Action Framework of BI EE 11g opens up direct integration with Java. So, any process that can be called via Java can be directly called from BI EE as well. In 10g, the only way for calling Java Processes was by using Delivers.

Action Framework in BI EE 11g opens up BI EE to external applications for extensive integration. Mark has covered this as part of his posting here [https://www.rittmanmead.com/blog/2010/07/19/obiee-11gr1-action-framework-and-conditions/]. BI EE, even in 10g had a lot of integration options. But one biggest drawback

Yesterday, we saw how to go about patching repositories so that the entire process of migration from development to production can be automated. That patching process was basically an extension of the 3 way merge process. In 10g, 3 way merging was supported in Web Catalogs as well. I had

One of the biggest problems that we have had with BI EE 10g was there was no automated way of making repository deployments in Linux environments. Some of us internally in Rittman Mead have adopted UDML to script the migration from development to production. But the problem with UDML is

One of the OLAP-Aware features of BI EE 11g in Answers is the introduction of Selection Steps for additional analysis. At a high level, Selection Steps provide additional analysis capabilities that are not available directly from the Criteria tab. This provides us with more control on the SQL generated. Till

As mentioned in the blog entry here [https://www.rittmanmead.com/blog/2010/08/14/oracle-bi-ee-11g-%e2%80%93-bi-server-new-features/], BI Server 11g now supports more functions which were added to support the new UI features. Each of these functions can be used as part of the Logical SQL or can

As Mark had pointed out earlier here [https://www.rittmanmead.com/blog/2010/07/09/obiee-11gr1-architecture-and-use-of-weblogic-server/], one of the significant changes in the BI EE 11g release is the migration of security from the BI EE repository to Weblogic. Users and Groups will no more be maintained within the rpd.