Saturday, August 30, 2008

Noetix Generator for Oracle Business Intelligence

Oracle Apps is not known to for providing a good feasible solution for great demand for operational and transactional reports though OBIEE is the solution targetted for providing both detail level reports and analytical reports. Few people may debate but detail level reports are not something that OOB Applications spent time on and customers have been looking to build a custom solution but building a custom BI solution with Oracle Apps source isn't as easy because of the complexity of the data model, which a BI architect cannot easily design. Noetix Corporation has been operating successfully in this space providing their solutions catering to customers on OBIEE, Discoverer and Business Objects.

I just want to highlight what Noetix offers for OBIEE and also highlight little success that we had with this solution in our user community. Noetix with great understanding of the data model of Oracle Apps generates database views in Oracle Apps database. It generates same database views for all operating units with slightly different names. "Noetix Generator for OBI" software generates UDML script and generates all 3 layers of RPD with Noetix specific security groups for different roles selected. RPD does not have any dimensions or facts as such but users will have to generate reports from one view at a time, which means users will not be able to build reports coming from different views.

As OBIEE Supply Chain Analytics OOB Solution does not have anything at this point to cover the analytics related to manufacturing process, Noetix solution has been looked at and our business users have responded positively so far. I posted this just to let my fellow OBIEE devloper community to know that there is a solution out there in the market. Noetix solutions may not help all the customers but it is definitely worth looking at if the size of Oracle Apps implementation is moderate or large implementation. Also, Noetix has EUL Generator for catering to Discoverer customers.

5 comments:

Anonymous said...

Hi Changa, we are looking into a scenario where we are required to migrate large number of Discoverer 4i reports to OBIEE. We have some custom reports and views too that are to be migrated.

I am aware that Noetix Generator for OBIEE can handle it to some extent, but at the repository level, how seamless is the integration and how much customization/ETL would be required for the custom reports to be built on custom views (say 50 reports from 60 custom views.

Appreciate your valuable inputs based on your experience.

~Sparju

Changa Reddy said...

Sparju,

I am hearing that there is an utility to upgrade 10g Discoverer EUL to OBIEE 10.1.3.4 RPD. Reports will have to be built from scratch. But, you guys are on 4i, which cannot be migrated with click of a button.

Coming to Noetix, RPD generation is very seamless and you probably have to manage security alone. Custom views if you have need to be imported in Physical, model in BMM and present them presentation layer. I do not see any ETL customizations if you are only talking about the views. Custom reports will have to be built from scratch in OBIEE. Effort cannot be estimated with not much information in hand. You will have to look at Noetix and see what would be possible to build out of Noetix subject areas and estimate effort based on complexity and data availability for each report. There may be cases where you will have to create new physical table(s), ETLs and report(s). So, you will have to analyze report by report for estimation. Hope, this helps.

Good Luck!

The Advocate said...

Just bumping this blog... considering this was 5 years ago, what did you end up with? I too am considering Noetix or just sticking with OBIA modules instead. I am curious as to the rest of your experience and where you landed as in the final solution.

The Advocate said...

Just bumping this blog... considering this was 5 years ago, what did you end up with? I too am considering Noetix or just sticking with OBIA modules instead. I am curious as to the rest of your experience and where you landed as in the final solution.

The Advocate said...

Just bumping this blog... considering this was 5 years ago, what did you end up with? I too am considering Noetix or just sticking with OBIA modules instead. I am curious as to the rest of your experience and where you landed as in the final solution.