官术网_书友最值得收藏!

A typical network setup

In the following diagram, we show you a high-level image of the Essbase installation you have just completed. This is a very typical set up for most operations.

A typical network setup

To help you understand and recognize your creation, the network diagram is divided into four sections which are explained below:

  1. Raw data: Loading data from a little to a lot is easy in Essbase. Data can be sent directly to the database using the "Lock and Send" feature of the Oracle Essbase Add-in for Microsoft Excel. Flat files received from other systems can be easily rendered Essbase-friendly, using convenient and easy to use data load rules. Finally, vast amounts of data can be loaded using SQL data load rules that interface directly with relational databases.
  2. The Essbase server: Running on the Essbase server is also something known as the Essbase agent. Depending on your needs, it is always best to try and use a dedicated server for your Essbase service. But don't worry, if that's not possible, we've found that Essbase does integrate nicely with other applications that have been installed.
  3. The developer client: This is on the desktop workstation that EAS is installed on. You will also want to have Microsoft Excel and the Oracle Essbase Add-in for Microsoft Excel installed on this machine as well. A setup like this allows the developer to quickly create and test many pieces of an Essbase application, such as calculation results, data load validations, and so on.
  4. End-user PC: This is your typical networked workstation that has decent computing power and storage. Having Microsoft Excel and the Oracle Essbase Add-in for Microsoft Excel installed are all that is necessary to provide the end-user with an extremely capable analysis and reporting tool.
主站蜘蛛池模板: 宽甸| 黄浦区| 丽江市| 西贡区| 滦南县| 双江| 永寿县| 阳东县| 偃师市| 霍城县| 通渭县| 平阴县| 天峻县| 武定县| 永泰县| 延长县| 海阳市| 易门县| 新野县| 冷水江市| 阜平县| 锦屏县| 徐汇区| 卢氏县| 八宿县| 明溪县| 休宁县| 德钦县| 武威市| 康保县| 伽师县| 兖州市| 大足县| 湟源县| 顺义区| 清涧县| 儋州市| 资源县| 云龙县| 茶陵县| 万源市|