IT Central Station is now PeerSpot: Here's why

Oracle OBIEE Room for Improvement

ZA
Senior Consultant at a tech services company with 51-200 employees

Thanks, Ms. Julia Frohwein for the review. I would like to explain the points which I had written in the first post.

The solution is too expensive for small firms. 

The solution is too expensive for small firms due to their licensing cost. Not every company has the budget to purchase the solution.

 I believe that the solution is beginning to integrate more security measures, however, more must be done.

The on-premises version does not have any AI or machine learning capabilities. They're saving those for cloud versions.

View full review »
Satish Kopalle - PeerSpot reviewer
BI Analytics-Tech Lead at StratApps

If I want to develop a new repository, any new table, any new schema that I want to incorporate into the RPD, then in my local schema, can't directly connect to the cloud. I do not have complete end-to-end access to it. In such cases, I need to install some local DV. I don't know if that is the right path or not, however, as far as I'm concerned, I'm just creating some tables, some sample space in my local DB and from the DB I just try to import into my local RPD in order to publish to the cloud. It is double work. If I'm in a non-cloud environment and I need not connect to the local DB, I need not re-import everything into my local space. I can connect to the available on-premise DB and connecting to that on-premise DB I can create the RPD.

In terms of linking to the cloud, there are many restrictions. From a business standpoint, it is a great way to approach things. That said, from a developer's standpoint, it's a bit tough to develop the code and progress the code to the next environment like that. 

There's a lot of redundancy, especially in relation to creating the code. Developers, in fact, have to deal with many hurdles, including security restrictions and vendor communications.

View full review »
SW
Finance Systems Analyst at a financial services firm with 10,001+ employees

The graphical capabilities could be better. They are also cumbersome, and they are limited compared to Tableau, Power BI, or even Business Objects to a certain extent and Cognos. The error logging isn't great either. The errors that come out when you schedule aren't easy to understand.

I find how they filter within a query quite cumbersome and difficult to debug if somebody else has done it. You can see as you build, and I think that's where the problem is. It doesn't lend itself to debug something. For example, if you create a formula that's quite complicated, it's not easy to understand what goes with what. 

It becomes spaghetti, and it's very difficult to unpick. That's really my gripe about it, and in some ways, it's too flexible. It tries to be a Jack of all trades when it's not. I think a lot of these products, if they concentrate on trying to produce your reports, then that's fine. But when they're trying to do all sorts of other things as well, then it isn't very easy.

We get lots of support from Oracle, but I think the problem is that we get many invalid file operations. Nobody understands why. It can be a multitude of reasons, but no one reason could cause it. That's just one of the issues we've had in the last year. But the scope of reporting has gone through the roof over the previous 12 to 18 months.

We want an end-of-life OBIEE in our environment because some of the infrastructure runs unclustered. We weren't allowed to go clustered for some reason, and we never knew why. Unfortunately, going down that route means that the platform we run it on, WebLogic, has now become non-standard within our organization.

Everything's been moved off it and onto other platforms. Unfortunately, our OBIEE runs on that platform, and we're being pushed down different routes, and we don't know where we're going at the moment. Within the next two years, I don't think we'll have OBIEE in our part of the business.

In the next release, I think having the capability of being able to develop and then promote to a production environment rather than having to have separate environments will help. I know that Tableau and Power BI can be created on a desktop application, and then when it's ready to go live, you can promote it. 

View full review »
Buyer's Guide
Oracle OBIEE
June 2022
Learn what your peers think about Oracle OBIEE. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.
Robin Saikat Chatterjee - PeerSpot reviewer
Head of Oracle Exadata Centre of Excellence at Tata Consultancy Services

One significant improvement is the need for simplification. The set up could be more intuitive. An enterprise setup with HA and DR are pretty complex and to get a robust solution one has to play around with Real Application Cluster data sources and FAN notifications as well as WebLogic clustering and external load balancers. SSO also is not that simple to set up especially if you want all your Oracle systems to use the same SSO solution, i.e., no cheating with direct LDAP connectivity.


So there is no simple setup for HA deployment. you need to manually create a cluster deploy into the cluster , reconfigure the datasources to high availability data sources etc. Unlike hyperion for example which has automated configurator scripts that do a lot of the under covers work for the administrator and hence simplifies the ha installation.


View full review »
CM
Principal Business Intelligence Architect at a computer software company with 10,001+ employees

We do like Oracle Visual Analyzer, but we do feel that it's quite immature in comparison to its competitors. There is still quite a lot of catch-up to be done, but it does still have some unique value add.

It is not very stable, and it is not consistently improved. There are a lot of gaps when it comes to design. The documentation and support from Oracle on the vision have been pretty bad over the last six years.

It is very biased towards Oracle infrastructure. One of the major red flags we have at the moment against Oracle is that it doesn't support deployment on other cloud providers. We're quite heavily vested in AWS as our infrastructure, and Oracle is yet to formally support deploying on those virtual infrastructure instances. That's quite disappointing, and it also cuts them out of over 70% of the market.

Its deployment is complicated in comparison to other solutions.

View full review »
Ricardo Giampaoli - PeerSpot reviewer
EPM/BI certified Consultant, Oracle ACE and TeraCorp Consulting CEO at TeraCorp Consulting

It needs better parent-child dimension options that don't need to pass through OBIEE to build it. It's an easier way to update the model in case of a change of dimension size or sources.

Also, it needs better and more dynamic graphics. There are a lot of tools with better graphics and big part of BI is about this.

View full review »
MS
Senior Consultant at a computer software company with 501-1,000 employees

In the 11G model, there are restricted visualizations, whereas in Oracle Analytics Cloud we have multiple different variations of visualization. If there was a way of presenting the data in a pictorial way, it would be very helpful. Right now, the solution, at least in that deployment model, is lacking a number of visualizations.

The solution needs to be easier to scale.

View full review »
DM
Architect Team Lead at ITC Infotech

I find I prefer Oracle OAC over OBIEE. It's more advanced, has artificial intelligence, and there's more that we can do with it in general. OBIEE is lacking features.

The reporting could be better. We can only develop standard PDF reports. We don't have reports that show analytics. It doesn't generate barcodes at the top and it doesn't have the ability to show notes. The reporting system needs to introduce logic so that we can make the reporting more flexible.

Writing any code takes a long time. Merging data is also a long and tedious process. 

View full review »
VaclavBiba - PeerSpot reviewer
BI/DW Consultant at Neit consulting

There are pages about its limitations in Gartner documents. My understanding is they are working to improve themselves. There aren't any really big issues and they're already in the cloud, therefore, largely there isn't too much that's lacking.

The pricing model could be improved. Right now, it's quite confusing. Many customers have this feeling that it's a super-expensive option.

Currently, the solution is based on three pillars. The first is the BI publisher and it used to be a single product. The second is Oracle and Oracle Business Intelligence, the core component. It used to be a CBO product. Then, thirdly, you have this new Oracle visual analyzer. Now, all of these are wrapped into one Oracle analytics product. However, the integration between (or among) these three products is not 100% complete. This is the area where improvements can be made.

View full review »
SN
Technical Lead at a computer software company with 10,001+ employees

There are a lot of aspects of Oracle OBIEE that are exceptionally complicated, make things unnecessarily difficult for everyone who uses it. In terms of the integrations, Oracle needs to improve a little more, but I believe that they have tried to capture all those issues. The issues we are facing in the Oracle OBIEE 12C versions, in the Oracle Analytical Server Center or Analytical Cloud versions, Oracle has managed to overcome the challenges.

Oracle OBIEE could improve its marketing. There is no additional training, trials, or something else needed. Oracle has  Business partners, such as TCS and Cognizant. All the business partners for Oracle, I never saw that they ever tried to market the Oracle tools for visualization.  We can do visualization of data with it, large analytical data, and analytical analysis. They never try to market it in that way. All I understood as it is a tool for extracting large amounts of data. They need to improve on their outreach.

View full review »
RG
AVP at a financial services firm with 10,001+ employees

Implementation is a little cumbersome and requires expertise. From the support perspective, it seems that they are a level behind. Another, thing is if you're working in the 12.2.1.3 version, fields don't come with proper venues and proper testing is lacking. For an additional feature, I'd like to see data science and functions added.

View full review »
MI
General Manager Information Technology at a engineering company with 201-500 employees

In the on-premises version, the feature for connecting and selecting the data between the databases looks a bit cumbersome, but I am not sure. The person who is using it takes a lot of time to design a data warehouse. When I ask him why is it taking this long, I get a response that this is something that he has to design, and there are different tools that are available. He has to write the ETL and design the warehouse according to the customer's requirement, which takes a lot of time.

Its visualization should be enhanced, and there should be a feature where you can easily create your custom data warehouse.

View full review »
SA
Principal Consultant at a tech services company with 10,001+ employees

Even though we have a feature to enable the physical query to be seen in the log, in case of any issues, it is challenging to debug and see or identify where is the issue. For example, we designed the OBIEE repository and deployed it into the server, and we are now accessing and creating a report. For some reason, if the report is not working as expected, it is very difficult to identify the issue. 

We have a feature to see the physical query that is being generated in the central OBIEE server. I feel that this feature should have been available at the repository level so that while designing the repository, we can select the presentation columns and the query it is going to create. This will avoid the additional task of deploying a feature into the server and then testing the report. It will also make the implementation process friendly if, while designing the repository, we can see:

  • How is a feature working?
  • Are any of the presentation columns selected?
  • How is the query being generated?
  • Which query is being generated?
  • Are any joints used?
  • What kind of joints are used?

Having this kind of information will make Oracle OBIEE more powerful and developer-friendly.

View full review »
AE
Obiee HR Technologies Specialist at a tech vendor with 10,001+ employees

Rigidity and speed are areas that could be improved. Everything has to move quickly in today's world, especially in the data world. Everyone wants it right now.

Having a system is great, and when you code it correctly, it can get the job done. However, a modern solution takes a long time; it moves much slower than some other things. You have products such as Tableau, and there are other data science tools out there churning through just as much data. Obviously, that element is not intended to be a data science tool in and of itself. It's more of a reporting tool than anything else. Expanding beyond pure data reporting and into analytics, or expanding data science, would be areas for improvement.

View full review »
VG
Director at a tech services company with 10,001+ employees

We were disappointed with Oracle OBIEE, because of the performance.

In terms of an analytical tool, it is quite outdated. End-users want to receive results quickly and to be able to view millions of rows of data in a matter of seconds. OBIEE was unable of doing so because of the way it was modeled and developed. It requires it to go to the database, run the SQL, and then fetch the result for each query. That procedure took a long time to complete.

There are a variety of different in-memory tools available; the data is loaded into the server's RAM or memory, and all requests, including data requests, are served from the RAM, making it extremely fast.

If you look at Qlik Sense or Tableau, or perhaps some other products on the market, such as Power BI, you'll notice that they have all of the data in RAM.

The performance and the complex setup are the main reason for switching to Qlik Sense. 

View full review »
AS
Senior Software Developer at Sopra

Managing the OB applications requires a high level of experience, and in that sense, the solution is quite heavy. Although the solution offers some direct reporting, I'd like to see something on the database. The way things are now you need to go through an intermediate layer rather than connecting directly to the database which would enable you to immediately start building a report.

View full review »
SV
Process System Engineer at a comms service provider with 1,001-5,000 employees

This solution needs a better security management system and I think there is room for improvement in terms of giving access to people in a more effective way. I'd like to see additional features and performance can be improved too. 

View full review »
Ngole Ngole - PeerSpot reviewer
Oracle Techno Sales consultant at a tech services company with 201-500 employees

Warehouse and business intelligence are two different things, but OBIEE also has some warehouse features in it. I would like to see some of those capabilities improved.

View full review »
Kumar T - PeerSpot reviewer
CEO & PRACTICE HEAD at a tech services company with 11-50 employees

The complexity of this product means that you need to have a technical team to develop the reports, although this is also true for products like Microsoft BI and Zoho.

Performance-wise, there may be some room for improvement.

View full review »
VC
Sr. Solution Architect at a computer software company with 5,001-10,000 employees

I have encountered certain performance issues which have required us to play around with and streamline the data. The performance could be better. 

Regarding the announcements, the data integration should be simplified, as the work is also with the clients. Since we have our different sources of data, those integrations must be maintained, which translates into a cost for our clients. Simplifying the process would save them a lot. 

View full review »
NM
Director- IT Strategy & Transformation at a manufacturing company with 10,001+ employees

It should have more self-service capabilities.

View full review »
Mahmoud Ahmed - PeerSpot reviewer
Enterprise Performance Management Senior Consultant at a consultancy with 11-50 employees

It would be better if it had a wide range of visualization options. For example, Microsoft Power BI has an extensive range of visualization options, but it's not available in OBIEE. There are also some conflicts because it's complicated, but the cloud application is easier. They added some features for ETL with the on-premises application, but we need a different or a separate application for ETL in the cloud. In the next release, I would like to have more AI features.

View full review »
AK
Technical Consultant at a consumer goods company with 1,001-5,000 employees

There could be better integration with other solutions, such as Microsoft Office.

View full review »
Jp Hoedenaeken - PeerSpot reviewer
Data Architect & BI Manager at RTBF

Migration on premisses should be easier (but is easier if you migrate to the cloud).

More self-services should be available for the users.

View full review »
Rajesh S - PeerSpot reviewer
Technical Manager at a computer software company with 201-500 employees

For a beginner, this is a product that is difficult to learn. You cannot learn it quickly.

There are a few utilization-level limitations in Oracle OBIEE that can be improved. However, they are releasing another product called OAS, Oracle Analytics Server, which might include a few more utilizations.

View full review »
TM
BI Team Lead at a manufacturing company with 501-1,000 employees

It takes a lot of maintenance to support the architecture, which is something that should be improved. Having a more simplified architecture would be better.

It should be easier to make changes or enhancements, as it is a long process to make a change in the system.

View full review »
Csongor Tőzsér - PeerSpot reviewer
Oracle BI developer at Ulyssys Kft

Oracle OBIEE could improve the visualizations, such as diagrams, charts, and graphical user interface. Other tools on the market have better graphical visualizations this Oracle OBIEE.

View full review »
AnjanaPathare - PeerSpot reviewer
Technical Lead at a tech services company with 10,001+ employees

It could be more user-friendly. For example, the RPD layer could be more straightforward. From a user's point of view, the visualization, especially the graphs, are not as attractive when compared to other tools like QlikView and Qlik Sense.

View full review »
DR
Presidente at EDR

I would like to see Machine Learning included in this solution.

View full review »
SB
CEO at a consultancy with 11-50 employees

I would like to see the data wrangling features enhanced.

This product is not easy to use and there is a steep learning curve.

View full review »
TS
Senior Manager Analytic & Insights at a hospitality company with 10,001+ employees

The performance could improve and in a future release, they could provide more virtualization options.

View full review »
PT
Associate Lead at a tech services company with 501-1,000 employees

It is complex for designing RPD, and it can be simpler. Their support can also be improved in terms of response time.

View full review »
AP
User

The ability to migrate from one version to another, such as doing so from version 11 to an upgraded 12 of Oracle business environment, can be difficult. The usage is not straightforward. 

View full review »
Buyer's Guide
Oracle OBIEE
June 2022
Learn what your peers think about Oracle OBIEE. Get advice and tips from experienced pros sharing their opinions. Updated: June 2022.
609,272 professionals have used our research since 2012.