Repository Directory : Specify the directory where the Reporting and Analysis repository data is stored. For example:. If you are upgrading from a previous release, ensure that the repository location of the previous release is specified. Under this directory, the bin directory contains start and stop scripts for all deployed applications. For each application, there is also a setCustomParamsProduct.
Deploy Essbase in standalone mode Select to use legacy security for Essbase Server instead of Shared Services security. By selecting this option, you can shut down Shared Services and Oracle to maximize memory. You have to register first against the Essbase - Servers before you can use it. You can connect to an Essbase - Servers with :. If you can't connect for any reasons, first perform an Epm System Diagnostic to find the culprit.
The procedure you should follow if an error occurs is to try to run any application for instance, Essbase in a command window. In this way, any errors will be displayed in the window. You can get this error when you start the essbase server script and than the essbase server service is started.
To resolve it, stop the Essbase Server Service. It's an error that can be caused by many components of the system and the best way to find the source is to perform an Epm System Diagnostic. Shared Services Security. Refreshing security between Shared Services and Essbase may fail when a large number of users belong to a large number of groups. In general, the problem occurs when the number of combinations of users and groups exceeds 32, Adding a currency partition to the main database when other currency partitions are already present may cause Essbase to terminate abnormally during restructure.
Server Administration. If a hostname is longer than 30 characters, creating a new application will succeed; however, creating a new database may cause Essbase to terminate abnormally.
If you define more than one volume to span the PAG and IND files on a database that is linked to a currency database, when you stop and start the application, the application terminates abnormally.
Essbase Studio. The MaxL option to remove zeros when merging incremental data slices on an aggregate storage database does not work. The zeros are not removed. MDX queries with a large number of substitution variables may cause Essbase to terminate abnormally.
Unexpected database restructuring occurs when a dynamic calc member is added to a dense dimension. Retrievals on aggregate storage databases with time balance may fail with out of memory errors. Essbase may terminate abnormally when you kill a data load request on an aggregate storage database. Some errors occurring at the beginning of a data load to an aggregate storage database result in the load buffer being inaccessible. If you try to use or destroy the load buffer, it will result in the error message "Cannot proceed while the cube is being loaded.
Spreadsheet Add-in. With Spreadsheet Add-in enabled, performing the following series of actions may result in an error:. Disconnect your network cable. Log off the system. Log back on. Open Excel. Visual Explorer. When partitioned outlines are synchronized, aliases are added to target members even though the source members do not have aliases.
Scripts that rename Aggregate Storage databases containing Integration Services data cause the Essbase applications to terminate abnormally. Data load. An incorrectly defined data load may cause the following error to be created. Also, Essbase may have to be shut down forcefully. Cannot load data. If a Dynamic Calc member has a formula containing a cross-reference to another database, changing the order of months and years causes incorrect results.
Hybrid Analysis. Certain models built by Hybrid Analysis cause Essbase to terminate abnormally when querying in Web Analysis. Instead of pointing to https , it points to http.
Time Balance. Aggregate storage databases with shared members, time balance tags, and hierarchies enabled in the Time dimension can produce validation errors in certain instances. For example, when the main hierarchy is broken into months and the alternate hierarchy is broken into weeks, and part of a week falls in one month and another part of that week falls in another month, this can cause a validation error even though the outline is correct.
Aggregate storage target databases in transparent partitions may terminate abnormally if the partition is defined on level zero members. Essbase may terminate abnormally when using an Essbase may terminate abnormally when an In Russian language Essbase only, Essbase shortcut keys are not working as expected.
Using a calc script to perform data export operations against members of a sparse dimension causes incorrect data to be exported. Essbase Agent. An optimization to ensure that logins do not block applications takes an excessive amount of time to start up. Linked Reporting Objects. If a grid contains two consecutive cells returning multiple LROs with objects of different types, the returned LRO types are not correct. This happens only if the cell value is either zero or missing.
If an aggregate storage outline is built using an ESSCMD dimension build, the outline is created with short attribute names, which is incorrect. The outline should be created with long attribute names. It should say Oracle Essbase. Select File , then Open. A blank worksheet opens. Note: Upon using Excel, two dialog boxes may be displayed warning that the esstoolb. Note: If you have toolbars turned off in Excel, you do not see the Essbase toolbar immediately.
In this step, you need to specify the Essbase server directory. If you do nothing, it will default to the home directory you selected in the previous step. In this step, you are asked to select either the Typical or Custom installation. The Custom installation includes all of the components and allows you to pick which ones are required for your installation. We suggest you select the Typical installation for now as you can add other components at anytime in the future. In this step, you are asking the wizard to update your system environment variables with the new Essbase system variables you have chosen in the previous two steps.
We will discuss this file and the settings later in the book. By default, the installer wizard is set to update the environment variables. Please leave it as is and click Next. This is to ensure proper communication with other applications and is the Unicode setting. This step summarizes all of the components that are to be installed during this present installation. Check the information carefully to confirm you have the locations correct, as well as the selected Oracle Essbase components.
If there are any corrections that need to be made, use the Back button to go back and fix what is needed. This is your last chance before the wizard begins the actual installation. This step basically tells you that the Essbase installation is in progress.
Take a break, read the install notes as they flash on the screen. Upon successful installation, you are now asked if you want to launch the system configuration tool.
The default is selected and it is recommended you use it now to confirm your configuration one more time. Yes, another one of these screens. This is now the configuration tool wizard. You are again asked to select the language for the wizard.
Even though it is part of the Essbase analytics server software, what the heck, you may want to use a different language. Select English or the system will select English for you. Once again, this will determine what language the installation screens are presented in.
On the screen below, you are presented with the Essbase System 9 components you have installed on your server and their configuration status. Place a check mark next to all of the components that are flagged as pending, as now is the best time to set up your components and verify their proper configuration. Looking at the following screenshot, you can see that all choices are pending. Since shared services has not been installed, you will only want to place a check on Essbase Server , Product Options and Register Analytic Services Server as Windows Service at this time.
This is also where you will enter your initial supervisor account ID and password, so make sure you do not forget it. After successful installation and configuration, you will see the following screen. You now have a fully functioning Essbase service installed on your server, complete with full Essbase API functionality. See the next step for what to do at the initial start up.
0コメント