We just raised a $30M Series A: Read our story
2015-08-30T13:14:00Z

What needs improvement with Oracle OBIEE?

12

Please share with the community what you think needs improvement with Oracle OBIEE.

What are its weaknesses? What would you like to see changed in a future version?

ITCS user
Guest
3030 Answers

author avatar
Top 20Real User

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.

2021-09-23T17:35:24Z
author avatar
Top 20MSP

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.

2021-08-03T12:16:03Z
author avatar
Top 5Real User

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

2021-07-07T13:43:36Z
author avatar
Top 20Consultant

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

2021-07-04T10:35:05Z
author avatar
Top 10Real User

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.

2021-06-05T09:17:32Z
author avatar
Top 20MSP

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

2021-04-05T18:05:00Z
author avatar
Top 20Real User

It should have more self-service capabilities.

2021-03-31T07:24:22Z
author avatar
Top 10Real User

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.

2021-03-26T14:34:23Z
author avatar
Top 20Real User

I would like to see the data wrangling features enhanced. This product is not easy to use and there is a steep learning curve.

2021-01-23T00:46:53Z
author avatar
Top 10Real User

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.

2021-01-04T15:36:11Z
author avatar
Top 10Real User

Migration on premisses should be easier (but is easier if you migrate to the cloud). More self-services should be available for the users.

2020-11-04T08:42:59Z
author avatar
Top 10Consultant

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.

2020-11-02T20:39:54Z
author avatar
Top 20Real User

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.

2020-10-28T15:48:41Z
author avatar
Top 20MSP

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.

2020-10-08T07:25:19Z
author avatar
Top 20Real User

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.

2020-09-16T08:18:38Z
author avatar
Top 20MSP

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.

2020-08-30T08:33:33Z
author avatar
Top 5LeaderboardReal User

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.

2019-05-04T15:38:00Z
author avatar
Real User

* Visualization of OBIEE needs a boost. * The data mashup functionality and ease of use for end users also need to be improved a lot.

2019-04-10T01:33:00Z
author avatar
Real User

They should develop greater visualization because their visualization isn't industry leading at the moment. The way you pull the data and see the data compared to other platforms, they're lagging a little bit behind. Also, their cost. I've got Oracle account managers trying to persuade me every day to purchase these licenses. Once you purchase OBIEE, then you have to purchase the virtualization and then you have to purchase the mobile license to operate on the mobile. It's really expensive.

2019-02-10T10:06:00Z
author avatar
Real User

The functionality is in need of improvement. We find the graphs need to be upgraded.

2018-10-24T14:07:00Z
author avatar
Real User

I think there is a lot of room for improvement. This solution is weak in the data science perspective. I have past data science experience. And, I find that there is a lot of room for improvement in terms of incorporating more advanced statistical modeling into the product. I come from a data science background. I find that there is a lot of room for improvement to incorporate more advanced statistical modeling into the product.

2018-10-08T17:34:00Z
author avatar
Real User

It is not a good product for data visualization. And, its functionality is lacking.

2018-10-07T15:56:00Z
author avatar
Real User

Metadata management function: Sometimes, our business requirements need to load reference data into the data model.

2018-09-19T05:48:00Z
author avatar
Real User

I would like more graphical charts. While it is a user-friendly, data-driven tool, the data modeling should be easier to use.

2018-08-13T07:28:00Z
author avatar
Real User

Now, we have more demands to load data somewhere quickly, not seeped into a model, like data warehouse model. We need to load it somewhere like a data lake and have a tool which can analyze the information very quickly without creating a model. So, our business has a need to have a sandbox, or something similar to it analyze unstructured data that does not fit into the data warehouse model, along with joining unstructured data with structured data from the data warehouse. However, I am not sure that the BI tool is the right tool to do this, it is more of a data discovery tool. With Oracle BI, we need technology to create the model, then the business uses this model to create reports. If they wanted to analyze data quickly which is not in the data warehouse model, then we cannot use Oracle BI for it, or it's not so suitable.

2018-08-01T07:08:00Z
author avatar
Real User

One feature I would definitely like to see is the ability to provide the in-memory data. Oracle might have some plugins but, as of now, that feature isn't available out-of-the-box. You might have to purchase that feature. This is the feature that is most lacking, which we would like to have in the next release. Also, the overall architecture. Currently, it comes in an Oracle suite. We want to have it come as a separate product and which is very easy to install, migrate, deploy etc.

2018-07-25T07:31:00Z
author avatar
Real User

From the point of view of strategic management, I would like to have a feature, perhaps a form after we get to the KPI dashboard, to be used to note if something unusual happens in the operations. That way we could record extreme KPI situations, and track why a number is very low or too high.

2018-07-23T06:38:00Z
author avatar
Top 10Consultant

The WebLogic administration could be more intuitive or simplified especially when you are focused on OBIEE

2016-07-17T23:35:00Z
author avatar
Top 5LeaderboardConsultant

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.

2016-05-01T11:13:00Z
author avatar
Top 10Consultant

I think there are some issues to be solved, and it needs some visual improvements, especially on the charts, but it is still the best solution in my opinion.

2015-08-30T13:14:00Z
Learn what your peers think about Oracle OBIEE. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
541,708 professionals have used our research since 2012.