我使用了一些报告平台(SAP Business Objects 和其他一些第三方应用程序)。我有 pl-sql 经验,但我是 Oracle BI 的新手。
此时,我有一些困惑的问题。
第一个是Oracle BI中有很多术语,但我不知道我应该了解哪些产品,或者我可以按什么顺序学习和体验这些平台。
例如您可以创建仪表板,通过Oracle BI进行分析。术语/产品,如 Essbase、Hyperion、Warehouse Builder、ODI 等。
我的第二个问题是:
我想在同一台电脑上安装 Oracle 11g 和 Oracle BI 11。但我在一些论坛上听到和读到他们不在同一台计算机上工作。但我想在我的个人电脑上安装 BI 工具,以便在家练习。如何在我的电脑上安装这两个产品? (我的电脑是 64 位)
谢谢和问候
I used some reporting platforms ( SAP Business Objects and some other third party applications). I have pl-sql experience but I am new to Oracle BI.
At this point, I have some questions which confuses my mind.
First one is there are lots of terminology in Oracle BI but I do not know which products should I know, or in which order I can learn and experience these platforms.
For example you can create dashboards, analysis by Oracle BI. Terms/products like Essbase, Hyperion, Warehouse Builder, ODI etc.
My second question is :
I want to install Oracle 11g and Oracle BI 11 in the same pc. But I hearded and read on some forums that they are not working on the same computer. But I want to setup BI tool to my personal computer for practicing in my home. How can I install these two products in my pc? ( My pc is 64 bit)
Thanks&Regards
发布评论
评论(5)
只是点它;-)
http://gerardnico.com/wiki/dat/obiee/installation_11.1
您可以在同一台机器上拥有数据库和 obee。
干杯
尼科
Just dot it ;-)
http://gerardnico.com/wiki/dat/obiee/installation_11.1
You can have a database and obiee on the same machine.
Cheers
Nico
您需要安装 Oracle DB 11g,然后安装最新的 OBIEE 11g。 (请注意,您需要先安装 RCU,然后才能继续安装 OBIEE 11g)。您可以从 otn.oracle.com 获取它们。安装文档可以指导您完成整个设置;希望不会有任何意外。
之后,安装示例应用程序并按照说明创建新的分析、仪表板等。之后,我确信您将熟悉术语和工作流程。
You need to install Oracle DB 11g followed by the latest OBIEE 11g installation. (note that you need to install RCU before you proceed with the OBIEE 11g install). You can get both of them from otn.oracle.com. The Install documentation can guide you in the entire setup; and hopefully there should be no surprises.
After that, install the Sample App and follow the instructions to create new analysis, dashboards etc. After this, am sure you will be upto speed with the terminologies and the workflows.
查看 wiki 上的这篇文章 - 应该能让您对 OBIEE 堆栈有基本的了解
http://en.wikipedia.org/wiki /Oracle_Business_Intelligence_Suite_Enterprise_Edition
您提到了 Warehouse Builder - Oracle 正在远离它,因此 ODI 将成为 ETL 工具的选择。
Check this post on wiki - should give you basic understanding on OBIEE stack
http://en.wikipedia.org/wiki/Oracle_Business_Intelligence_Suite_Enterprise_Edition
you mentioned Warehouse Builder - Oracle steering away from it, so ODI will be a choice of ETL tool.
对于 OBIEE,你还有很长的路要走,所以,坐下来,放松,享受这段旅程。您希望从 BI Foundation 开始,其中包括 BI Server 和 Answers,然后再转向 Essbase、Hyperion、Warehouse Builder、ODI 等产品。
我会从
简单安装 OBIEE。我更喜欢 Linux,但您也可以使用 Windows。 8GB就不错了。以下每个选项都有一个图形安装向导,可指导您完成选择。
a.安装数据库
b.运行 RCU
c.安装 OBIEE
d.安装用于创建或修改存储库的 BI 管理工具
执行一些操作 教程。我将从以下内容开始并按此顺序。
a.使用 Oracle BI 11g 管理工具创建存储库 - 如果您是认真的 OBIEE 专业人士,则必须这样做
b.创建分析和构建仪表板 - 用于临时分析 - 重要
c. Oracle BI Publisher 入门 - 可选 - 如果您关心已发布或打印的报告或一些快速而肮脏的报告,而无需在存储库中创建模型。
如果您在 Windows 上安装,则需要避免这些常见错误。
You have a long journey ahead of you for OBIEE so, sit back, relax and enjoy the ride. You want to start with the BI Foundation which includes BI Server and Answers, before moving on to products like Essbase, Hyperion, Warehouse Builder, ODI etc.
I would start by
Doing a simple install of OBIEE. I prefer Linux but you can use Windows as well. 8GB would be nice. Each of the following has a graphical install wizard which guides you through the choices.
a. Install the DB
b. Run the RCU
c. Install OBIEE
d. Install BI Admin tool for creating or modifying the repository
Do some tutorials provided by Oracle. I would start with the following and in this order.
a. Creating a Repository Using the Oracle BI 11g Administration Tool - MANDATORY if you are a serious OBIEE professional
b. Creating Analyses and Building Dashboards - For Adhoc Analysis - Important
c. Getting Started with Oracle BI Publisher - OPTIONAL - If you care for published or printed reports or for some quick and dirty reporting, without having to create a model in the repository.
You want to avoid these common mistakes if you are installing on Windows.
您可以在同一台计算机上安装 Oracle 11g 和 Oracle BI,不会出现任何问题。
就第二个问题而言,您只需了解 Oracle BI、pl/sql 和 11g 即可创建报告。需要 Pl/Sql 来编写报告的预处理器和后处理器。仅需要 ESS 来安排报告,因此您在学习阶段不需要它。以后可以学一下
You can install Oracle 11g ad Oracle BI in the same machine without any issue.
As far as the second question is concerned, you can create your reports with the knowledge of only Oracle BI , pl/sql and 11g. Pl/Sql is required to writhe pre and post procesors for the report. ESS will only be required to schedule the report and as such you won't require it in the learning phase. You can learn it later