oracle 有人在使用 OBIEE（以前称为 Siebel Analytics）吗？你的经历是什么

Is anybody using OBIEE (formerly Siebel Analytics) ? What is your experience

提问by user33188

We are in the process of selecting BI stack for our data warehouse. The top contenders are OBIEE = Oracle BI Enterprise Edition (formerly Siebel Analytics) and Microstrategy.

我们正在为我们的数据仓库选择 BI 堆栈。主要竞争者是 OBIEE = Oracle BI 企业版（以前称为 Siebel Analytics）和 Microstrategy。

Has anyone worked with OBIEE? Lessons learned? General impressions? Flaws, strengths?

有人在 OBIEE 工作过吗？得到教训？一般印象？缺点，优点？

回答by user33188

I've been involved in 20 OBIEE projects for the past 6 years. It's a good ROLAP product. It has a flexible, mostly intuitive UI that end users typically like. HTML, Javascript, and some Flash (charts) is used for presentation. There is a presentation server that runs under a web server (or app server) and the core of the tool, the analytics engine runs separately. Generally speaking the tool generates efficient SQL. Performance overall is generally good, but is dependent on the source data structures and the types of reporting being attempted.

在过去的 6 年里，我参与了 20 个 OBIEE 项目。这是一个很好的 ROLAP 产品。它具有最终用户通常喜欢的灵活且直观的 UI。HTML、Javascript 和一些 Flash（图表）用于演示。有一个在 web 服务器（或应用服务器）下运行的演示服务器和工具的核心，分析引擎单独运行。一般来说，该工具生成高效的 SQL。总体性能通常良好，但取决于源数据结构和尝试的报告类型。

The metadata layer is well designed and extremely (almost to a fault) flexible, though it could stand to be much better documented. The tool expects to work with traditional star schemas. It works well with all the major RDBMSs. It has multi-level caching and is very flexible with authentication, functionality access, and data security. It doesn't do everything I'd like it to do, but taken as a whole, it's a first class application. Most of it's flaws are little things, there really isn't anything major. I'd say from a presentation perspective it's prompting is far weaker than it could be.

元数据层设计精良，非常灵活（几乎是一个错误），尽管它可以更好地记录。该工具期望与传统的星型模式一起使用。它适用于所有主要的 RDBMS。它具有多级缓存，并且在身份验证、功能访问和数据安全方面非常灵活。它没有完成我希望它做的所有事情，但总的来说，它是一流的应用程序。它的大部分缺陷都是小事，真的没有什么大不了的。我会说从演示的角度来看，它的提示比它可能的要弱得多。

It's not a cube tool (though it can source data from cubes) and it's not meant to be a tool for generating massive reports (long lists and massive data sets presented to end users) though it does get used that way. If anything its biggest flaw is probably the cost, but it's probably comparable to all the other enterprise players.

它不是一个多维数据集工具（尽管它可以从多维数据集中获取数据），也不是用来生成大量报告（向最终用户提供长列表和大量数据集）的工具，尽管它确实以这种方式使用。如果有的话，它最大的缺陷可能是成本，但它可能与所有其他企业参与者相当。

I don't know a lot about Microstrategy, but a friend who has worked with both says it has a great front end and a weak back end. He prefers OBIEE considerably, though he's developer biased. It really is quite easy to build physical, logical, and presentation metadata in the tool. As with all warehouses, the hard work is mostly in the ETL, followed by good BA work and good performance tuning in the DB.

我对 Microstrategy 知之甚少，但与两者合作过的朋友说，它的前端很好，后端很弱。尽管他偏向于开发人员，但他非常喜欢 OBIEE。在该工具中构建物理、逻辑和表示元数据确实非常容易。与所有仓库一样，艰苦的工作主要在 ETL，其次是良好的 BA 工作和 DB 中的良好性能调优。

回答by azzaxp

If you are Going for OBIEE, Go for the 11g version, It has Lot many Advantages, Advanced Features over the 10g. The 10g version is based on the OC4J, where as the 11g is based on the weblogic server. I haave worked on both the Administration part and BI Answers part, The Tools seems Quite easy in both. Building the Repository in Admin Part or Creating Dashboards and Reports on the Answers Part.

如果您要使用 OBIEE，请选择 11g 版本，它比 10g 具有很多优点和高级功能。10g 版本基于 OC4J，而 11g 版本基于 weblogic 服务器。我已经在管理部分和 BI Answers 部分工作过，工具在两者中似乎都很容易。在管理部分构建存储库或在答案部分创建仪表板和报告。

Well to speak on the Flaws, We faced a lot of Problem while installing, with very minimalistic knowledge, Ofcourse both on Weblogic server and OBIEE. But that should not be a problem if you have good enough Resource to do it. Again a major Requirement is the Hardware, For the OBIEE 11g, Experts say 8gb RAM is minimum requirement. Well we have worked with 2GB RAM's as well but it was really very Slow. So if you have an excellent hardware and trained staff, Its a great tool.

好吧，谈谈缺陷，我们在安装时遇到了很多问题，知识非常简单，当然在 Weblogic 服务器和 OBIEE 上。但是如果你有足够好的资源来做这件事，那应该不是问题。又一个主要要求是硬件，对于 OBIEE 11g，专家说 8gb RAM 是最低要求。好吧，我们也使用了 2GB RAM，但它真的很慢。因此，如果您拥有出色的硬件和训练有素的员工，它就是一个很好的工具。

回答by David Aldridge

I have used it in the past. I really like the architecture, but you could have a look around this link to see some more detailed descriptions on how people work with it: http://www.rittmanmead.com/blog/

我过去曾经使用过它。我真的很喜欢这个架构，但你可以看看这个链接，看看人们如何使用它的更详细的描述：http: //www.rittmanmead.com/blog/