Wordpress - oraclebizint.wordpress.com - Business Intelligence - Oracle
General Information:
Latest News:
Time for a Change – Upcoming Announcements – Millionth Hit 16 Jun 2009 | 05:35 am
Well, as the saying goes “Change is the only Constant”, there are quite a few changes that are coming up on this blog(well not blog alone!!!) in the near future. I would be in a position to make an an...
Oracle Data Integrator 10.1.3.5 – Connectivity to Open LDAP of Shared Services 10 Jun 2009 | 08:32 am
One of the features of Oracle Data Integrator is its ability to connect to a lot of disparate data sources using JDBC. One such feature is its ability to expose any LDAP directory as a relational sour...
Oracle Data Integrator 10.1.3.5 – Using OBI EE as a Data Source – Using BI EE JDBC Driver 7 Jun 2009 | 11:33 pm
In a prior blog entry here, i had shown how to use BI Server as a data source for loading data from Essbase into custom tables. That approach basically used the Sun ODBC-JDBC bridge which in most case...
Oracle BI EE 10.1.3.4.1 – Handling Complex String Manipulations – Using Regular Expressions (RegEx) and Evaluate 4 Jun 2009 | 10:05 pm
One of the requirements that i recently came across involved some complex string manipulations that cannot be solved easily by using BI EE specific functions. Just to illustrate the requirement, take ...
Oracle Data Integrator 10.1.3.5 – Using Oracle BI EE as a Data Source – Loading Essbase data into custom tables – Using JDBC-ODBC Bridge 2 Jun 2009 | 08:23 pm
In the blog entry here, i had basically shown multiple ways of loading data into Essbase. Today we shall see an approach wherein one can extract data from Oracle BI Server using the JDBC-ODBC bridge. ...
Oracle BI EE 10.1.3.4.1 & Essbase Connectivity – Displaying Member Intrinsic & Custom Properties – Aliases and UDAs 1 Jun 2009 | 09:10 am
One of the common questions asked in the existing BI EE to Essbase connectivity is the ability to display member names in a report instead of the alias names. Currently BI EE does not support displayi...
Oracle Enterprise Performance Management Architect (EPMA) – Administering Essbase, Planning and HFM – Setup 28 May 2009 | 05:37 am
One of the major advantages of Oracle acquiring so many companies is the fact that it integrates all the products in some fashion or the other, that too quickly. For example, if you look at the differ...
Oracle BI EE 10.1.3.4.1 – Writebacks to Essbase – Using JAPI and Custom HTML – Part 1 26 May 2009 | 07:10 am
Considering the amount of expectations surrounding the BI EE and Essbase connectivity, i thought it would make a lot of sense to blog about another interesting piece of the Essbase and BI EE integrati...
Oracle BI EE 10.1.3.4.1 – Scheduling Essbase/Planning Calculation Scripts – Action Framework & Custom Java Remote Procedure calls 22 May 2009 | 04:48 am
In the blog entry here, i had shown you how to run an essbase calculation script from the BI EE dashboards. To make it even more complete, lets look at a means of calling a calculation script through ...
Oracle BI EE 10.1.3.4.1 and Essbase Connectivity – Report Based and Essbase based Grand Totals – Answers Based Aggregation 20 May 2009 | 10:13 pm
This post here by Christian prodded me to write about another interesting feature in the BI EE and Essbase Connectivity. As you would probably know BI EE supports report based grand totals/sub-totals ...
